Skip to content

Instantly share code, notes, and snippets.

@DevWL

DevWL/usefullSQL.txt Secret

Last active June 26, 2021 15:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save DevWL/cf712de6ac3a72fa805251e15f01b22d to your computer and use it in GitHub Desktop.
Save DevWL/cf712de6ac3a72fa805251e15f01b22d to your computer and use it in GitHub Desktop.
Download ZIP
Useful SQL for finding relation with in PrestaShop database
Raw
usefullSQL.txt
First select databsae with USE keyword. Then:
SELECT TABLE_NAME, ENGINE, TABLE_COLLATION, CREATE_OPTIONS, TEMPORARY
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME LIKE '%product%' GROUP BY TABLE_NAME;
SELECT TABLE_NAME, ENGINE, TABLE_COLLATION, CREATE_OPTIONS, TEMPORARY
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME LIKE '%feature%' GROUP BY TABLE_NAME;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment