mysql 3_mysql系列3 SQL语法基础

1.创建数据库(语法)

2.创建(数据库)表(语法)

复制新的空表举个例子：

mysql> use course;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show tables;

+------------------+

| Tables_in_course |

+------------------+

| students |

+------------------+

1 row in set (0.00 sec)

mysql> desc students;

+--------+-------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+--------+-------------+------+-----+---------+-------+

| id | int(11) | YES | | NULL | |

| name | varchar(16) | YES | | NULL | |

| gender | int(11) | YES | | NULL | |

+--------+-------------+------+-----+---------+-------+

3 rows in set (0.01 sec)

mysql> insert into students values('1','lili','01'),('2','hanmeimei','02');

Query OK, 2 rows affected (0.04 sec)

Records: 2 Duplicates: 0 Warnings: 0

mysql> select * from students;

+------+-----------+--------+

| id | name | gender |

+------+-----------+--------+

| 1 | lili | 1 |

| 2 | hanmeimei | 2 |

+------+-----------+--------+

2 rows in set (0.00 sec)

mysql> create table students_copy like students;

Query OK, 0 rows affected (0.13 sec)

mysql> show tables;

+------------------+

| Tables_in_course |

+------------------+

| students |

| students_copy |

+------------------+

2 rows in set (0.01 sec)

mysql> desc students_copy;

+--------+-------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+--------+-------------+------+-----+---------+-------+

| id | int(11) | YES | | NULL | |

| name | varchar(16) | YES | | NULL | |

| gender | int(11) | YES | | NULL | |

+--------+-------------+------+-----+---------+-------+

3 rows in set (0.00 sec)

mysql> desc students;

+--------+-------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+--------+-------------+------+-----+---------+-------+

| id | int(11) | YES | | NULL | |

| name | varchar(16) | YES | | NULL | |

| gender | int(11) | YES | | NULL | |

+--------+-------------+------+-----+---------+-------+

3 rows in set (0.00 sec)

创建索引例子：

mysql> show tables

-> ;

+------------------+

| Tables_in_course |

+------------------+

| students |

| students_copy |

| students_copy01 |

| students_copy02 |

| students_copy03 |

+------------------+

5 rows in set (0.00 sec)

mysql> select * from students;

+----+-----------+--------+

| id | name | gender |

+----+-----------+--------+

| 1 | lili | 1 |

| 2 | hanmeimei | 2 |

+----+-----------+--------+

2 rows in set (0.00 sec)

mysql> create index index01 on students(name);

Query OK, 0 rows affected (0.55 sec)

Records: 0 Duplicates: 0 Warnings: 0