练习数据库语句

#练习
 insert into product (name,price,count,introduction) values ('苹果',12,50,'我是一个红红的苹果,别问我苹果是谁');
 delete from product where name='苹果';
 update product set price=150 where id=2; 
 select * from product;
 select *from product where id=2;
 select id from product ;
 select * from product where name like '%大%';
 select name,price from product order by id asc;
 select name,price from product order by id desc;
 select id,name from product where price>1 && price<200;
 select distinct name from product where name like '%大%';
 select name from product  limit 1;