
Welcome to the miniSQL monitor.  Type \h for help.


mSQL >     ->     -> 
Query buffer
------------


insert into staff values ('David','Hughes','ProdDev',1,1.82)
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




mSQL > 
Query buffer
------------
insert into staff values ('Fred','Smith','Admin',2, 2.12)
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




mSQL > 
Query buffer
------------
insert into staff values ('Bill','Jones','Finance',3, 2.1)
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




mSQL > 
Query buffer
------------
insert into staff values ('Mike','Horn','Marketing', 5, 1.999)
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




mSQL > 
Query buffer
------------
insert into staff values ('Tom','Hanks','Sales', 4, 2)
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




mSQL >     ->     -> 
Query buffer
------------
insert into contact (staff_id, phone, address) values (1,'(07) 1234 5678',
	'3 Foo Street, Some Place Near the Beach, Qld, Australia')
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




mSQL >     -> 
Query buffer
------------
insert into contact (staff_id, phone, address) values (2,'(07) 2224 3338',
	'5 Baa Place, Some Place Out Back, Qld, Australia')
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




mSQL >     -> 
Query buffer
------------
insert into contact (staff_id, phone, address) values (5,'(07) 5554 6668',
	'Trailer 16, Main Beach Caravan Park, Qld, Australia')
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




mSQL >     -> 
Query buffer
------------
insert into contact (staff_id, phone, address) values (4,'(07) 4444 5555',
	'9/225 O\'Keafe Street, Near the Office, Qld, Australia')
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




mSQL >     -> 
Query buffer
------------
insert into contact (staff_id, phone, address) values (3,'(07) 3333 4444',
	'Right Here!')
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




mSQL >     -> 
Query buffer
------------
insert into pay values (1, '1-jan-97', '12:00:00', 1000)
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




mSQL > 
Query buffer
------------
insert into pay values (1, '1-feb-97', '12:00:00', 1000)
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




mSQL > 
Query buffer
------------
insert into pay values (1, '1-mar-97', '12:00:00', 1000)
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




mSQL >     -> 
Query buffer
------------
insert into pay values (2, '15-jan-97', '8:30:00', 750)
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




mSQL > 
Query buffer
------------
insert into pay values (2, '15-feb-97', '8:30:00', 750)
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




mSQL > 
Query buffer
------------
insert into pay values (2, '15-Mar-97', '8:30:00', 750)
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




mSQL >     -> 
Query buffer
------------
insert into pay values (3, '16-Oct-91', '8:30:00', 25)
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




mSQL > 
Query buffer
------------
insert into pay values (3, '27-dec-92', '8:30:00', 15)
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




mSQL > 
Query buffer
------------
insert into pay values (3, '01-Mar-97', '12:30:00', 750)
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




mSQL > 
Query buffer
------------
insert into pay values (3, '19-Jun-96', '10:45:00', 3)
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




mSQL >     ->     ->     -> 
Query buffer
------------

insert into foo_stuff values ('a', 1 )
[continue]
    -> 

ERROR : Error reading table "foo_stuff" definition (No such file or directory)


mSQL >     ->     ->     -> 
Query buffer
------------

insert into staff (first_name, last_name, initial) values ('a', 'b', 'c')
[continue]
    -> 

ERROR : Unknown field "staff.initial"


mSQL > 
Query buffer
------------
insert into users (staff_id, uname, uname) values (1, 'b', 'c')
[continue]
    -> 

ERROR : Field 'uname' not unique


mSQL > 
Query buffer
------------
insert into users (staff_id, uname) values ('1', 'b')
[continue]
    -> 

ERROR : Literal value for 'staff_id' is wrong type


mSQL >     ->     ->     -> 
Query buffer
------------

insert into contact values (NULL, '123', 'abc')
[continue]
    -> 

ERROR : Field "staff_id" cannot be null


mSQL > 
Query buffer
------------
insert into contact (phone, address) values ('123', 'abc')
[continue]
    -> 

ERROR : Field "staff_id" cannot be null


mSQL > 
Query buffer
------------
insert into staff values ('foo', 'baa', 'baz', 3, 1.1)
[continue]
    -> 

ERROR : Non unique value for unique index


mSQL >     ->     ->     -> 
Query buffer
------------

insert into pay values (2, '13-Foo-98','12:00:00', 1)
[continue]
    -> 

ERROR : Invalid date format "13-Foo-98"


mSQL > 
Query buffer
------------
insert into pay values (2, '13-Feb-98','hh00:00', 1)
[continue]
    -> 

ERROR : Invalid time format "hh00:00"


mSQL >     -> 
Bye!

