MySQL数据库表操作1、创建表create table test(id int(11),name varchar(50));create table student(sno char(11) primary key,sname varchar(20) not null);2、创建表testuse democreate table test(id int(11),name varchar(50));3、创建一个表studentcreate table student(sno char(11) primary key,sname varchar(20) not null);4、创建表coursemysql> create table course -> ( -> cno varchar(20) primary key, -> course_name varchar(50) not null, -> cpno varchar(20), -> course_credit decimal(4,1) -> );5、增（为表添加新的字段）mysql> alter table student -> add ssex char(2) not null -> ;6、改（为表中字段设置默认值）mysql> alter table student -> alter ssex set default '男' -> ;7、更改表名法1mysql> rename table test to test2;法2mysql> alter table test2 -> rename to test;8、更改student表中ssex的数据类型为枚举类型（‘male’,'female'）,默认值为‘male’mysql> alter table student -> modify ssex enum('male','female') not null;