Hello
I didn't pay attention to this until recently, when someone advised
me to never set empty columns to NULL.
So I guess a NULL is different from a column that was never set to
anything when creating the record?
Here's an example:
======
//Leave col2 empty instead of NULL
$sql = "INSERT INTO mytable (id,col1) VALUES (NULL,?)";
$insert = $dbh->prepare($sql);
$insert->execute(array($argv[1]));
======
Thank you.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
