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

[wangfeng_35]

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”这有错，求解。

才接触数据库，很多不理解的地方。。

[ACMAIN_CHM]

多了个，号 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";

[ACMAIN_CHM]

多了个，号 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";

[rucypli]

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

[WWWWA]

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>

[wangfeng_35]

引用 2 楼 ACMAIN_CHM 的回复:

多了个，号 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";

谢谢啊！！！