Mysql数据库和表的命令操作

1.数据库（DATABASE)操作：

（1）创建数据库

mysql> create database stusys;

Query OK, 1 row affected (0.03 sec)

mysql> show databases;

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

| Database |

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

| information_schema |

| mysql |

| performance_schema |

| sakila |

| stusys |

| sys |

| world |

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

7 rows in set (0.01 sec)

（2）查看数据库

mysql> show databases;

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

| Database |

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

| information_schema |

| mysql |

| performance_schema |

| sakila |

| sys |

| world |

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

6 rows in set (0.06 sec)

（3）选择数据库

mysql> use stusys

Database changed

mysql>

（4）修改数据库

mysql> use stusys;

Database changed

mysql> alter database stusys

-> default character set gb2312

-> default collate gb2312_chinese_ci;

Query OK, 1 row affected (0.01 sec)

（5）删除数据库

mysql> drop database stusys;

Query OK, 0 rows affected (0.05 sec)

mysql> show databases;

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

| Database |

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

| information_schema |

| mysql |

| performance_schema |

| sakila |

| sys |

| world |

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

6 rows in set (0.01 sec)

2.数据表

mysql> use stusys;

Database changed

mysql> create table student

-> (

-> sno char(6) not null primary key ,

-> snname char(8) not null,

-> ssex char(2) not null,

-> ssex char(2) not null default'男',

-> sbirthday data not null ,

-> speciality char(12) null ,

-> tc tinyint null

-> );

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'data not null ,

speciality char(12) null ,

tc tinyint null

)' at line 7

mysql> create table student

-> (

-> sno char(6) not null primary key ,

-> snname char(8) not null,

-> ssex char(2) not null default'男',

-> sbirthday data not null ,

-> speciality char(12) null ,

-> );

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'data not null ,

speciality char(12) null ,

)' at line 6

mysql>

mysql> create table student

-> (

-> sno char(6) not null primary key ,

-> snname char(8) not null,

-> ssex char(2) not null,

-> ssex char(2) not null default'男';

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6

mysql> create table student

-> (

-> sno char(6) not null primary key ,

-> snname char(8) not null,

-> ssex char(2) not null default'男',

-> sbirthday data not null ,

-> speciality char(12) null ,

-> tc tinyint null

-> );

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'data not null ,

speciality char(12) null ,

tc tinyint null

)' at line 6