Skip to content

Instantly share code, notes, and snippets.

@Arturo0021
Last active November 15, 2018 17:25
Show Gist options
  • Save Arturo0021/e3b5b0a1c5438a54ec3ce3658c3e222c to your computer and use it in GitHub Desktop.
Save Arturo0021/e3b5b0a1c5438a54ec3ce3658c3e222c to your computer and use it in GitHub Desktop.
SELECT
TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, CREATE_TIME, UPDATE_TIME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'base_de_datos'
AND TABLE_TYPE = 'BASE TABLE'
ORDER BY UPDATE_TIME DESC;
SELECT
*
FROM mysql.proc
WHERE type = 'PROCEDURE'
AND db = 'base_de_datos'
ORDER BY modified desc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment