Advertisement

05.19.2008 at 12:04PM PDT, ID: 23414816
[x]
Attachment Details

Table creation - problem with versions

Asked by daleoran in MySQL, Databases Miscellaneous, SQL Query Syntax

Tags: MySQL

I've been given a mysql file to import into a new database. The current version of MySQL is 5.0.45 but the the file is an earlier (unknown) version. When I try to import the file I get the following error message. Total novice so any help would be very much appreciated.

Many thanks

Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:

SQL query:
 
CREATE TABLE messages(
id int( 255 ) NOT NULL AUTO_INCREMENT ,
FROM int( 255 ) NOT NULL default '0',
TO int( 255 ) NOT NULL default '0',
subject varchar( 255 ) NOT NULL default '',
message text NOT NULL ,
date varchar( 255 ) NOT NULL default '',
approved int( 1 ) NOT NULL default '0',
PRIMARY KEY ( id )
) TYPE = MYISAM
 
MySQL said: Documentation
#1064 - 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 'from int(255) NOT NULL default '0',
  to int(255) NOT NULL default '0',
  subj' at line 3
[+][-]05.19.2008 at 12:51PM PDT, ID: 21600958

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.20.2008 at 01:51AM PDT, ID: 21604408

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.20.2008 at 06:19AM PDT, ID: 21605834

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MySQL, Databases Miscellaneous, SQL Query Syntax
Tags: MySQL
Sign Up Now!
Solution Provided By: sqd5597
Participating Experts: 1
Solution Grade: A
 
 
[+][-]05.20.2008 at 06:36AM PDT, ID: 21605961

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628