what are the code that query on complete database and return the table name if a unique number is matched in that table. | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 2

what are the code that query on complete database and return the table name if a unique number is matched in that table.

If we post a unique ID then code must query on complete database and return the name of all table in which the unique ID is found.

8th Jun 2019, 11:33 PM
Vikash Kumar
Vikash Kumar - avatar
1 Answer
+ 1
You can't do this with one sql query but if you use php you can do something like this: (note: this example isn't real code and would need to be changed) <?php if (mysqli_query('SELECT * FROM table WHERE id=whatever') == 1) { mysqli_query('SELECT * FROM table') } ?>
15th Jun 2019, 1:23 AM
haydenki
haydenki - avatar