mysql中创建数据表
1,创建一个数据库为school
mysql>create database school;
返回:Query OK,1 row affected(0.00 sec)
2,建立了数据库,所以要先进入对应的数据库school中
mysql>use school;
返回:Database changed
3,然后创建一个表,使用默认值,语法字段名数据库类型 default
student表
mysql> create table student
-> (
-> studentnum varchar(20) primary key,
-> name varchar(10),
-> chinese float(5,2),
-> math float(5,2),
-> english float(5,2),
-> password varchar(30) default 123456,
-> telephone varchar(15),
-> qq varchar(15),
-> email varchar(30),
-> adress varchar(30)
-> );
返回: Query OK, 0 rows affected (0.01 sec)
teacher 表
mysql> create table teacher
-> (
-> teachernum varchar(20) primary key,
-> name varchar(10),
-> password varchar(30)
-> );
返回:Query OK, 0 rows affected (0.01 sec)
mysql> desc teacher;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| teachernum | varchar(20) | NO | PRI | NULL | |
| name | varchar(10) | YES | | NULL | |
| password | varchar(30) | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
3 rows in set (0.01 sec)
4 查询表
mysql> desc student;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| studentnum | varchar(20) | NO | PRI | NULL | |
| name | varchar(10) | YES | | NULL | |
| chinese | float(5,2) | YES | | NULL | |
| math | float(5,2) | YES | | NULL | |
| english | float(5,2) | YES | | NULL | |
| password | varchar(30) | YES | | 123456 | |
| telephone | varchar(15) | YES | | NULL | |
| qq | varchar(15) | YES | | NULL | |
| email | varchar(30) | YES | | NULL | |
| adress | varchar(30) | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
10 rows in set (0.01 sec)
以上是在mysql中建立数据库的一种实现方法,没有什么语法介绍,只是对mysql有一个初步的认识