Personally, I use Navicat (or the free alternative, HeidiSQL) for what you're trying to do. They have options to export and import (!!!) into different formats, whether it be exporting raw SQL or exporting data into an Excel Spreadsheet, and modifying it there.
Seriously, these tools help tremendously. If you're still learning, chances are you don't know how spawn2 spawnentries spawngroups and npc_types link in together, but you can see how they work together by reading the spawn tutorial posted in this thread.
Seeing a visual of a database and its columns helps a lot, that's why I advise using these programs to learn and when you're done learning, you can use them to make things tons quicker.
Best of luck on learning, if you need any assistance with learning the database, just shoot a PM. I'll be glad to help with any small questions.
|