Dashboard > GreenPepperOpen > ... > Database > Null values
  GreenPepperOpen Log In View a printable version of the current page.  
  Null values
Added by Francois Denommee, last edited by Francois Denommee on Jan 27, 2010
Labels: 
(None)

database-connection

connect to MySql database on localhost with username dbgreenpepper and password dbgreenpepper and database dbgreenpepper

Nulls are handled just like normal values.

execute statement   create table test_1 (ky int,i int, d datetime, s varchar(100))
insert into Table   test_1
ky i d s
1 1 2007-10-10 tst
2 null 2007-10-10 tst
3 1 null tst
4 1 2007-10-10 null
set of query   select * from test_1
ky i? d? s?
1 1 2007-10-10 tst
2 null 2007-10-10 tst
3 1 null tst
4 1 2007-10-10 null
execute statement   drop table test_1

DEMONSTRATION LICENSE - This Confluence site is for demonstration purposes only. Evaluate Confluence today.
Powered by Atlassian Confluence, the Enterprise Wiki. (Version: 2.4.3 Build:#705 Mar 21, 2007) - Bug/feature request - Contact Administrators