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
【!!!可以