增加:INSERT INTO数据表(字段1,字段2…) VALUES (‘值1’,’值2’…)
删除:DELETE FROM movies WHERE mov_id = 9
修改: UPDATE category SET alias
=’日韩新片’ WHERE cate_id = 3
查询: SELECT FROM movies WHERE mov_id = 9
博客列表 >MYSQL数据库增删改查
增加:INSERT INTO数据表(字段1,字段2…) VALUES (‘值1’,’值2’…)
删除:DELETE FROM movies WHERE mov_id = 9
修改: UPDATE category SET alias
=’日韩新片’ WHERE cate_id = 3
查询: SELECT FROM movies WHERE mov_id = 9