MYSQL入门学习之八：数据库及表的基本操作(二)
| Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id | int(10) | NO | | 0 | |
| name | varchar(50) | NO | | N/A | |
| sex | char(1) | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
8、修改表结构 www.2cto.com
mysql> alter table student add bithday date null;
mysql> alter table student modify bithday datetime;
mysql> alter table student change bithday birt datetime;
mysql> alter table student drop column bithday;
9、操作表中的数据
mysql> select * from student;
+----+------+------+---------------------+
| id | name | sex | birt |
+----+------+------+---------------------+
| 0 | jack | 1 | 2012-12-13 00:00:00 |
+----+------+------+---------------------+
mysql> insert into senior_student select * from student;
mysql> insert into student(name,sex,birt) values('jack','1',current_date());
mysql> update student set sex = 0 where name = 'jack';
mysql> delete from student where name = 'jack';
10、创建及查看索引
mysql> create index idx_student_name on student(name);
mysql> show index from student;
+---------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+---------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| student | 1 | idx_student_name | 1 | name | A | NULL | NULL | NULL | | BTREE | |
+---------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+