Terminology

SHOW COLUMNS IN <table>; ¶ definition: 'List the columns in a table. '

show tables; ¶ definition: 'List the tables in the current database.'

use <database>; ¶ definition: 'Make <database> the current database.'

Facts, Thoughts and Opinions

SELECT `TABLE_NAME`
FROM  `INFORMATION_SCHEMA`.`TABLES` 
WHERE `TABLE_SCHEMA` = 'schema'

SELECT `TABLE_NAME`, `COLUMN_NAME`
FROM `INFORMATION_SCHEMA`.`COLUMNS`
WHERE `TABLE_SCHEMA` = 'schema'
ORDER BY `TABLE_NAME`, `COLUMN_NAME`

UPDATE  `tbl` SET  `column` = DATE_ADD( NOW( ) , INTERVAL - RAND( ) *14 DAY )

[[/div]]

Sources & Bookmarks

page revision: 0, last edited: 19 May 2014 20:16