File: createdb.sql

package info (click to toggle)
libxalan2-java 2.7.1-5
  • links: PTS, VCS
  • area: main
  • in suites: squeeze
  • size: 19,468 kB
  • ctags: 26,006
  • sloc: java: 175,784; xml: 28,073; sh: 164; jsp: 43; makefile: 43; sql: 6
file content (8 lines) | stat: -rw-r--r-- 341 bytes parent folder | download | duplicates (7)
1
2
3
4
5
6
7
8
connect 'sampleDB;create=true';

create table import1(  ProductID int,  Name varchar(40));

insert into import1 (ProductID, Name) values (1, 'toothpaste');
insert into import1 (ProductID, Name) values (2, 'milk');
insert into import1 (ProductID, Name) values (3, 'bread');
insert into import1 (ProductID, Name) values (4, 'cereal');