各种SQL语句示例

yanlp

纯属乱七八糟.
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 add  primary 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_Sc  add constraint Fk_s foreign key (sno)  references Stu_PkFk_S(sno)DROP INDEX biaoming.suoyinming  
HSQLDB 创建表：
CREATE TABLE  user(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)