SQL All In One
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
SQL
https://www.sololearn.com/Play/SQL/
https://www.w3schools.com/sql/
https://www.runoob.com/sql/sql-tutorial.html
DataBase All in One
https://www.cnblogs.com/xgqfrms/p/13570104.html
©xgqfrms 2012-2020
www.cnblogs.com 发布文章使用:只允许注册用户才可以访问!
本文首发于博客园,作者:xgqfrms,原文链接:https://www.cnblogs.com/xgqfrms/p/13586967.html
未经授权禁止转载,违者必究!