3.out

《嵌入式Linux应用开发详解》中的源代码

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 staff values ('John','Eales','Sport', -5, 2.23)
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




mSQL >     ->     -> 
Query buffer
------------
insert into contact (staff_id, phone, address) values (1,'[phone]',
	'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,'[phone]',
	'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,'[phone]',
	'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,'[phone]',
	'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,'[phone]',
	'Right Here!')
[continue]
    -> 
Query OK.  1 row(s) modified or retrieved.




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




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




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




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




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




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




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




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




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




mSQL > 
Query buffer
------------
insert into pay values (3, '19-Jun-1996', '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 : Unknown table "foo_stuff"


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-1998','12:00:00', 1)
[continue]
    -> 

ERROR : Invalid date format


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

ERROR : Invalid time format


mSQL >     -> 
Bye!