import pymysql
“””
1、连接本地数据库
2、建立游标
3、创建表
4、插入表数据、查询表数据、更新表数据、删除表数据
“””
def create_table():
#连接本地数据库
db = pymysql.connect(“localhost”,”root”,”123456″,”test”)
#创建游标
cursor = db.cursor()
#如果存在student表，则删除
cursor.execute(“DROP TABLE IF EXISTS student”)
#创建student表
sql =
“””
CREATE TABLE IF NOT EXISTS FANUC_DROP(
id int UNSIGNED AUTO_INCREMENT,
x int not null,
y int not null,
z int not null,
PRIMARY KEY ( id )
)
“””
try:
# 执行SQL语句
cursor.execute(sql)
print(“创建数据库成功”)
except Exception as e:
print(“创建数据库失败：case%s”%e)
finally:
#关闭游标连接
cursor.close()
# 关闭数据库连接
db.close()
def main():
create_table()
if __name__ == “__main__”:
main()
db = pymysql.connect(“localhost”,”root”,”123456″,”test”)这句代码要想成功连接数据库，还需要pycharm连接mysql数据库。
pycharm连接本地mysql失败，出现以下问题：
问题：
Server returns invalid timezone. Go to ‘Advanced’ tab and
set ‘serverTimezone’
property manually.
The specified database user/password combination is rejected: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value ‘Öйú±ê׼ʱ¼ä’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration
property) to use a more specifc time zone value if you want to utilize time zone support.
翻译一下错误“ The server time zone value ‘Öйú±ê׼ʱ¼ä’ is unrecognized or represents more than one time zone”是时区不对
解决办法：
故在URL后面加上?serverTimezone=GMT%2B8 解决问题
