How can i insert a single data into a Mysql table using Python?

Question

I have tried this code but i receive the 1064 error.

x_1=**********    
t_2=(x_1)
cursor.execute('insert into informations' '(password)' 'values (%s)',t_2)

cestMoiBaliBalo · Accepted Answer · 2021-01-02 09:49:55Z

1

cursor.execute('insert into informations (password) values (?)', (x_1,))

would be a better syntax.

Just one string including the whole statement and using a question mark as placeholder for the value to insert.

The most important is to define the single value into a tuple.

answered Jan 1, 2021 at 20:42

cestMoiBaliBalo

1462 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1