SQL All In One

SQL All In One Structured Query Language database

SQL All In One

Structured Query Language

SQL is an ANSI (American National Standards Institute) standard, but there are different versions of the SQL language.

Most SQL database programs have their own proprietary extensions in addition to the SQL standard, but all of them support the major commands.

SQL是ANSI（美国国家标准学会）标准，但是有不同版本的SQL语言。

除SQL标准外，大多数SQL数据库程序都有其专有的扩展，但它们都支持主要命令。

SQL is used to access and manipulate a database.

MySQL is a program that understands SQL.

SQL can:

• insert, update, or delete records in a database.
• create new databases, table, stored procedures, views.
• retrieve data from a database, etc.

customers table

Basic SQL

# SHOW DATABASES;
SHOW DATABASES;

# SHOW TABLES;
SHOW TABLES;

# SHOW COLUMNS FROM table_name;
SHOW COLUMNS FROM customers;

CURD

# SELECT column_list FROM table_name;

SELECT FirstName FROM customers;

refs