第1个回答 2012-02-11
新建普通用户:CREATE USER 'test1'@'localhost' IDENTIFIED BY 'test1'
数据库创建:CREATE DATABASE example
表的创建:CREATE TABLE example0(id INT,
name VARCHAR(20),
sex BOOLEAN
)
第2个回答 2012-03-14
DROP DATABASE IF EXISTS userdb;
CREATE DATABASE userdb;
USE userdb;
CREATE TABLE user(
id int(11)NOT NULL AUTO_INCREMENT,
userName varchar(20) DEFAULT NULL,
userPwd varchar(20) DEFAULT NULL,
PRIMARY KEY (id)
)ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO user(id,userName,userPwd)VALUES(1,'admin','admin');