createchatroom.sql

来自「JAVA数据库编程实例随书源码」· SQL 代码 · 共 9 行

CREATE TABLE "USERTABLE" 
(
  "USER_ID"		VARCHAR(10) NOT NULL,
  "USER_NAME"		VARCHAR(10) NOT NULL,
  "USER_PASSWORD"	VARCHAR(20) NOT NULL,
 PRIMARY KEY ("USER_ID")
);
INSERT INTO usertable VALUES ('1', 'Zhangqing',  'Zhangqing');