Don't worry! It's only stuff...

-- select 10 random row from table
SELECT column FROM TABLE
ORDER BY rand()
limit 10
 
-- view all databases
show databases;
 
-- view tables from database
show tables FROM mysql;
 
-- timestamp 7 days ago
date_sub(curdate(), INTERVAL 7 DAY);
 
-- format date
SELECT TO_CHAR(TIME, 'YYYY-MM-DD HH24:MI') FROM LOG;
 
-- replace first char to upercase
UPDATE customer SET first_name = CONCAT(UPPER(LEFT(first_name, 1)), SUBSTRING(first_name, 2));