第一章 Mysql基本概念

mysql> create table students(
    -> student_id INT UNSIGNED,
    -> name VARCHAR(30),
    -> sex CHAR(1),
    -> birth DATE,
    -> PRIMARY KEY (student_id)
    -> );
Query OK, 0 rows affected (0.01 sec)


mysql> desc students
    -> ;
+------------+------------------+------+-----+---------+-------+
| Field      | Type             | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+-------+
| student_id | int(10) unsigned | NO   | PRI | 0       |       |
| name       | varchar(30)      | YES  |     | NULL    |       |
| sex        | char(1)          | YES  |     | NULL    |       |
| birth      | date             | YES  |     | NULL    |       |
+------------+------------------+------+-----+---------+-------+
4 rows in set (0.01 sec)

mysql> insert into students(student_id,name,sex,birth) values(41048101,