Skip to content

Instantly share code, notes, and snippets.

@mykelalvis

mykelalvis/gist:8a308b82de259290267216d396b766d3

Created March 6, 2020 13:01
Show Gist options
  • Save mykelalvis/8a308b82de259290267216d396b766d3 to your computer and use it in GitHub Desktop.
Save mykelalvis/8a308b82de259290267216d396b766d3 to your computer and use it in GitHub Desktop.
Download ZIP
Get the tables
Raw
gistfile1.txt
select SUBSTRING( NAME FROM LOCATE( '/' ,NAME ) + 1 ) AS SEQUENCE_NAME from information_schema.INNODB_SYS_TABLES WHERE NAME LIKE 'somenamex' AND FLAG & 12288 );
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment