基本操作
#数据库
CREATE DATEBASE Stu
USE Stu
DROP DATABASE Stu
SHOW DATABASES
#数据表
SHOW TABLES
CREATE TABLE IF NOT EXISTS studnts(
Id int(8) NOT NULL PRIMARY KEY,
name varchar(20) NOT NULL,
status tinyint(1) NOT NULL DEFAULT 1
);
DROP TABLE students
DESC students
#删除
DELETE FROM goods WHERE id=1 #id IN[1,2,3]
ORDER BY
UPDATE goods SET price=300 WHERE price<300
SELECT id,name FROM goods
WHERE name LIKE '%小米%'
Navicat