学习python和数据库musql连接遇到的问题

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())
   """