-- 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));