mysql -u root -p
SHOW DATABASES;

USE my_database;
SHOW TABLES;

CREATE DATABASE IF NOT EXISTS db_name 
DROP DATABASE db_name

CREATE USER user_name IDENTIFIED BY PASSWORD 'password'

REVOKE ALL ON *.* TO user IDENTIFIED BY PASSWORD 'password'
GRANT ALL ON db_name.* TO user IDENTIFIED BY PASSWORD 'password';

SELECT * FROM table WHERE column='value'

UPDATE table SET column=value, column2=value2 WHERE column3=value3

================================================================================================

UPDATE accessLogs SET referer='http://imptech.net/design/' WHERE referer='http://imptech.net/WebDesign.html'

SELECT id, email, list, status FROM emailLists WHERE email='artistservices@cmj.com'