crebas.mysql.sql

来自「JDBC连数据库,这是一门很基初的技术,一定要好好研究」· SQL 代码 · 共 13 行

create table sd0703_account
(
	id integer,
	no varchar(18) not null,
	pwd varchar(15) not null,
	owner varchar(20) not null,
	balance double not null,
	cdate date,
	primary key(id)
)

insert into sd0703_account(id, no, pwd,owner, balance, cdate)
    values(1, 'account001', 'pwd001', 'user001', 0, '2007-07-17')