各种SQL语句示例
纯属乱七八糟.MYSQL 创建表
CREATE TABLE `user` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) default NULL, `password` varchar(255) default NULL, `disabled` int(1) NOT NULL, PRIMARY KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `role` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) default NULL, PRIMARY KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `user_role` ( `user_id` int(11) NOT NULL, `role_id` int(11) NOT NULL, PRIMARY KEY(`user_id`,`role_id`), UNIQUE KEY `role_id` (`role_id`), KEY `FK143BF46AF6AD4381` (`user_id`), KEY `FK143BF46A51827FA1` (`role_id`), CONSTRAINT `FK143BF46A51827FA1` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`), CONSTRAINT `FK143BF46AF6AD4381` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
alter table dbo.OPERATING_LOG addprimary key nonclustered (oid)--主键且非聚集ALTER TABLE OPERATING_LOG DROP constraint PK__OPERATING_LOG__57DD0BE4create clustered index clustered_optime_index on operating_log(optime)alter table Stu_PkFk_SC drop constraint FK_calter table Stu_PkFk_Scadd constraint Fk_s foreign key (sno)references Stu_PkFk_S(sno)DROP INDEX biaoming.suoyinming
HSQLDB 创建表：
CREATE TABLEuser(id integer generated by default as identity(start with 0,increment by 1) primary key,name varchar(50) default null,password varchar(50) default null,disabled integer not null)
页:
[1]