ansaurus

Question

null values in mySQL

Answer 1

+2 A:

You need to add default values for the columns, either recreate the tables with defaults or alter the table definitions.

http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

http://dev.mysql.com/doc/refman/5.1/en/create-table.html

Robert Kluin 2010-02-28 19:40:06

Answer 2

+2 A:

You could update the default values of the fields of your database to prevent problems using:

ALTER TABLE `table` ALTER `field` SET DEFAULT 'value'

More information on ALTER TABLE for specific fields and parameters can be found in the documentation.

Veger 2010-02-28 19:42:07

it seems exactly what is needed - but can it be done for ALL fields in a whole database? or for all fields in a table?Though it seems there is some value in MySQL that could be set to make this automatic. as I understood this is exactly what they have done on the previous server.

Roman 2010-02-28 19:45:59

@Roman: `DEFAULT` constraints statements are per column. You can get a list of columns via INFORMATION_SCHEMA, and dynamically create the statements though I doubt you want the same default value for all columns. Which is why they're on a per column basis ;)

OMG Ponies 2010-02-28 19:51:00

umff... :) I just need an empty value instead of null everywhere (at least that what I've understood from the guy with the web site :) There must some easy way for this... somehow to disable the NULL value auto insertion.

Roman 2010-02-28 19:53:39

If you have lots of similar fields you could find them using the method OMG Ponies mentioned, but then use a script for setting the default values. Leaving a few fields left. Your script could ask default values for these fields when running it. Seems most efficient/simple to me.

Veger 2010-02-28 20:04:11

sounds good :) I guess I'll work it that way.Thanks for the help guys.

Roman 2010-02-28 20:12:21

ansaurus

tags:

views:

answers:

null values in mySQL

related questions