MySQL

Problem with create script

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jul 2005

Posts: 60

Reputation: hinde is an unknown quantity at this point

Solved Threads: 4

hinde

Offline

Junior Poster in Training

Problem with create script

Mar 15th, 2006

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
CREATE TABLE my_feature (
	pk_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
	member_id INT(8) UNSIGNED NOT NULL,
	time_added DATETIME NOT NULL,
	personal_questions BOOL NULL,
	hits INTEGER UNSIGNED NULL,
	PRIMARY KEY (pk_id));
CREATE TABLE my_feature (
	pk_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
	member_id INT(8) UNSIGNED NOT NULL,
	time_added DATETIME NOT NULL,
	personal_questions BOOL NULL,
	hits INTEGER UNSIGNED NULL,
	PRIMARY KEY (pk_id));

When I put this into the MySQL Query Browser I get this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7

This is kind of a pain in the ass and I cannot find anything that helps me.

•

Join Date: Jun 2005

Posts: 354

Reputation: Troy is an unknown quantity at this point

Solved Threads: 5

Troy

Offline

Posting Whiz

Re: Problem with create script

Mar 15th, 2006

I am running MySQL version 3.23.58. I copied and pasted your CREATE statement into a query window and executed it. It created the table successfully.

I don't KNOW what the problem is for you, but you might try changing BOOL to TINYINT(1). In my version, BOOL is not valid, however, when I executed the statement, it automatically created the column as TINYINT(1) without any errors or warnings.

Troy Wolf is the author of SnippetEdit. "Website editing as easy as it gets." IX Web Hosting

•

Join Date: Jul 2005

Posts: 60

Reputation: hinde is an unknown quantity at this point

Solved Threads: 4

hinde

Offline

Junior Poster in Training

Re: Problem with create script

Mar 15th, 2006

Yea basically I am running mysql on my pc for development purposes. I was running 4.1.26 (I think that was the version) but the server I am developing a feature for is running 5.1. Like an idiot, I couldn't leave well enough alone, upgraded, and for the past two days, I have been trying to get back up and running. I didn't figure out why it wasn't working, so I just took mysql query browser out of the equation and put it in the command line interpreter. I never had these problems with mssql. Now I am off to work out my foreign key constraint errors.