Re: NOT NULL - newbie
| From: | Constantin Brinzoi | Date: | Wed, 05 Oct 2005 10:27:10 +0000 |
| Subject: | Re: NOT NULL - newbie | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-40470@lists.php.net to get a copy of this message | ||
Hi!
I think that "NOT NULL" comes together with "PRIMARY KEY" and not with
"AUTO_INCREMENT".
Follow this link http://dev.mysql.com/doc/mysql/en/create-table.html
for
detailed information about creating tables in MySQL.
Have a nice day!
Aurel
On Wed, 2005-10-05 at 12:15 +0200, W Roothman wrote:
> Dear All,
>
> When declaring values for an identifier with unsigned auto_increment, is it necessary to
> include NOT NULL?
>
> my_id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
>
> or
>
> my_id INT NOT NULL UNSIGNED AUTO_INCREMENT PRIMARY KEY,
>
> Regards,
>
> Will