#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    wendell, mass, USA
    Posts
    87
    Rep Power
    14
    So this table creation is giving me grief, I am only allowed to create int fields or varchar fields it seems, but not both.
    also, when I try to create a table in access and send it using myODBC, It gives my an SQL syntax error. I get the same error when I try to link tables with the server, but it works fine locally. I use access 97, does this matter?

    Here is my SQL:
    CREATE TABLE analy (
    id int(11) NOT NULL auto_increment,
    name varchar(50),
    url varchar(50),
    img varchar(50),
    brand varchar(50),
    price double,
    cap int(11),
    res int(11),
    desc mediumtext,
    PRIMARY KEY (id)
    );

    and here is the error:


    ERROR 1064 at line 1: You have an error in your SQL syntax near 'desc mediumtext,
    PRIMARY KEY (id)
    )' at line 10


  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    18
    2 like this in 1 day, wow.

    desc is a reserved word (used with order by) and cannot be used as a field name.

Similar Threads

  1. Help with CREATE TEMPORARY TABLE
    By C3P0 in forum MySQL Help
    Replies: 0
    Last Post: February 16th, 2004, 02:50 PM
  2. League table problem
    By silverduck in forum MySQL Help
    Replies: 8
    Last Post: February 10th, 2004, 12:38 PM
  3. GROUP BY to create a table summary
    By getting_there in forum MySQL Help
    Replies: 2
    Last Post: January 21st, 2004, 12:00 PM
  4. how to keep table on top, not centered??
    By vinyl in forum HTML Programming
    Replies: 2
    Last Post: January 20th, 2004, 06:19 PM
  5. PHP script to execute MySQL create table
    By sisleysusie in forum PHP Development
    Replies: 1
    Last Post: January 14th, 2004, 04:44 AM

IMN logo majestic logo threadwatch logo seochat tools logo