Disallowing Null Entries

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
joralemonshelly
Posts: 1
Joined: Sun 12 Dec 2010 00:25

Disallowing Null Entries

Post by joralemonshelly » Sun 12 Dec 2010 00:32

Hello,

I have a table with columns that are set to not allow nulls. But when adding rows to the table using the "Data" tab, these columns have "(null)" as a default entry, and the table accepts entries with "(null)" entered in these fields. Any advice on how to change this?

Thanks!

Alexz
Devart Team
Posts: 165
Joined: Wed 10 Aug 2005 08:30

Post by Alexz » Mon 13 Dec 2010 07:51

If you want Data Editor to display other data for new rows by default, you have to set default values for these fields. You can do this in Column Editor.

Post Reply