IT Certificaions

Google Cloud Platform

Monday, July 11, 2011

Updating more than 1 column of a table in MYSQL

Updating more than 1 column of a table in MYSQL

===============================================
UPDATE tablename SET col1=?,col2=?  WHERE col3 = ?"

? = your own value, what you want to update on what condition.
===============================================