Hm you need to define what kind of column you want...
like integer, text, varchar, enum etc etc
something like:
create table tablename (ID int not null auto_increment, something
varchar(255) not null, ...)
I would strongly recommend to read the manual!
You find it at www.mysql.com
There are many examples for all queries.
- Nessi -
At 05:47 27/07/01 , you wrote:
>I am having trouble setting a column attribute to not null. Below is the
>statement I am using:
>
>create table table_name (
> Column_Name not null
>);
>
>If this is not the correct way to do it, can someone please help me...this is
>my first mysql database.
>
>Thank you.
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
