MySQL 增删改查 博客分类： 境-MySql SQL增删改查MYSQL增删改查增删改查

--增
INSERT INTO tab1 (id, NAMES) VALUES('5', '车行径');

--删
DELETE FROM tab1 WHERE id = '5';

--改
UPDATE tab1 SET NAMES = '吴中者' WHERE id = '2';

--查
SELECT id, NAMES FROM tab1 WHERE id = '2' LIMIT 0, 50;