# MYSQL

# MYSQL basic cheatsheet

$ mysql -u ${USERNAME}  -p // login
$ show databases; // check databases
$ use ${DBNAME} // Select database
$ show tables;
$ SELECT * FROM `${TABLE-NAME}}`; // display all items in the table
$ UPDATE `person` SET role = "admin" WHERE id = "5"; // Update single entry

# Import & Export

Dump database to text file

mysqldump -u user -p databasename > ./db.sql

Run sed command to find/replace target string

sed -i 's/oldString/newString/g' ./db.sql

Reload the database into MySQL

mysql -u user -p databasename < ./db.sql