MySQL

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.00 sec)

mysql> select database();
+------------+
| database() |
+------------+
| NULL       |
+------------+
1 row in set (0.00 sec)

mysql> create database lty;
Query OK, 1 row affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| lty                |
| mysql              |
| performance_schema |
| test               |
+--------------------+
5 rows in set (0.00 sec)

mysql> create table ty(
    -> 姓名 varchar(50) ,
    -> 学号 int,
    -> 年龄 int,
    -> 性别 varchar(1)
    -> ) comment '用户表';
Query OK, 0 rows affected (0.00 sec)

mysql> show tables;
+---------------+
| Tables_in_lty |
+---------------+
| ty            |
+---------------+
1 row in set (0.00 sec)

mysql> desc ly;
ERROR 1146 (42S02): Table 'lty.ly' doesn't exist
mysql> desc ty;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| 姓名      | varchar(50) | YES  |     | NULL    |       |
| 学号     | int(11)     | YES  |     | NULL    |       |
| 年龄      | int(11)     | YES  |     | NULL    |       |
| 性别     | varchar(1)  | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql> show create table ty;
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                                                |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ty    | CREATE TABLE `ty` (
  `姓名` varchar(50) DEFAULT NULL,
  `学号` int(11) DEFAULT NULL,
  `年龄` int(11) DEFAULT NULL,
  `性别` varchar(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户表'                    |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

ALTER TABLE ty ADD COLUMN `邮箱` varchar(50) DEFAULT NULL;        这个是添加

ALTER TABLE ty MODIFY COLUMN `年龄` int(3);        这个是修改列定义

ALTER TABLE ty CHANGE COLUMN `性别` `性别标识` varchar(1);        这个是修改列名

ALTER TABLE ty DROP COLUMN `学号`;        这个是删除列