SQL - The Elite List


How to replace Column Value in SQL?


update table_name set column = 'newvalue' where column = 'some thing'

How to backup MySQL database?


mysqldump -u user_name –p db_name > backup.sql;