MySQL

Links and Sites

Online Conversion Utility

 

SQL Statements

List Table Names and Row Count

SELECT table_name, table_rows FROM INFORMATION_SCHEMA.TABLES

List Views

SHOW FULL TABLES IN database_name WHERE TABLE_TYPE LIKE ‘VIEW’;

List Foreign Keys for a Given Table

SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_NAME = ”;

Format Date as Int

SELECT DATE_FORMAT(NOW(), ‘%Y-%m-%d %T.%f’);

Format Century Int as Date

SELECT DATE(DATE_ID);