1.建表/库

        create database sc#建库

        use sc #进入库

        create table student(id int primary key auto_increment,

                                        name varchar(10),

                                        gender char(1));

                #建表

2.删表/库 

        drop database sc #删除库

        drop table wj #删除表

3.查看表的结构

        desc table_name;

4. 添加语句

        sc@sc 19:18  mysql>insert into student(id,name,gender) values(1,'wj','m');

5.查看表中数据 

        select  * from student;

6.修改 

root@sanchuang 16:12 mysql>alter table student add sex char(1);

添加字段

root@sanchuang 16:23 mysql>alter table student change sex gender char(1);

修改字段名称

root@sanchuang 16:23 mysql>alter table student modify gender char(2);

修改字段属性