各种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 add  primary key nonclustered (oid)--主键且非聚集

ALTER TABLE OPERATING_LOG DROP constraint PK__OPERATING_LOG__57DD0BE4

create clustered index clustered_optime_index on operating_log(optime)

alter table Stu_PkFk_SC drop constraint FK_c

alter 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
)