创建、删除数据库和表
CREATE DATABASE database_name;
DROP DATABASE IF EXISTS database_name;
CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype,
...
);
DELETE FROM table_name
TRUNCATE TABLE table_name;
DROP TABLE table_name;
连接、查询数据库
use database_name;
select database();
show databases;
插入数据
INSERT INTO table_name (column1, column2)
VALUES (valus1, value2);
增删改查
SELECT column1, cloumn2,..
FROM table_name;
SELECT column1, cloumn2,..
FROM table_name
WHERE condition;
SELECT column1, cloumn2,..
FROM table_name
ORDER BY column1[ASC|DESC], column2[ASC|DESC];
SELECT First_name, Last_name, salary, age
FROM emloyees
ORDER BY salary, age DESC;
UPDATE table_name
SET column1 = value1, column2 = value2
WHERE condition;
DELETE FROM table_name
WHERE condition