Search found 2 matches

by Rowan Williams
Mon Jun 10, 2002 9:22 am
Forum: Databases
Topic: mysql data integrity
Replies: 4
Views: 4175

I failed to mention that this problem is most apparent when transferring data through text files. I am moving large amounts of data from one mysql db to another and am having problems catching corrupt data, and import errors, as mysql very rarely returns errors from LOAD statements.
by Rowan Williams
Mon Jun 10, 2002 7:26 am
Forum: Databases
Topic: mysql data integrity
Replies: 4
Views: 4175

mysql data integrity

I am having problems with data integrity in MySQL - specifically at field level. I need to find a way to remove the automatic default value that mysql creates for 'not null' fields. EG) Mysql creates a default of 0 for any 'not null', integer field. This defeats the purpose of having the 'not null' ...