-
Recent Posts
Blogroll
Tags
AJAX Form Validation analytics apache auto-login auto-logon autologin autologon background background-color center centre color colour Contacts conversion CSS DHTML div dns EasyDNS google google analytics Google Apps gradient graphics htaccess image iPhone JavaScript Joomla! Joomla sample data jquery jump ms word mysql Outlook paste rewrite round robin scroll sortable validation vertical Vista WordPressCategories
- Application Tips (2)
- CSS (6)
- Database (11)
- DHTML (2)
- DOS & DOS Scripting (2)
- Graphics (4)
- iPhone (1)
- JavaScript (5)
- Joomla! (11)
- Linux (2)
- MySQL (26)
- Networking (2)
- Operating Systems (5)
- PHP (25)
- Resources (2)
- Snippet (2)
- Uncategorized (38)
- Vista (2)
- Web Development (21)
- WordPress (12)
Tutorius Archives
- April 2012 (1)
- March 2012 (4)
- 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
-
Resetting a MySQL Password
Posted on August 5, 2009 | No CommentsResetting a MySQL root password (or other password, for that matter) is easy enough if you have admin access to the server. First go to the command line (Start >... -
Importing a Spreadsheet or .CSV file into MySQL
Posted on August 5, 2009 | No CommentsImporting a spreadsheet, or its comma separated (CSV) equivalent, into a MySQL database can be enormously challenging and frustrating. After many attempts at the solutions available through online searches, I... -
Adding a UNIQUE constraint to a database column
Posted on July 31, 2009 | No CommentsSometimes we may need to make a column unique in a database table. For instance we can't have two employees with the same employees with the same employee number or... -
Pulling database values in multiple formats
Posted on July 31, 2009 | No CommentsWhen we pull a value from MySQL or another database, there's nothing stopping us from pulling the same value in different ways within the same query. For instance, say we want to... -
Import CSV file to MySQL Database using PHP
Posted on July 28, 2009 | No Comments<!--p /** ~~~~~~~ CSV IMPORT TO DATABASE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ * * This script reads in a comma delimited text file (.csv) and creates * a table in the database from...