Archives
Convert csv to sql - Creating the sql file
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 […]
read more from " Convert csv to sql - Creating the sql file "
Convert csv to sql - Importing the csv file
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 […]
read more from " Convert csv to sql - Importing the csv file "
Converting csv to sql - Creating the Database
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 […]
read more from " Converting csv to sql - Creating the Database "
Converting csv to sql - Part I
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 […]
Learning PHP and MySQL - Good Books to Have
If you are serious about learning PHP and MySQL, you need good resources. There are many online tutorials and websites, and I have listed some really useful resources in a previous post. If you are like me and prefer to not read off a screen, and instead like to use a book, there […]
read more from " Learning PHP and MySQL - Good Books to Have "
Saying No to PageRank - An Aside
So this post has nothing to do with programming, or coding, PHP, mySQL, databases, or any of that other sweet stuff that I’ve been talking about. BUT, it is relevant, because it addresses an issue that you as a potential future or current webmaster will face, or already faces… the mad dash for page rank.
While […]
