创建数据库表，插入，修改，删除，查询

create database product

(code char(5) ,

namevarchr(20),

manu_date date,

exp_date date,

price float(10,3),

primary key(code)

)

insert into product (code,name manu_date,exp_date,price) values('10003','酸奶','2010-03-20','2010-9-20',30)

update product set name ='面包' where code= ‘1003’

delete from product where code = ‘1003’

select * ,count(*) from product where price <20 and exp_date >now ( )

---