Xetroximyn
asked on
Tool to easily view and tweak data in a DB table... kind of like editing a spreadsheet
I have some small tables in a DB that would be nice to be able to tweak more or less manually... without having to write an SQL statement manually every time I want to update a single thing.
Are there any tools that load a DB table for display and I could edit individual cells easily by say, right clicking the cell, saying "change value" and then being given a box to enter the new value, and it will write and execute the sql for me? Or something similar?
Are there any tools that load a DB table for display and I could edit individual cells easily by say, right clicking the cell, saying "change value" and then being given a box to enter the new value, and it will write and execute the sql for me? Or something similar?
For MySQL:
SQLYog - https://www.webyog.com/
MySQL WorkBench - http://www.mysql.com/produ cts/workbe nch/
SQLYog - https://www.webyog.com/
MySQL WorkBench - http://www.mysql.com/produ
ASKER
Will these work with DB2?
Probably not.
You posted this in the MSSQL and MySQL Zones, so the links provided are specifically for those 2
You posted this in the MSSQL and MySQL Zones, so the links provided are specifically for those 2
have you considered MS Access and using table links... that would allow quick and dirty ability to display and change the data values....
or di you mean you want to be able to change the table structures?
or di you mean you want to be able to change the table structures?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I actually prefer to write update statements when doing object updates. This way I can save it so I know exactly what was changed, when, and who did it. But then I am a bit of a control freak and want to be able to easily reverse and changes.
http://www.microsoft.com/en-us/download/details.aspx?id=7593