Mysql的安装:http://jingyan.baidu.com/article/375c8e1983ee1a25f3a2297f.html
可视化Mysql工具:SQLyog
SQLyog:安装及注册:地址在网盘,解压之后,运行,注册表
sql语句:
CREATE TABLE admin(
admin_id INT(8) PRIMARY KEY,
admin_code
VARCHAR(30) NOT NULL,
PASSWORD
VARCHAR(30) NOT NULL,
NAME
VARCHAR(30) NOT NULL,
telephone
VARCHAR(15),
email
VARCHAR(50),
enrolldate
DATETIME NOT NULL);
插入值:
INSERT INTO admin VALUES(2000,'admin','123','ADMIN','123456789','admin@tarena.com.cn','2008-10-28');
关于sql语法规范可参照:http://blog.sina.com.cn/s/blog_80613dc40100s0c8.html