The DQL Syntax to update row in MySQL was
UPDATE table_name SET column1=value, column2=value2 WHERE some_column=some_valu...
Tuesday, 19 February 2013
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(...
Subscribe to:
Posts (Atom)