MySql命令语句大全:eg……一个建库和建表以及插入数据的实例dropdatabaseifexistsschool;//如果存在SCHOOL则删除createdatabaseschool;//建立库SCHOOLuseschool;//打开库SCHOOLcreatetableteacher//建立表TEACHER(idint(3)auto_incrementnotnullprimarykey,namechar(10)notnull,addressvarchar(70)default'江苏',yeardate);//建表结束