Update table row in MySQL

The DQL Syntax to update row in MySQL was


UPDATE table_name SET column1=value, column2=value2 WHERE some_column=some_value

Read More

Python read all rows of MySQL table

Below python code print all first column values of table in MySQL

query="SELECT * from table_name"
cursor.execute(query)

row = cursor.fetchone() 
while row is not None:
print(row[1])
row = cursor.fetchone()

Read More