-
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)
Database Archive
-
MySQL GUI Tools – Still ready for Prime Time
Posted on September 9, 2010 | No CommentsMySQL ceased development of their GUI Tools, MySQL Administrator and MySQL Query Browser, with the release of their MySQL Workbench product. Workbench is supposed to incorporate the functions of Administrator... -
Selecting Field Names in MySQL
Posted on October 6, 2009 | No CommentsSelecting field names in MySQL is pretty easy, though it's not quite like the SELECT syntax we're all used to: SHOW COLUMNS FROM TABLE; To select all fields that start... -
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 >... -
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...