当且仅当表不存在时，如何创建表？

Question

我在努力

conn = MySQLdb.connect (host = "localhost",
                           user = "username",
                           passwd = "password",
                           db = "my_db")
cursor = conn.cursor ()
q = """IF NOT EXISTS CREATE TABLE %s (
         course  VARCHAR(15),
         student  VARCHAR(15),
         teacher VARCHAR(15),
         timeslot VARCHAR(15))""" % (d,)

cursor.execute(q)

但是我得到了一个错误：_mysql_exceptions.ProgrammingError: (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 'IF NOT EXISTS CREATE TABLE ACCOUNTG (\\n\\t course VARCHAR(15),\\n\\t s' at line 1")

我不知道我正在试的东西有什么问题，我只想做一张桌子，如果它不存在的话。如有任何意见，将不胜感激，谢谢！在

Answer 1

语法错误：IF NOT EXISTS CREATE TABLE在MySQL中不是有效的SQL。在

你想要吗

CREATE TABLE IF NOT EXISTS [tablename]

根据MySQL documentation。在