MySQL创建表的时候提示语法错误

Question

private bool CreateMysqlDataSet(string dbName, string dbdsName)
        {
            bool flag = true;
            //Mysql连接字符串
            string connString = @"Server=localhost;User Id=root;Password=admin;Charset=gbk;Persist Security Info=True;Database=" + dbName;
            //实例化Mysql连接对象
            MySqlConnection mySqlConnection = new MySqlConnection(connString);
            //对Mysql操作命令类
            try
            {
                string dbds = dbName + "." + dbdsName;
                //实际操作任务
                string commandString = @"create table if not exists " + dbds + @" (
                                        id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
                                         date_added DATETIME NOT NULL,
                                            title VARCHAR(10) NOT NULL,                                            
                                        content TEXT NOT NULL,
                                            )ENGINE=MyISAM DEFAULT CHARSET=gbk";                MySqlCommand setformat = new MySqlCommand("set names gbk;" + commandString, mySqlConnection);
                //链接Mysql数据库
                mySqlConnection.Open();
                //执行操作
                setformat.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString());
                flag = false;
            }
            finally
            {
                //关闭连接
                mySqlConnection.Close();
            }
            return flag;
        }            DateTime date = DateTime.Now;
            string dbName = "data" + date.ToString("yyyyMMdd");       
            
            string dbdsName = "data";
            CreateMysqlDataSet(dbName, dbdsName);提示“)ENGINE=MyISAM DEFAULT CHARSET=gbk”这有错，求解。才接触数据库，很多不理解的地方。。MySQL数据库

Answer 1

多了个，号        string commandString = @"create table if not exists " + dbds + @" (
                                            id        INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
                                            date_added    DATETIME NOT NULL,
                                            title        VARCHAR(10) NOT NULL,                                            
                                            content        TEXT NOT NULL,
                                            )ENGINE=MyISAM DEFAULT CHARSET=gbk";
 

Answer 2

多了个，号        string commandString = @"create table if not exists " + dbds + @" (
                                            id        INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
                                            date_added    DATETIME NOT NULL,
                                            title        VARCHAR(10) NOT NULL,                                            
                                            content        TEXT NOT NULL,   <--------
                                            )ENGINE=MyISAM DEFAULT CHARSET=gbk";

Answer 3

可以打印出来sql看看那里语法没对

Answer 4

mysql> CREATE TABLE IF NOT EXISTS tt7 (id INT PRIMARY KEY NOT NULL AUTO_INCREMEN
T,
    -> date_added DATETIME NOT NULL, Title VARCHAR(10) NOT NULL,content TEXT NOT
 NULL
    -> )ENGINE=MYISAM DEFAULT CHARSET=gbk;
Query OK, 0 rows affected, 1 warning (0.00 sec)mysql> CREATE TABLE IF NOT EXISTS tt7 (id INT PRIMARY KEY NOT NULL AUTO_INCREMEN
T,
    -> date_added DATETIME NOT NULL, Title VARCHAR(10) NOT NULL,content TEXT NOT
 NULL
    -> )ENGINE=MYISAM DEFAULT CHARSET=gbk;
Query OK, 0 rows affected (0.06 sec)mysql>