MY_SQL学习

显示列

show columns from 表

修改字段

alter table ordery chang  price sex varchar(11)

向数据库里面插入数据

insert into ordery(orderyid,productname,userid,type,price,datetime) values('7','dapao','8','vip','12.5','2008-05-02  16:09:56');