[thelist] Trying to create table in MySQL DB with phpmyadmin

[Jeremy Weiss]

Chris,

Give this a shot:

 CREATE TABLE `table_CATEGORIES` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,
`tTitle` VARCHAR( 255 ) NOT NULL ,
`tLocation` VARCHAR( 255 ) NOT NULL ,
`tDate` DATE NOT NULL ,
PRIMARY KEY ( `id` )
) TYPE = MYISAM ;


-jeremy


----- Original Message ----- 
From: "Christian Anderson" <lists at ckapublishing.com>
To: <thelist at lists.evolt.org>
Sent: Sunday, September 04, 2005 3:47 PM
Subject: [thelist] Trying to create table in MySQL DB with phpmyadmin


> Hi,
>
> I'm trying to convert one of my sites over from ASP to PHP, and am having
> problems setting up the MySQL database through PHPMyAdmin.
>
> I created a database, and am now trying to create some tables in it, but
> keep getting an error message when I press "save".
>
> This is how I'm trying to do it through phpmyadmin:
>
> http://www.ckapublishing.com/phpmyadmin.gif
>
> ...and this is the error message that I am getting once I press save:
>
> ----------------------------------
>
>  Database d60171206  - Table table_CATEGORIES  running on MySQL Server
Farm
> 2
>
> Error
>
> SQL-query :
>
> CREATE TABLE `table_CATEGORIES` (
> `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `tTITLE` VARCHAR NOT NULL ,
> `tLOCATION` VARCHAR NOT NULL , `tDATE` DATE NOT NULL
> )
>
> MySQL said:
>
> You have an error in your SQL syntax near 'NOT NULL, `tLOCATION` VARCHAR
NOT
> NULL, `tDATE` DATE NOT NULL)' at line 1
>
> ----------------------------------
>
> What am I doing wrong?
>
> Chris
>
> Christian Anderson
> :: http://www.ckapublishing.com/gallery
> :: skype: ckapublishing
>
>
> -- 
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !