2.2.?增、删、改、查SQL

//插入
INSERT INTO table_name VALUES(1,'zhangsan1',23);
//删除
DELETE FROM table_name WHERE id=1;
//更改
UPDATE table_name SET name='lisi' WHERE id=2;
//查找
SELECT * FROM table_name;
SELECT name,age FROM table_name WHERE id=3;
XML 地图 | Sitemap 地图