import pymysql
import time
import datetime
-sharp
db = pymysql.connect("localhost","root","aaaaaa","getlist" )
cursor = db.cursor()
sql="INSERT INTO t_mall VALUES (0,%s,%s,%s)"
try:
-sharp SQL
cursor.execute(sql % ("http://baidu.com", "", ""))
-sharp
db.commit()
except:
-sharp
db.rollback()
-sharp
db.close()
No error message is displayed during execution, but the data is not inserted. What is the reason?
you can troubleshoot the problem from these angles
1, and print out the sql string within the execute () directly
check the sql string for syntax errors, and modifyif there are any errors.
2. Execute the sql statement printed above manually to see if you can enter the database
.1. If there is no problem, execute 2. If you can enter the database, check for database connection problems
3. Check whether curosr connects to the database successfully.
feels like a command is missing and does not select a table to use:
cursor.execute ('use tasking answer')
first of all, it is not recommended to add try except to the first test, and the error cannot be displayed, and you will not see the error.
Furthermore, if you insert Chinese characters, you'd better set the character encoding before insertion: cursor.execute ('SET NAMES utf8mb4;')
visually, it is a field that does not specify the value of the inserted field.
this, you need to add table_name (field1, field2.)
engine = create_engine ( "mysql+pymysql: root:111@localhost xxx ", encoding= utf-8 , echo=True) Session_class = sessionmaker (bind=engine) Session = Session_class () modify a record user = Session.query (User). Filter_by (id=1). First () user.n...
...
some data are like this: 1186486, 0215648, 00064876, mysql stores data to columns of char type, data is stored in front of 0, all columns are killed. How to solve the short ones are preceded by 0, and the data is a string in python and does not ki...
first of all, I created a database, called dd in mysal, and then I created a table, called books in it, and then I executed the following command in python, hoping to insert a value in books: < hr > import pymysql conn=pymysql.connect (host= "127....
insert but the data is a number, which is stored in the database as a string, and the corresponding field in the database is also of string type The python statement goes like this: sql = insert into uhaoma343 (riqi,uhaoma) values({},{}) .format(r...
python: 3.6 mysql: 8.0 Boss, how to solve ...
at present, the company s mysql database cannot be connected directly locally and needs to be connected through a springboard (windows server). The steps to manipulate the data each time are: connect the springboard machine (windows server,ip: 10.*...
I put keywordpackagename: in this table. ...
z how to solve this problem ...
ask for help from seniors: if the long address is xxxx, Nanjing Road, Heping District, Tianjin how can it be dealt with by means of no manual intervention: Tianjin; Heping District; Nanjing Road; this kind of administrative division? because the inp...
python version is 3.5, MySQL version is 5.7.21, create database: py4e create table: PymySqlTest, install pymysql pip3 install pymysql prompt Requirement already satisfied: pymysql in Library Frameworks Python.framework Versions 3.7 lib python3.7...
the contents of the txt document are as follows: - supplementary question. The code is improved as follows, but still encounter problems: import mysql.connector conn = mysql.connector.connect(host= localhost , port=3306, user= root , password= ...
Application scenario: the client uploads the file and the django server writes a piece of status=1 data in the database. Then give it to rabbit to read the file and parse it. After parsing, set status to 2. The transmission format of rabbitmq is { "f...
recently, I have been working on track data clustering. Now I have track data of about 2 million people on hand. Each person s track consists of a sequence of points (a point position every half hour), as shown in the table . A day is divided int...
sql = "UPDATE arms SET gem2= %s WHERE id = ( %d )" % ( ,new_id) (1054, "Unknown column gem2 in field list ") sql = "UPDATE arms SET gem2= WHERE id = ( %d )" % new_id (1054, &quo...
with open( face.jpg , rb ) as f: img_data=f.read() find_binary=pymysql.Binary(img_data) print(find_binary) add_row="""INSERT INTO IMGS(ID,IMG,,DATAIMG) VALUES(7, K1 , NO. , %s )""" % (find_binary) cursor.execut...
problem description when I use python3 s redis for caching, the structure is hset, but when the data reaches 10000, I need to store these 10000 pieces of data into the database. When I delete the hset, of redis, the new request is not added to the re...
Business scenario 7pm 24-hour continuous data writing and updating (market system), it is necessary to store the transaction record and update the k line after calculating the k line according to the transaction record current solution use Celery ...
problem description the environmental background of the problems and what methods you have tried related codes Please paste the code text below (do not replace the code with pictures) class Comment (Model): """ comment and re...
for loop write crawl to crawl data, and then write mysql, to look at the database, the write is successful, but reported an error, may I ask why? ...