Code666 (代码贴、代码片段)

[Python] python操作mysql数据库并通过sql语句创建表 →→→→→进入此内容的聊天室

来自 , 2021-03-16, 写在 Python, 查看 137 次.
URL http://www.code666.cn/view/1d7b813d
  1. #!/usr/bin/python
  2.  
  3. import MySQLdb
  4.  
  5. # Open database connection
  6. db = MySQLdb.connect("localhost","testuser","test123","TESTDB" )
  7.  
  8. # prepare a cursor object using cursor() method
  9. cursor = db.cursor()
  10.  
  11. # Drop table if it already exist using execute() method.
  12. cursor.execute("DROP TABLE IF EXISTS EMPLOYEE")
  13.  
  14. # Create table as per requirement
  15. sql = """CREATE TABLE EMPLOYEE (
  16.         FIRST_NAME  CHAR(20) NOT NULL,
  17.         LAST_NAME  CHAR(20),
  18.         AGE INT,  
  19.         SEX CHAR(1),
  20.         INCOME FLOAT )"""
  21.  
  22. cursor.execute(sql)
  23.  
  24. # disconnect from server
  25. db.close()
  26. #//python/8344

回复 "python操作mysql数据库并通过sql语句创建表"

这儿你可以回复上面这条便签

captcha

贴代码片段 - Code666