Desktop Application

[e1seix]

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?

[PFMaBiSmAd]

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.

[Barand]

MySQL.com has a downloadable  "MySQL Query Browser" app that lets you edit data

[aschk]

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.