首先进入
C:\Windows\System32>mysql -uroot -p
下一步,确定要创建什么表,在这里我所建的是学生表
mysql> create database STUDENT_COURSE ;
Query OK, 1 row affected (0.01 sec)
接下来可以先查看一下表是否已经在库中,输入show database;
mysql> SHOW databases;
+--------------------+
| Database |
+--------------------+
| db_name |
| information_schema |
| mawy |
| mydn2 |
| mysql |
| performance_schema |
| student_course |
| sys |
+--------------------+
8 rows in set (0.01 sec)
下一步使用Student_course数据库
mysql> USE STUDENT_COURSE;
Database changed
然后就需要创建表命名,在这里我将表命名为学生表
mysql> CREATE TABLE STUDENT(
-> Sno int not null auto_increment primary key,
-> Sname varchar(10) not null,
-> Sex char(1) not null,
-> Sage tinyint(100) not null,
-> Sdept char(4) not null)comment = '学生表';
Query OK, 0 rows affected, 1 warning (0.01 sec)
然后要向表中插入数据
insert into Student (Name,Gender,Age,Sdept) values ('Breach','男',22,'体育系');
insert into Student (Name,Gender,Age,Sdept) values ('Phoenix','男',18,'数学系');
insert into Student (Name,Gender,Age,Sdept) values ('Omen','男',20,'物理系');
insert into Student (Name,Gender,Age,Sdept) values ('Jett','女',20,'数学系');
然后表建立成功,需要输入select * from student;语句 查看表
mysql> select * from Student;
+---------+--------+-----+--------+
| Name | Gender | Age | Sdept |
+---------+--------+-----+--------+
| Breach | 男 | 19 | 体育系 |
| Phoenix | 男 | 18 | 数学系 |
| Omen | 男 | 20 | 物理系 |
| Jett | 女 | 20 | 数学系 |
+---------+--------+-----+--------+
4 rows in set (0.00 sec)