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;

Delete SQL table rows based on column values.

DELETE FROM tbl WHERE col="val";