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

    Join Date
    Mar 2012
    Posts
    4
    Rep Power
    0

    Can you help me ? :)


    I want create new table :

    (
    date int NOT NULL,
    ip varchar(40) NOT NULL,
    b_id int unsigned primary key NOT NULL auto_increment
    );

    i have error :#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 'NOT NULL) NOT NULL, `ip` VARCHAR(40 NOT NULL) NOT NULL, `b_id` INT(NOT NULL) NOT' at line 1
    you can help me if you want i can use team viewer ?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    Paris Uppland
    Posts
    2,377
    Rep Power
    391
    Post the complete create table statement.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2012
    Posts
    4
    Rep Power
    0
    Originally Posted by swampBoogie
    Post the complete create table statement.
    you can help with team viwer ?
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    Paris Uppland
    Posts
    2,377
    Rep Power
    391
    you can help with team viwer ?
    No.
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,784
    Rep Power
    348
    Originally Posted by Lloyd23
    :#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
    Start by posting this in the correct forum.
    This forum is for PostgreSQL not for MySQL
  10. #6
  11. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2012
    Posts
    4
    Rep Power
    0
    Originally Posted by shammat
    Start by posting this in the correct forum.
    This forum is for PostgreSQL not for MySQL
    i dont understand
  12. #7
  13. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,784
    Rep Power
    348
    Originally Posted by Lloyd23
    i dont understand
    You posted an error message that clearly comes from a MySQL database in a PostgreSQL forum.
    PostgreSQL is a completely different thing than MySQL.
  14. #8
  15. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2012
    Posts
    4
    Rep Power
    0
    Originally Posted by shammat
    You posted an error message that clearly comes from a MySQL database in a PostgreSQL forum.
    PostgreSQL is a completely different thing than MySQL.
    oh i ma soory

IMN logo majestic logo threadwatch logo seochat tools logo