File: test.sql

package info (click to toggle)
mysqltcl 2.0rc11-5
  • links: PTS
  • area: main
  • in suites: woody
  • size: 652 kB
  • ctags: 135
  • sloc: sh: 7,873; ansic: 1,165; tcl: 94; makefile: 57; sql: 15
file content (17 lines) | stat: -rw-r--r-- 539 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
CREATE TABLE Student (
  MatrNr int(11) DEFAULT '0' NOT NULL auto_increment,
  Name varchar(20),
  Semester int(11),
  PRIMARY KEY (MatrNr)
);

INSERT INTO Student VALUES (1,'Sojka',4);
INSERT INTO Student VALUES (2,'Preisner',2);
INSERT INTO Student VALUES (3,'Killar',2);
INSERT INTO Student VALUES (4,'Penderecki',10);
INSERT INTO Student VALUES (5,'Turnau',2);
INSERT INTO Student VALUES (6,'Grechuta',3);
INSERT INTO Student VALUES (7,'Gorniak',1);
INSERT INTO Student VALUES (8,'Niemen',3);
INSERT INTO Student VALUES (9,'Bem',5);