Timeline for How to check if specific table names exist in a database?
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 13, 2022 at 7:25 | comment | added | RogerCO |
Minor quibble with @mickmackusa's second answer - SUBSTRING(table_name, 7) assumes the prefix length is 6 chars including underscore. Whilst this is true for new (post j2.5) standard installs, if the site has been around a while, or if a longer or shorter prefix was specified during installation, the query will fail to find a match.
|
|
| Oct 19, 2018 at 10:18 | history | edited | mickmackusa | CC BY-SA 4.0 |
added 2 characters in body
|
| Oct 19, 2018 at 10:16 | comment | added | mickmackusa | I feel this question could have been more clear by providing sample data for the input array and the expected result. As it was posted, it was obviously not clear what the isolated issue was judging by how Sharky's answer didn't fix the issue. The accepted answer should be a comment in my opinion. | |
| Oct 19, 2018 at 10:09 | history | edited | mickmackusa | CC BY-SA 4.0 |
Added unfiltered query alternative
|
| Oct 19, 2018 at 9:59 | comment | added | mickmackusa | I have been generous in my service toward this OP in several ways -- far more valuable than mere points. | |
| Oct 19, 2018 at 9:48 | comment | added | mickmackusa | The other answer didn't solve the actual problem - it gave good advice about how to extract the resultset from a query that the OP had already tried. Not every question that can be answered deserves an upvote - my criteria are not that simple. | |
| Oct 19, 2018 at 9:37 | comment | added | FFrewin | Hey there - you put so much effort to write a good answer on the above question. This means that the question should be good too and was worthing an Up-vote. There is a button next to the question for upvoting. You should use it. Also there was already another answer on this question. Do you think it's at all any helpful? Upvote it too. | |
| Oct 18, 2018 at 13:31 | history | edited | mickmackusa | CC BY-SA 4.0 |
added 336 characters in body
|
| Oct 18, 2018 at 13:22 | history | edited | mickmackusa | CC BY-SA 4.0 |
added 991 characters in body
|
| Oct 18, 2018 at 13:10 | history | answered | mickmackusa | CC BY-SA 4.0 |