animalsurvey.sql

来自「高级java2 大学教程(含源码,经典的Java学习教程」· SQL 代码 · 共 24 行

connect 'jdbc:rmi://localhost:1099/jdbc:cloudscape:animalsurvey;create=true'
;
drop table surveyresults
;

create table surveyresults (
	id int NOT NULL ,
	surveyoption varchar (20) NOT NULL ,
	votes int NOT NULL ,
	constraint surveyresults_id primary key (id)
) 
;

insert into surveyresults (id,surveyoption,votes) values (1, 'Dog', 0)
;
insert into surveyresults (id,surveyoption,votes) values (2, 'Cat', 0)
;
insert into surveyresults (id,surveyoption,votes) values (3, 'Bird', 0)
;
insert into surveyresults (id,surveyoption,votes) values (4, 'Snake', 0)
;
insert into surveyresults (id,surveyoption,votes) values (5, 'None', 0)
;