sql 创建表 

CREATE TABLE "Test" (
  "Id" INTEGER NOT NULL,
  "测试" TEXT,
  PRIMARY KEY ("Id")
);

转自:

https://www.cnblogs.com/orangeform/archive/2012/02/22/2325258.html

 

 

声明类型 亲缘类型 应用规则
INT
INTEGER
TINYINT
SMALLINT
MEDIUMINT
BIGINT
UNSIGNED BIG INT
INT2
INT8		 INTEGER 1
CHARACTER(20)
VARCHAR(255)
VARYING CHARACTER(255)
NCHAR(55)
NATIVE CHARACTER(70)
NVARCHAR(100)
TEXT
CLOB		 TEXT 2
BLOB NONE 3
REAL
DOUBLE
DOUBLE PRECISION
FLOAT		 REAL 4
NUMERIC
DECIMAL(10,5)
BOOLEAN
DATE
DATETIME		 NUMERIC 5
posted @ 2021-06-16 10:06  enych  阅读(41)  评论(0)  编辑  收藏  举报