c# - C# 中的 MySQL 语法错误

Question

我收到错误 "you have an error in your SQL systax.."而且我不知道错误在哪里。任何人？

static void Main(string[] args)
{            
    string sql = "CREATE TABLE DiceRolls IF NOT EXISTS (session INTEGER, dice1 INTEGER, dice2 INTEGER);";
    string connString = "Server=localhost"+";database=3ddatabase"
        + ";port=3306" + ";User Id=root" +  ";password=";
   // string connStr = "server=localhost;user=root;port=3306;password=;";
    MySqlConnection con = new MySqlConnection(connString);
    con.Open();
    MySqlCommand cmd = new MySqlCommand(sql, con);
    cmd.ExecuteNonQuery();
    con.Close();
}

Answer 1

您的语法错误出现在您的 mysql 命令中。

你有

CREATE TABLE DiceRolls IF NOT EXISTS (session INTEGER, dice1 INTEGER, dice2 INTEGER);

当它应该是 IF NOT EXISTS then table_name:

CREATE TABLE IF NOT EXISTS DiceRolls (session INTEGER, dice1 INTEGER, dice2 INTEGER);