13 Mar
2006
13 Mar
'06
6:16 p.m.
On Thu, Mar 09, 2006 at 04:09:37PM +0100, Piotr Krukowiecki wrote:
I've also added default values because iirc mysql will insert '' if there is no default and no value is provided.
If a default is not specified, the query will fail if the given column is not directly specified by the insert query. It's generally a good idea to specify the default values, regardless of which DBMS is being used. --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data intensive web and database programming http://www.AnalysisAndSolutions.com/ 4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409