Tuesday 19 February 2013

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"

row = cursor.fetchone() 
while row is not None:
row = cursor.fetchone()
Read More
Here We Write The Problems we face at different situations and Solutions to those problems.