mysql> alter table pytable1 add column date datetime; # 新增一列
mysql> alter table pytable1 drop column date; # 删除一列
mysql> alter table pytable1 change sex gender char(20); # 修改列名;"sex"为旧的列名;"gender"为新的列名
mysql> alter table pytable1 modify name varchar(30) not null; # 更改列的属性
mysql> alter table pytable1 add primary key(id); # 向"id"列添加主键
mysql> alter table pytable1 add unique name_unique_index(`name`); #向"name"列添加唯一索引;(`age`)中"`"符号是"esc下面的键"
mysql> alter table pytable1 add index age_index(`age`); # 向"age"列添加普通索引
mysql> alter table pytable1 add column school char(10) after birthday; # 定义新增列的位置
查看表结构
mysql> desc pytable1;
+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| id | int(7) | NO | PRI | 0 | |
| name | varchar(30) | NO | UNI | NULL | |
| salary | bigint(10) | YES | | NULL | |
| age | int(3) | YES | MUL | NULL | |
| birthday | date | YES | | NULL | |
| gender | char(20) | YES | | NULL | |
| city | varchar(30) | YES | | NULL | |
| school | char(10) | YES | | NULL | |
+----------+-------------+------+-----+---------+-------+
8 rows in set (0.01 sec)
删除表的一列:
mysql> alter table pytable1 drop column school;
向表中添加内容:
mysql> insert into pytable1 values (1001,'Belle',8000,25,'female',19930526,'深圳'); # 插入所有列的数据
mysql> insert into pytable1 (id,name,age,salary) values ('1002','Bob','28','9000'); # 插入部分列的数据
查询表中的所有数据:
mysql> select * from pytable1;
+------+-------+--------+------+--------+------------+--------+
| id | name | salary | age | gender | birthday | city |
+------+-------+--------+------+--------+------------+--------+
| 1001 | Belle | 8000 | 25 | female | 1993-05-26 | 深圳 |
| 1002 | Bob | 9000 | 28 | NULL | NULL | NULL |
+------+-------+--------+------+--------+------------+--------+
2 rows in set (0.00 sec)
数据库的操作指令:新增数据库:mysql> create datatable database_name;查看已创建的数据库: mysql> show datdabases;选择数据库:mysql> use database_name;Database changed删除数据库:mysql> drop database databas...