-
Recent Posts
Blogroll
Categories
- Application Tips (2)
- CSS (6)
- Database (10)
- DHTML (2)
- DOS & DOS Scripting (2)
- Graphics (3)
- iPhone (1)
- JavaScript (3)
- Joomla! (11)
- Linux (2)
- MySQL (25)
- Networking (2)
- Operating Systems (5)
- PHP (24)
- Resources (2)
- Snippet (1)
- Uncategorized (38)
- Vista (2)
- Web Development (18)
- WordPress (12)
Tutorius Archives
- January 2012 (1)
- December 2011 (1)
- November 2011 (2)
- October 2011 (4)
- September 2011 (2)
- March 2011 (3)
- December 2010 (1)
- November 2010 (2)
- September 2010 (2)
- August 2010 (5)
- June 2010 (5)
- May 2010 (8)
- April 2010 (6)
- March 2010 (5)
- January 2010 (3)
- December 2009 (2)
- November 2009 (11)
- October 2009 (12)
- September 2009 (3)
- August 2009 (8)
- July 2009 (9)
- June 2009 (4)
- May 2009 (1)
- April 2009 (1)
- February 2009 (3)
- January 2009 (3)
- December 2008 (1)
- November 2008 (3)
- October 2008 (3)
- September 2008 (5)
- August 2008 (7)
- June 2008 (3)
- March 2008 (3)
- February 2008 (1)
- January 2008 (1)
- November 2007 (3)
MySQL Archive
-
Access Column names in MySQL
Posted on January 12, 2012 | No CommentsI recently needed to create a page that would serve as a light admin page for my configuration table. Just read in the table and let me edit the values. However,... -
MySQL Scheduled Backup
Posted on November 2, 2011 | No CommentsAnother of these things that I'll park here until I have the time to implement it. A MySQL backup solution to to scheduled backups and optionally email the backup files... -
MySQL Triggers
Posted on November 2, 2011 | No CommentsThis external resource looks like about the best tutorial I've seen yet for MySQL Triggers. I'm going to have to play with this, I've been putting off implementing some necessary triggers for... -
Foreign Keys and Referential Integrity in MySQL
Posted on October 14, 2011 | No CommentsThis TechRepublic article is a good fast introduction to the topic of Referential Integrity and the use of Foreign Keys in MySQL. -
Trim leading whitespace from a field in MySQL
Posted on September 25, 2011 | No CommentsAs always, backup the database or at least the affected table before running a command that will change every record in a table as this does. The following line will...