davidwaterston/gist:3741543

Created September 18, 2012 06:21

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/davidwaterston/3741543.js"></script>
Save davidwaterston/3741543 to your computer and use it in GitHub Desktop.

Download ZIP

MySQL: Check if a table exists - version 1

Raw

	select table_name as found
	from information_schema.tables
	where table_schema = '__database_name__'
	and table_name = '__table_name__'

Author

davidwaterston commented Sep 18, 2012

Where you are unsure what the 'database_name' is (i.e. the schema the query is running in) then use this version instead: https://gist.github.com/3742116

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment