Page 1 of 1
Forum

Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!

Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.

Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!


Forums
Software Developmen...
Databases
MySQL - How to dete...
 
Share:
Notifications
Clear all

[Solved] MySQL - How to detect if a table exists ...

 
Databases
Last Post by Hans 11 years ago
1 Posts
1 Users
0 Reactions
2,977 Views
RSS
 Hans
(@hans)
Famed Member Admin
Joined: 12 years ago
Posts: 2859
Topic starter November 4, 2013 9:31 AM  

A simple query gives you either '0' if the table does not exist, or >0 if the table(s) exist - you can even use a LIKE statement to look for multiple tables:

SELECT count(*)
FROM information_schema.tables
WHERE table_schema = 'mydatabasename'
AND table_name = 'theTableImLookingFor'

   
ReplyQuote
Forum Jump:
  Previous Topic
Next Topic  
Share: