pymysql
con=pymysql.connect()
cursor=con.cursor()
:
spl=cursor.execute(sal)
con.commit()
:
()
con.rollback()
:
con.close()
老师看看我这什么问题,我一执行就出现下面报错
Traceback (most recent call last):
File "C:\Users\acer\AppData\Roaming\Python\Python37\site-packages\pymysql\connections.py", line 583, in connect
**kwargs)
File "C:\Program Files (x86)\Python37-32\lib\socket.py", line 707, in create_connection
for res in getaddrinfo(host, port, 0, SOCK_STREAM):
File "C:\Program Files (x86)\Python37-32\lib\socket.py", line 748, in getaddrinfo
for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
socket.gaierror: [Errno 11001] getaddrinfo failed
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "D:/python/pythondemo/com/插入数据.py", line 2, in <module>
con=pymysql.connect('localhosrt','root','sen6263234','pythondemo',3306)
File "C:\Users\acer\AppData\Roaming\Python\Python37\site-packages\pymysql\__init__.py", line 94, in Connect
return Connection(*args, **kwargs)
File "C:\Users\acer\AppData\Roaming\Python\Python37\site-packages\pymysql\connections.py", line 325, in __init__
self.connect()
File "C:\Users\acer\AppData\Roaming\Python\Python37\site-packages\pymysql\connections.py", line 630, in connect
raise exc
pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhosrt' ([Errno 11001] getaddrinfo failed)")