MSQL高手来帮转化下这这些语句

来源：百度知道 编辑：UC知道 时间：2024/07/07 06:55:49
CREATE TABLE `tx_train_province` (
`provinceID` tinyint(2) unsigned NOT NULL auto_increment,
`provinceName` varchar(6) NOT NULL default '',
`enName` varchar(15) NOT NULL default '',
PRIMARY KEY (`provinceID`),
UNIQUE KEY `provinceName` (`provinceName`),
KEY `enName` (`enName`)
) TYPE=MyISAM AUTO_INCREMENT=100 ;

CREATE TABLE `tx_train_station` (
`stationID` smallint(4) unsigned NOT NULL auto_increment,
`provinceID` tinyint(2) unsigned NOT NULL default '0',
`stationName` varchar(40) NOT NULL default '',
`trainnum` smallint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`stationID`),
KEY `provinceID` (`provinceID`)
) TYPE=MyISAM AUTO_INCREMENT=3804 ;

CREATE TABLE `tx_trainlist` (
`trainID` varchar(10) NOT NULL default '',
`stationID` smallint(6) unsigned NOT NULL default '0',
`stationName` varchar

CREATE TABLE tx_train_province (
provinceID tinyint(2) PRIMARY KEY ,
provinceName varchar(6) NOT NULL UNIQUE default '',
enName varchar(15) NOT NULL default '',
)

CREATE TABLE tx_train_station (
stationID smallint(4) PRIMARY KEY,
provinceID tinyint(2) NOT NULL default '0',
stationName varchar(40) NOT NULL default '',
trainnum smallint(3) NOT NULL default '0',
CONSTRAINT FK1 foreign KEY (provinceID) references tx_train_province(tx_train_province)
)

CREATE TABLE tx_trainlist (
trainID varchar(10) NOT NULL default '',
stationID smallint(6) NOT NULL default '0',
stationName varchar(40) NOT NULL default '',
CONSTRAINT PK PRIMARY KEY (trainID,stationID),
CONSTRAINT FK1 foreign KEY (stationName) references tx_train_station(stationName)
)

CREATE TABLE tx_trains (
trainID varc