Error creating table in MySQL database using C#

Question

This error occurs whenever i'm trying to run my program.

Additional information: 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 1

The code is as follows:

private void create_Click(object sender, EventArgs e)
{
    string MyConnectionString = "Server=x.x.x.x;Database=groupdes_New;Uid=root;Pwd=password;";

    //create connection
    MySqlConnection connection = new MySqlConnection(MyConnectionString);
    //connect to database
    connection.Open();

    MySqlCommand cmd;
    cmd = connection.CreateCommand();//create command
    cmd.CommandText = "CREATE Table Newtable (" + "name" + ")";
    cmd.ExecuteNonQuery();

    if (connection.State == ConnectionState.Open)
    {
        connection.Close();
    }
}

I still can't manage to solve this error. Thanks for the help!

For starters, DO NOT use this inside your click event (as @JuanCarlosOropeza) has stated - terrible design. Secondly, your command string "...(" + "name" + ")" is the same as "(name)" (WHYYYY!?), which is causing your error. Your parens (()) should contain a list of column definitions... Check out how MySQL syntax should be : tutorialspoint.com/mysql/mysql-create-tables.htm — Geoff James
– Geoff James, Commented May 13, 2016 at 14:51
Another good pointer is in your error (and I quote...): "check the manual that corresponds to your MySQL server version for the right syntax to use"... Go RTFM :) ... @JuanCarlosOropeza has answered correctly below :) — Geoff James
– Geoff James, Commented May 13, 2016 at 14:57

Juan Carlos Oropeza · Accepted Answer · 2016-05-13 14:50:27Z

1

Your create table sintaxis is wrong.

You need define field datatype

CREATE TABLE Table1
    (`myDate` datetime)
;

answered May 13, 2016 at 14:50

Juan Carlos Oropeza

48.4k14 gold badges87 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Geoff James Over a year ago

@EuniceLing, don't forget to mark the question as answered if you've managed to solve your problem :)

Collectives™ on Stack Overflow

Error creating table in MySQL database using C#

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related