4.笔记 MySQL学习——创建数据库

来源：互联网发布：nginx 禁止访问根目录编辑：程序博客网时间：2024/04/29 04:46

4.笔记 MySQL学习——创建数据库

MYSQL创建数据库的命令和其他数据库是相似的。

如下

mysql> create database sampdb;

Query OK, 1 row affected (0.00 sec)

瞬间就创建完了。

然后选择数据库

mysql> select database();

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

| database() |

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

| NULL |

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

1 row in set (0.00 sec)

mysql> use sampdb;

Database changed

mysql> select database();

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

| database() |

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

| sampdb |

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

1 row in set (0.00 sec)

创建表

CREATE TABLE president

(

last_name VARCHAR(15) NOT NULL,

first_nameVARCHAR(15) NOT NULL,

suffix VARCHAR(5) NULL,

city VARCHAR(20) NOT NULL,

state VARCHAR(2) NOT NULL,

birth DATE NOT NULL,

death DATE NULL

);

执行如下：

mysql> CREATE TABLE president

-> (

-> last_name VARCHAR(15) NOT NULL,

-> first_name VARCHAR(15) NOTNULL,

-> suffix VARCHAR(5) NULL,

-> city VARCHAR(20) NOT NULL,

-> state VARCHAR(2) NOT NULL,

-> birth DATE NOT NULL,

-> death DATE NULL

-> );

Query OK, 0 rows affected (0.02 sec)

查看描述如下：

mysql> desc president;

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

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

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

7 rows in set (0.01 sec)

创建另一个表如下：

CREATE TABLE member

(

member_id INT UNSIGNED NOT NULLAUTO_INCREMENT,

PRIMARY KEY (member_id),

last_name VARCHAR(20) NOT NULL,

first_name VARCHAR(20) NOT NULL,

suffix VARCHAR(5) NULL,

expiration DATE NULL,

email VARCHAR(100) NULL,

street VARCHAR(50) NULL,

city VARCHAR(50) NULL,

state VARCHAR(2) NULL,

zip VARCHAR(10) NULL,

phone VARCHAR(20) NULL,

interests VARCHAR(255) NULL

);

查询如下：

mysql> desc member ;

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

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

| zip | varchar(10) | YES | |NULL | |

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

12 rows in set (0.00 sec)

阅读全文

0 0