books
and inserts two SQL NULL values. The stmt.executeUpdate("CREATE TABLE books (c1 varchar(32), c2 double)"); stmt.executeUpdate("INSERT INTO books VALUES(' ','.a')");
stmt.executeUpdate("CREATE TABLE books (c1 varchar(32), c2 double)"); PreparedStatement ps = connection.prepareStatement("INSERT INTO books VALUES(?,?"); ps.setString(1," "); ps.setString(2, .a); /* NOTE: no quotes surrounding .a */ ps.executeUpdate();
" "1
|
" "1
|
|
false2
|
false2
|
|
1The |
||
2The |