TheBeArsenal

SQL - The Elite List

How to replace Column Value in SQL?

update table_name set column = 'newvalue' where column = 'some thing'
Comment: The command 'set' fills new value based on condition given in 'where'

How to backup MySQL database?

mysqldump -u user_name -p db_name > backup.sql;
Comment: Executing this command will prompt for your mysql password and upon completion a backup file named 'backup.sql' will be generated.
Source - https://support.hostway.com/hc/en-us/articles/360000220190-How-to-backup-and-restore-MySQL-databases-on-Linux

Delete SQL table rows based on column values.

DELETE FROM tbl WHERE col="val";
Comment: This command will remove all rows satisfying condition - 'col' column containing value 'val'.
Source - https://www.w3schools.com/sql/sql_delete.asp