Thread: SQL Server 2008
View Single Post
  #6  
Old 04-17-2009, 08:54 AM
So_1337
Dragon
 
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
Default

.csv files are simply comma separated values. It's a popular export method for a lot of Windows-based programs like Excel, Access, and MySQL.

I've gone through the work before of exporting entire tables from MySQL into .csv, opening them in Excel, adding a blank column before all the information, and then using it to write queries. From there, I just copy the whole deal into a text file, save it as a .sql file, and source it in. So for most tables that are just simple integers or text, that would work for you, though it'd take some work. I have no idea how you'd handle anything like the player profile or blobs.
Reply With Quote