通过sql语句进行增加一个字段,
ALTER TABLE consume ADD COLUMN student_rollno INTEGER DEFAULT 0
创建一个数据表的sql语句
CREATE TABLE CUSTOMERS(
ID INT NOT NULL,
NAME VARCHAR (20) NOT NULL,
AGE INT NOT NULL,
ADDRESS CHAR (25) ,
SALARY DECIMAL (18, 2),
PRIMARY KEY (ID)
);
原文:http://www.cnblogs.com/istar/p/7611684.html