各种SQL语句示例

最新推荐文章于 2024-07-14 19:43:26 发布

iteye_20062

最新推荐文章于 2024-07-14 19:43:26 发布

阅读量154

点赞数

分类专栏： SQL 文章标签： SQL MySQL HSQLDB C C++

本文链接：https://blog.csdn.net/iteye_20062/article/details/81917608

版权

SQL 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

纯属乱七八糟.

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
)