python 创建数据库表方法

   import pymysql
   cursor = conn.cursor()
   sql_delete = "drop table sqls;"
   sql_create = """
            create table sqls(
                    sid INT NOT NULL primary key,
                    Spri varchar(20) not null);
                """
   sql_insert1 = "insert into sqls(sid,Spri)values('1','select');"
   sql_insert2 = "insert into sqls(sid,Spri)values('2', 'insert');"
   sql_insert3 = "insert into sqls(sid,Spri)values('3', 'update');"
   sql_insert4 = "insert into sqls(sid,Spri)values('4', 'delete');"
   sql_insert5 = "insert into sqls(sid,Spri)values('5', 'all');"
   cursor.execute(sql_delete)
   cursor.execute(sql_create)
   cursor.execute(sql_insert1)
   cursor.execute(sql_insert2)
   cursor.execute(sql_insert3)
   cursor.execute(sql_insert4)
   cursor.execute(sql_insert5)
   conn.commit()
   conn.close()
   print "Success"
   cursor.close()