I recently came across a website that has a bunch of free database tools. These are PHP scripts. I haven’t tried any of these tools so I can’t really vouch for them. The website is http://scripts.ringsworld.com/database-tools/. If you have used any of the tools listed on this page, please leave a comment and let us [...]
Entries Tagged as 'Data and Databases'
Free database tools
September 15th, 2007 · No Comments · Data and Databases, Useful Links and Resources
Tags:
Importing large csv files into sql using the command prompt
September 10th, 2007 · 2 Comments · Data and Databases
I recently did a series of posts on how to convert a csv file into a sql file. You can see a summary here that will lead you to the other posts. In that series I talked you through doing the import using HeidiSQL and then creating the sql file using phpMyAdmin, a process which [...]
Tags:
Finding and Deleting Duplicates in Excel
August 12th, 2007 · No Comments · Data and Databases
Sometimes when working with large excel spreadsheets, you run into the problem of duplicates, and it helps to be able to find them and delete them without having to manually go through the spreadsheet. If you have two or more columns of data, and you need to find and delete the duplicates, this is one [...]
Tags:
From csv to sql – in brief
August 7th, 2007 · 1 Comment · Data and Databases
In my last few posts I explained in a four-part tutorial how to convert a csv file to a sql file. I am going to summarize the steps in this post so that you have them all in one reference post. The tools that I prefer for this process are PHPMyAdmin and HeidiSQL, and of [...]
Tags:
Convert csv to sql – Creating the sql file
July 31st, 2007 · No Comments · Data and Databases
This is the last part in a series of tutorials on how to create a sql file from a csv file. First, we determined what was needed for the process, then we created the MySQL database and tables, and finally we imported the csv file into the MySQL database. In this last step, we are [...]
Tags:
