Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2016
    Posts
    2
    Provided Answers: 1

    Unhappy Answered: Error when trying to create db with sql

    When I try to create a database with a table in phpMyAdmin I keep getting an error message.

    Here is the message

    P.S. I have tried changing the comma to semicolon at the end of the first line.

    SQL query:


    Use betamath_users,
    CREATE TABLE `user` (
    `id` INT( 50 ) NOT NULL AUTO_INCREMENT ,
    `username` VARCHAR( 50 ) NOT NULL ,
    `email` VARCHAR( 100 ) NOT NULL ,
    `password` VARCHAR( 20 ) NOT NULL ,
    `com_code` VARCHAR( 255 ) default NULL,
    PRIMARY KEY ( `id` )
    ) ENGINE = InnoDB
    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 '
    CREATE TABLE `user` (
    `id` INT( 50 ) NOT NULL AUTO_INCREMENT ,
    `username` VA' at line 1

  2. Best Answer
    Posted by max_maggot

    "Syntax error at the start. Problem solved"


  3. #2
    Join Date
    Jun 2016
    Posts
    2
    Provided Answers: 1

    Lightbulb Solved

    Syntax error at the start. Problem solved

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •