一。首先登陆
mysql -u root -p
enter passowrd: 123
二创建数据库
create database 数据库名
eg:create database new;
注意每句命令后要输入一个";"。
三。指定使用的数据库
use 数据库名
eg: use new
四。创建表
CREATE TABLE newtable (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(20) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MYISAM DEFAULT CHARSET=utf8
id 和name为字段;
AUTO_INCREMENT为自动增长,默认为1;
PRIMARY KEY (`id`) 设置id为主键;
ENGINE :设置表类型;
CHARSET:设置表编码;
具体信息
C:/Documents and Settings/FENGJIAN>mysql -u root -p
Enter password: ***
Welcome to the MySQL monitor. Commands end with ; or /g.
Your MySQL connection id is 17
Server version: 5.1.37-community MySQL Community Server (GPL)
Type 'help;' or '/h' for help. Type '/c' to clear the current inpu
mysql> create database new
-> ;
Query OK, 1 row affected (0.01 sec)
mysql> use new
Database changed
mysql> CREATE TABLE newtable(
-> id int(4) NOT NULL AUTO_INCREMENT,
-> name varchar(20) NOT NULL,
-> PRIMARY KEY (id)
-> ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> describe newtable;
+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| id | int(4) | NO | PRI | NULL | auto_increment |
| name | varchar(20) | NO | | NULL | |
+-------+-------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)
mysql>
describe newtable:显示表信息