[Lazarus] Lazarus, Jedi etc.

[Michael Van Canneyt]

On Mon, 15 Jul 2013, Henry Vermaak wrote:

> On Mon, Jul 15, 2013 at 03:44:42PM +0100, Graeme Geldenhuys wrote:
>> On 2013-07-15 15:06, Henry Vermaak wrote:
>> > Could you explain why the above is bad for those of us that aren't DB
>> > experts?  To my untrained eye it looks fairly plausible, so I'm
>> > obviously missing something.
>> 
>> I never inserted data into column C, so MySQL decided on its own that it
>> should magically contain the value 0 — inventing data! Last time I
>> checked 0 <> null in SQL terms either.
>
> I seem to remember something about table columns having default values
> in the definition, so perhaps column C defaults to 0?

It should only do that when specifically instructed.

Michael.