INSERT INTO test_table (ren_name,age,gender,birth) VALUES('张三',24,'男',NOW()); SELECT * FROM test_table; UPDATE test_table SET 字段='值',字段='值',字段='值' WHERE 字段='值'; DELETE FROM test_table; -- 删除表里面所有数据 DELETE FROM test_table WHERE sid=1;
-
« 上一篇:
MySQL-修改表结构、增加删除修改字段列、