Proper interpretation of NULL.

General usage of Access to MySQL

Moderator: jr

WStemple
Posts: 1
Joined: Mon May 23, 2011 10:52 pm

Proper interpretation of NULL.

Post by WStemple »

I have tw0 columns that are set to NULL in Access and the Create Table statement has them as DEFAULT 'Null'. It should be DEFAULT Null. One of the columns is a DATETIME and the other VARCHAR(50). The first does error out on the create since 'Null' is invalid.