CODEWITHSUNDEEP
sqlmysqlnullconstraints
Roman
Roman

Reputation:

null values in mySQL

I've got a new website moved to my server. This website uses PHP and MySQL, and is built very poorly.

The problem is - it needs non-null values inserted into new records where ever I don't specify a value, though the default value is null.

I've been told it has been done on the previous server, but they have no idea how. I'd be glad to receive some help on this.

Upvotes: 1

Views: 128

Answers (2)

Veger
Veger

Reputation: 37905

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.

Upvotes: 2

Robert Kluin
Robert Kluin

Reputation: 8292

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

Upvotes: 2

Related Questions