MySQL学习笔记3：表的基本操作介绍

复制代码 代码如下:

mysql> show tables;
+------------------+
| Tables_in_school |
+------------------+
| student |
+------------------+
row in set (0.00 sec)

复制代码 代码如下:

mysql> describe student;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
| name | varchar(20) | YES | | NULL | |
| sex | tinyint(1) | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
rows in set (0.00 sec)

复制代码 代码如下:

mysql> show create table student/G
*************************** 1. row ***************************
Table: student
Create Table: CREATE TABLE `student` (
`id` int(11) DEFAULT NULL,
`name` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
row in set (0.00 sec)