Difference between revisions of "Test db for user creation"
From MyWiki
(Created page with "<source lang="sql"> create table gdb ( uid varchar(20) primary key, name varchar(100), code varchar(3), </source>") |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 4: | Line 4: | ||
uid varchar(20) primary key, | uid varchar(20) primary key, | ||
name varchar(100), | name varchar(100), | ||
| − | code varchar(3), | + | code varchar(3) |
| + | ); | ||
| + | |||
| + | insert into gdb (uid,name,code) VALUES('1234556','James Duff','fr'); | ||
| + | insert into gdb (uid,name,code) VALUES('1234554','Derek Galway','ry'); | ||
| + | insert into gdb (uid,name,code) VALUES('1234552','Rob Jones','pr'); | ||
| + | insert into gdb (uid,name,code) VALUES('1234536','James Gibbon','ex'); | ||
| + | insert into gdb (uid,name,code) VALUES('1234528','James Galway','fr'); | ||
| + | insert into gdb (uid,name,code) VALUES('1234523','James Galway','ry'); | ||
</source> | </source> | ||
Latest revision as of 17:59, 25 October 2014
CREATE TABLE gdb ( uid VARCHAR(20) PRIMARY KEY, name VARCHAR(100), code VARCHAR(3) ); INSERT INTO gdb (uid,name,code) VALUES('1234556','James Duff','fr'); INSERT INTO gdb (uid,name,code) VALUES('1234554','Derek Galway','ry'); INSERT INTO gdb (uid,name,code) VALUES('1234552','Rob Jones','pr'); INSERT INTO gdb (uid,name,code) VALUES('1234536','James Gibbon','ex'); INSERT INTO gdb (uid,name,code) VALUES('1234528','James Galway','fr'); INSERT INTO gdb (uid,name,code) VALUES('1234523','James Galway','ry');
