sqlserver 的语句为:
CREATE TABLE ConfigTable (
Name VARCHAR (20) NOT NULL,
Value VARCHAR (8000) NOT NULL,
Type TINYINT NOT NULL,
CONSTRAINT PK_ConfigTable PRIMARY KEY CLUSTERED
(
Name
) ON PRIMARY
) ON PRIMARY; 如何改为 mysql 的 建表语句,关键是最后的部分;最好给解释一下,谢谢!
CREATE TABLE ConfigTable (
Name VARCHAR (20) NOT NULL,
Value VARCHAR (8000) NOT NULL,
Type TINYINT NOT NULL,
CONSTRAINT PK_ConfigTable PRIMARY KEY CLUSTERED
(
Name
) ON PRIMARY
) ON PRIMARY; 如何改为 mysql 的 建表语句,关键是最后的部分;最好给解释一下,谢谢!
2、MYSQL与SQLSERVER区别比较大,没有CLUSTERED 、ON PRIMARYCREATE TABLE ConfigTable (
Name VARCHAR (20) NOT NULL,
Value VARCHAR (8000) NOT NULL,
Type TINYINT NOT NULL,
CONSTRAINT PK_ConfigTable PRIMARY KEY (`type`));
CREATE INDEX IX_configTable ON configTable(type) ON PRIMARY; 最好都解释下,谢谢!!!
CREATE TABLE ConfigTable (
Name VARCHAR (20) NOT NULL,
Value VARCHAR (8000) NOT NULL,
Type TINYINT NOT NULL,
CONSTRAINT PK_ConfigTable PRIMARY KEY (`name`));约束名PK_ConfigTable,设置主键name
create table `ConfigTable`(
Name varchar(20) not null,
Value varchar(8000) not null,
Type tinyint not null,
primary key(name)
);
这个表的结构比较简单,如果还想有其他补充的话,参考一下mysql表定义的部分,太长,你自己下一个看看http://download.csdn.net/source/900692
Name varchar(20) not null,
Value varchar(8000) not null,
Type tinyint not null,
primary key(name)
);
`Name` varchar(20) not null,
`Value` varchar(8000) not null,
`Type` tinyint not null,
CONSTRAINT PK_ConfigTable PRIMARY KEY (`Name`)
);最后一句是 CONSTRAINT PK_ConfigTable PRIMARY KEY (`Name`) 定义主键,主键自身的名称为'PK_ConfigTable' ,主健由(`Name`) 构成。