我想在mysql里建一个表Create table demo( id int auto_increment primary key, sid int )

CREATE TABLE `testt` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`userName` varchar(20) NOT NULL,

`password` char(20) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `id` (`id`),

UNIQUE KEY `userName` (`userName`),

UNIQUE KEY `password` (`userName`),

UNIQUE KEY `userName_2` (`userName`)

) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=uft8 PACK_KEYS=0 ROW_FORMAT=COMPACT COMMENT='InnoDB free: 4860928 kBInnoDB free: 3965952 kB'

假设你的demo.sql在c:\temp下

1 create database demo

2 use demo

3 source c:/temp/demo.sql

---