🚀 go-pugleaf

Matthew wrote:

> Is it possible to insert a null value into mysql through jdbc?
> 
> String test = "NULL";
> try{
> //Statement st = con.createStatement();
>          stmt.executeUpdate("INSERT INTO tblStuff VALUES('10', \"" +
> test + "\")");
> }catch(SQLException e){
> System.out.println(e);
> }
> 
> this is the test I have been trying to do it with.  My value is passed
> into a string and then inserted into the database.  When I have an empty
> string I would like to pass it a null value.  Any suggestions?


John is right for Strings, but ints are not null. In your topic, you asked
about ints, but seems you are referring to Strings in the message.

Just leave String fields null, by not referencing them on inserts or updates
in your sql statements, and they should be null filled (provided, of
course, they are not required fields, or key fields). Integers, Longs,
Floats, etc. will be zero filled by default, or if you choose, you can use
a zero value to fill integer types and double types use 0.00, or 0.0. 

I am not sure what MySQL version you are using. If a newer version, the
rules above should apply (I have not tried 5.0). Older versions may have
different rules. It is not a JDBC issue per se, but rather a Database
engine one.