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 adma
原创
2022-05-14 16:13:36 ·
63 阅读 ·
0 评论