在制作购物车模块和菜品查询、图书查询模块时会用到的mysql语句

创建购物车表：

CREATE TABLE cart ( id int(11) NOT NULL AUTO_INCREMENT, user_id int(11) NOT NULL, product_id int(11) NOT NULL, quantity int(11) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

添加菜品：

INSERT INTO product (name, price, description) VALUES ('番茄炒蛋', 15, '家常菜，美味可口'); INSERT INTO product (name, price, description) VALUES ('鱼香肉丝', 20, '川菜经典，口感鲜美'); INSERT INTO product (name, price, description) VALUES ('宫保鸡丁', 18, '川菜名菜，麻辣味道');

查询菜品：

SELECT * FROM product WHERE name LIKE '%鸡丁%';

创建图书表：

CREATE TABLE book ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, author varchar(255) NOT NULL, price decimal(10,2) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

添加图书：

INSERT INTO book (name, author, price) VALUES ('红楼梦', '曹雪芹', 25.00); INSERT INTO book (name, author, price) VALUES ('西游记', '吴承恩', 20.00); INSERT INTO book (name, author, price) VALUES ('水浒传', '施耐庵', 18.00);

查询图书：

SELECT * FROM book WHERE author LIKE '%曹雪芹%';