1.python打开当地数据库连接出错:
代码:
db=pymysql.connect('localhost','root','Qiaokeli123','test')
报错原因:
TypeError: __ init __() takes 1 positional argument but 5 were given
解决办法:指定用户密码等。
db=pymysql.connect(user='root',passwd='Qiaokeli123',database='test')
2.在python中使用datetime在数据库中插入日期,出错
代码:
sql = """
insert into employee(first_name,last_name,age,sex,income
,create_time) value("张","天爱",30,'女',100000,
datetime.datetime.now())
"""
try:
cursor.execute(sql)
db.commit()
print("插入成功")
except Exception as e:
print("插入失败:%s"%e)
db.rollback()
finally:
db.close()
报错原因:
创建失败:(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 '())' at line 1")
解决办法:
(1)直接给一个日期值
sql = """
insert into employee(first_name,last_name,age,sex,income
,create_time) value("张","天爱",30,'女',100000,
'2021-02-27')
"""
(2)插入当前时间:now()
sql = """
insert into employee(first_name,last_name,age,sex,income
,create_time) value("张","天爱",30,'女',100000,
now())
"""