数据库及表的创建

cmd中输入代码

1，mysql -uroot -p //输入密码命令

2，show databases;            //查看现有数据库

3,create database 新建数据库名(eg:studentbb)；

4，可用步骤2查看是否成功新建数据库；

5，use studentbb ;

6,建表  eg：create table student(

sno  char(20），

sname char(20),

ssex char(2),

sage smallint,

sdept char(20));

7,插入数据：

insert  into  student

values ("2012151521","李勇","男",20,"sdept"),

("201215122","刘晨","女",19,"cs"),

（"201215123,"王敏","女",18,"ma"),

("201215125","张立","男",19,"is"）;

8,查看输入是否成功

select * from student