语句的内容是这样的,哪位高手可以帮我改一下
CREATE TABLE `my_table` ( `id` int(11) NOT NULL auto_increment, `字段1` datetime NOT NULL default '0000-00-00 00:00:00', `字段2` varchar(32) NOT NULL default '', `字段3` varchar(32) NOT NULL default '', `字段4` double NOT NULL default '0', `字段5` varchar(32) NOT NULL default '', `字段6` double NOT NULL default '0', `字段7` double NOT NULL default '0', PRIMARY KEY (`id`), KEY `字段5` (`字段5`), KEY `字段2` (`字段2`), KEY `字段3` (`字段3`)) ENGINE=MyISAM AUTO_INCREMENT=180 DEFAULT CHARSET=latin1
CREATE TABLE `my_table` ( `id` int(11) NOT NULL auto_increment, `字段1` datetime NOT NULL default '0000-00-00 00:00:00', `字段2` varchar(32) NOT NULL default '', `字段3` varchar(32) NOT NULL default '', `字段4` double NOT NULL default '0', `字段5` varchar(32) NOT NULL default '', `字段6` double NOT NULL default '0', `字段7` double NOT NULL default '0', PRIMARY KEY (`id`), KEY `字段5` (`字段5`), KEY `字段2` (`字段2`), KEY `字段3` (`字段3`)) ENGINE=MyISAM AUTO_INCREMENT=180 DEFAULT CHARSET=latin1
create sequence row_id
minvalue 1
maxvalue 9999999999999999999999
start with 1
increment by 1 insert into test values(row_id.nextval,....) nextval下一个ID
currentval当前ID
通过SEQUENCE 和触发器实现
--创建SEQUENCE
create sequence row_id
minvalue 1
maxvalue 9999999999999999999999
start with 1
increment by 1 --创建触发器
CREATE OR REPLACE TRIGGER 触发器名称 BEFORE
INSERT ON 表名 REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROWbegin
select SEQUENCE名称.NEXTVAL INTO :new.ID from dual;
end;