Category Archives Data and Databases

In previous posts we've discussed getting your csv files into sql format using different methods. I walked you through the process from csv to sql using HeidiSQL and PHPMyAdmin. I then did a follow up on how to import a large csv file into a MySQL database using the MySQL command prompt. In all these instances, what we were essentially…

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 know. Happy coding!

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 way to do it. Say…

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 course your csv file. The…

Close