Skip to content

Instantly share code, notes, and snippets.

@suissa

suissa/retireve_metadata_mysql

Created March 20, 2012 21:14
Show Gist options
  • Save suissa/2141366 to your computer and use it in GitHub Desktop.
Save suissa/2141366 to your computer and use it in GitHub Desktop.
Download ZIP
recuperando metadados das tabelas em mysql e com cakephp
Raw
retireve_metadata_mysql
SELECT COLUMN_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'youops'
AND TABLE_NAME = 'contas_correntes'
AND COLUMN_NAME = 'moeda'
//no cakephp
$obj = $this->schema();
//ou no controller
$obj = $this->MODEL->schema();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment