Home > Database > Mysql Tutorial > h2基本用法

h2基本用法

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-07 14:57:45
Original
3061 people have browsed it

h2database建表语法 无 -- H2-- 日志表CREATE TABLE log4db( ID BIGINT NOT NULL auto_increment comment '序号', CDATE TIMESTAMP, THREAD VARCHAR(62), LOGLEVEL VARCHAR(16), LINE SMALLINT, CLASS VARCHAR(128), MSG TEXT, primary key(ID));-- 创建索引C

h2database 建表语法
-- H2


-- 日志表
CREATE TABLE log4db
(
  ID BIGINT  NOT NULL auto_increment 	comment '序号',
  CDATE  TIMESTAMP,
  THREAD VARCHAR(62),
  LOGLEVEL VARCHAR(16),
  LINE SMALLINT,
  CLASS VARCHAR(128),
  MSG TEXT,
  primary key(ID)
);


-- 创建索引
CREATE INDEX log_cdate  ON  log4db(CDATE)

CREATE INDEX log_level  ON  log4db(LOGLEVEL)
Copy after login
Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template