sql 书写

USE test;
SHOW TABLES;
DESCRIBE admain;
SELECT * FROM admain;(效率低，企业开发不要用*)
INSERT admain (NAME,pwd,phone,email,gender,remark) VALUES (‘1’,‘1’,‘1’,‘1’,‘1’,‘1’);
UPDATE admain SET NAME=‘2’ WHERE phone=‘1’;
DELETE FROM admain WHERE phone=‘2’;
DROP TABLE admain(删表)
DELETE FROM admain WHERE 1=1;
IN | WHERE | JOIN ON | LEFT JOIN ON | RIGHT JOIN ON | BETWEEN IN | ORDER BY 顺序 逆序 | GROUP BY |HAVING |多重查询