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

    Join Date
    Mar 2000
    Location
    Randolph, NJ
    Posts
    36
    Rep Power
    15
    In telnet I am creating tables in my mySQL database, I type this and get the result:


    mysql> create table tsrdatabase (
    -> name char(25),
    -> from char(25),
    -> mail char(25),
    -> going_to char(25),
    -> date_going char(25),
    -> notes char(50)
    -> );
    ERROR 1064: You have an error in your SQL syntax near 'from char(25),
    mail char(25),
    going_to char(25),
    date_going char(25),
    notes char' at line 3

    please help, thanks.


    ------------------
    ================
    -Khill, www.tsrealm.com
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Location
    Gorakhpur,U.P.,India
    Posts
    24
    Rep Power
    0
    from is a SQL reserve word. replace from with something else and you should be through.

    Hope you get your job done....



    ------------------
    Anish Modi
    Infotech World
    India

Similar Threads

  1. League table problem
    By silverduck in forum MySQL Help
    Replies: 8
    Last Post: February 10th, 2004, 01:38 PM
  2. Newbie table creation question
    By andy collins in forum PostgreSQL Help
    Replies: 3
    Last Post: January 23rd, 2004, 03:27 PM
  3. how to keep table on top, not centered??
    By vinyl in forum HTML Programming
    Replies: 2
    Last Post: January 20th, 2004, 07:19 PM
  4. Scratch table error in MySQL/PHP
    By byte me in forum PHP Development
    Replies: 0
    Last Post: January 20th, 2004, 07:03 AM
  5. Image and table creation using for()
    By cresquin in forum HTML Programming
    Replies: 5
    Last Post: January 9th, 2004, 07:28 PM

IMN logo majestic logo threadwatch logo seochat tools logo