MySQL Workbench

Discussion in 'Databases' started by jaa17, Jul 12, 2011.

  1. I am getting the following error when I try to create a table in my mysql database using workbench (the *** are to hide my complete id):

    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 ')' at line 2

    SQL Statement:

    CREATE TABLE `mysql_21***_1`.`Test` (

    )



    I set up my connection as follows (the *** are to hide my complete id):

    New Connection->
    Connection Name: Char******
    Connection Method: Standard (TCP/IP)
    Hostname: my02.Winhost.com
    Database User: us*****
    Password: **********
    Default Schema: mysql_21***_1

    Then I double clicked on the created thing to open a connection.

    Then I double clicked on Add Table.

    Name: Test
    Collation: Schema Default
    Engine: Server Default
    Comments: [I left this blank]


    Any idea what I am doing wrong?
     
    Last edited by a moderator: Oct 14, 2015
  2. Solved: I have to put in at least one column.
     
  3. Thanks for posting a follow-up.
     

Share This Page