Showing entries 1 to 1
Displaying posts with tag: MySQL search (reset)
MySQL search database | MySQL search all tables

“What will you do if one day some one ask you to find single string in all databases, all tables and in all columns?”

— This was asked to me once. There is some string in the database but I do not know where. There was a task to find an user’s details which is in the database which consists of many tables. And all I know is only the user name and do not know any other details. How am I supposed to find that string? I do not want to write some complex SQL for this. Digging more into this, I came across few GUI tools for MySQL which have good search feature.

So I am writing this blog about search feature in those tools. I shortlisted three client application for MySQL:

1) SQLyog

2) phpMyAdmin

3) HeidiSQL

[Read more]
Showing entries 1 to 1