Bug #36683 disable, delete... colums at standard insert editor
Submitted: 13 May 2008 9:59 Modified: 23 Jun 2008 8:47
Reporter: - - Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench Severity:S4 (Feature request)
Version:5.0.21 OS:Microsoft Windows (XP SP2)
Assigned to: Assigned Account CPU Architecture:Any
Tags: disable colums, INSERT editor

[13 May 2008 9:59] - -
if you defined some colums with a default value, (like TIMESTAMP cols as CURRENT_TIMESTAMP), if you insert some fields into the standard insert editor, this doesn't let to add null values to these fields or delete/disable colums for don't add values to them, so the inserts create a sql sentence that insert a timestamp with '0000/00/00 00:00' value, it doesn't also interact with AI fields.

In adition standard insert editor should let to import insert values from sql,cvs,txt files.

How to repeat:
[30 Jul 2009 22:36] Alfredo Kojima
Perhaps instead of filling new rows with NULL by default, they should fill with DEFAULT
That would solve both the problem of not-NULL columns being set to NULL by default and also the problem described here.