MySQL Formulas


Some handy dandy MySQL formulas, based on SQL2008, I use to easy my office tasks
SQL Cheatsheet https://github.com/enochtangg/quick-SQL-cheatsheet

Date conversion
Convert Date to: dd/mm/yyyy format
CONVERT(VARCHAR(10),col_datetime, 101)
Selection
Select top x rows
SELECT TOP 1000 * FROM table_name

Database
Show All tables in database
SELECT Distinct TABLE_NAME FROM information_schema.TABLES
To be continued..........................