PHP教学-SQL语句,数据库增删改查练习_11.20

SQL语句

新增

INSERT INTO category (name,alias) VALUES (‘kehuanpian’,’科幻片’)

删除

DELETE FROM category WHERE id=7;

修改

UPDATE category SET name=’rh’,alias=’日韩影片’ WHERE id=7;

查询

SELECT *FROM category WHERE cate_id >=4 and cate_id <=6;