e1seix Posted March 24, 2008 Share Posted March 24, 2008 Hi all, Was wondering if anyone knew of some sort of program that would allow you to edit table entries easier than having to go into each individual row. In my database I have over 6000 different products etc. As my products have been inserted from 8 different sources, they need to be edited and given relevant properties. Any ideas? Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted March 24, 2008 Share Posted March 24, 2008 For a one-time operation, it would be easiest to export the data in a CSV format, open it in a spreadsheet, make the changes, and then import the CSV back into your database. Quote Link to comment Share on other sites More sharing options...
Barand Posted March 24, 2008 Share Posted March 24, 2008 MySQL.com has a downloadable "MySQL Query Browser" app that lets you edit data Quote Link to comment Share on other sites More sharing options...
aschk Posted March 25, 2008 Share Posted March 25, 2008 You talk about giving them relevant "properties". What do you mean by this? It would seem that you should probably be doing mass operations use SQL (for which you don't even need a GUI). You can import the information into a temporary table (or a table you have created for temporary operations), perform your changes using SQL and then push the altered import into your real table. What is it you've changing or giving properties? If each "product" is individual it's hard not to edit each one separately (unless you have rules to differentiate). Let us know what SQL you are doing, what information you are importing, what your SQL tables look like, and what output you expect and we'll get right on it. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.