Mercurial > sqlpython
view sqlpython/setup_test_db.sql @ 498:fc0a6c58b7a7
all_object_qry works in mysql
author | Catherine Devlin <catherine.devlin@gmail.com> |
---|---|
date | Wed, 27 Oct 2010 13:50:48 -0400 |
parents | c5398d87498e |
children |
line wrap: on
line source
CREATE USER testdata IDENTIFIED BY testdata; GRANT connect, resource TO testdata; CONNECT testdata/testdata@orcl DROP TABLE species; CREATE TABLE species ( id NUMBER(6,0) CONSTRAINT xpk_species PRIMARY KEY CONSTRAINT xnn1_species NOT NULL, name VARCHAR2(40) CONSTRAINT xnn2_species NOT NULL ); INSERT INTO species VALUES (0, 'turtle'); INSERT INTO species VALUES (1, 'python'); INSERT INTO species VALUES (2, 'parrot');