Archive for the 'MySQL' category

Two Simpler and Nicer PHP/MySQL Forums

Saturday, April 1st, 2006

I came across two very nice, easy and simple to install and manage Forum scripts based for PHP/MySQL:
Vanilla
PunBB
Here is a nice example of customizing PunBB at the Mint forums:
http://www.haveamint.com/forum/

Web, Software, Freebies, MySQL | 3 comments

Importing an SQL statement file into MySQL

Wednesday, February 22nd, 2006

Here is a way to import a SQL file that contains statements into MySQL:

mysql –user=youruser –password=yourpassword –database=yourdbname < yourscript.scr
This is excellent when you have let’s say 100,000 records, and you want to import them as INSERT statements, but the SQL file is like 20MB’s! All you need to do is:
1) Optional: Compress your SQL […]

MySQL | No comments

Interesting Article about Date Arithmetic With MySQL

Tuesday, January 17th, 2006

Found a great article at DevShed on “Date Arithmetic With MySQL“. The last few days we’ve been kind of puzzled about how to store and actually utilize dates, throwing them back and forth from PHP to MySQL. There seems to be a lack of documentation about MySQL date functions, I bet alot of people are […]

Web, PHP, Database, MySQL | No comments

Zip Code Database List

Friday, January 13th, 2006

Need a database full with zip codes/cities/area codes/population/counties, and much more? Me too. I’ve found a great one, with more information than you’ll ever need. Just $79.95 and you’re set. Download database as CSV/Access/Excel.

Check it out: Zip Code Database List
It took me a few hours to figure out how to import those two big ass […]

Software, Database, MySQL | No comments

You are currently browsing the archives for the MySQL category.

Meta