Skip to content

Digital-Physics/mySQL-XAMPP-python

Repository files navigation

This is a Structured Query Language (SQL) repository.

XAMPP was used to serve a MySQL database locally. (http://localhost/phpmyadmin/)

MySQL is a popular Relational DataBase Management System (RDBMS). It is usually considered the best place to start before using other RDBMS such as MS SQL Server, PostgreSQL, etc.

Here's a CREATE TABLE and INSERT INTO SQL statement. (You should also look at the CRUD file):

XAMPP create table

We use python to query and keep the sqlalchemy query in text form as opposed to using methods like .WHERE(), .GROUPBY(), etc. See run_query.py and additional_SQL_queries.py

But developing in a .sql file can still be nice for autocomplete, linting, etc.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages