How to add value to a newly inserted column in sql using Python Mysql? [duplicate]

Question

I am getting errors while inserting value to a newly added column.

import mysql.connector
mydb = mysql.connector.connect(
    host = 'localhost',
    username = 'rt',
    password = 'rt',
    database = 'demo'
)
mycursor = mydb.cursor()
sql = "INSERT INTO customers_1 (Address) VALUES(%s)"
val = ("Karthik")
mycursor.execute(sql,val)
mydb.commit()
print(mycursor.rowcount, "record inserted.")

You're missing a comma to make it a tuple: val = ("Karthik",) — Barmar
– Barmar, Commented Apr 4, 2024 at 15:02

Kenzo Staelens · Accepted Answer · 2024-04-04 15:01:17Z

0

are you trying to update the column for all entries?

UPDATE customers_1
SET Address = %s
WHERE condition;

w3schools

i'm aware i'm possibly misunderstanding the question asked

answered Apr 4, 2024 at 15:01

Kenzo Staelens

7238 silver badges24 bronze badges

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

1 Comment

Barmar Over a year ago

They still need to correct the tuple syntax.

Collectives™ on Stack Overflow

How to add value to a newly inserted column in sql using Python Mysql? [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related