We are going step by step through the process of converting a csv file to a sql file. In the first part, we discussed what tools we need to accomplish this task, as well as where to find a sample csv file to play with. We then covered creating the sql database in the second [...]
Entries Tagged as 'Data and Databases'
Converting csv to sql – Creating the Database
July 28th, 2007 · 2 Comments · Data and Databases
Continuing on from my previous post, we are now going to start the conversion process. The first step is to create the database and the table that we need. You can do this using PHPMyAdmin, but I generally prefer to use HeidiSQL. The process is basically the same in each case, but I find HeidiSQL [...]
Tags:
Converting csv to sql – Part I
July 27th, 2007 · No Comments · Data and Databases
I have been playing more with databases and less with PHP these last few days out of necessity, and I’ve had to convert a bunch of files over from .csv to .sql (MySQL). Now I generally don’t like to use a method if I don’t understand it, and I try to find a way that [...]
Tags:
Splitting large csv files – the CSV Splitter
June 29th, 2007 · 7 Comments · Data and Databases
Carrying on with the theme of data files and databases, I am going to talk a bit about .csv files. “csv” stands for Comma Separated Variables, and is a popular format that is supported by many spreadsheet and database applications. I work a lot with csv files, opening them in Excel to manipulate them, or [...]
Tags:
Some database tools – phpMyAdmin and HeidiSQL
June 25th, 2007 · 2 Comments · Data and Databases, PHP
In my last post I talked about dealing with a .sql file from the command line. This worked well, but there are other ways to interact with your databases that are GUI based, and perhaps easier for someone accustomed to dealing with the GUI interface. The two that I am currently playing with are PHPMyAdmin [...]
Tags:
