-
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
-
Using Variables in MySQL
Posted on September 24, 2011 | No CommentsFinding the correct syntax for using variables in MySQL can be surprisingly difficult. Once you know it, it's easy. Here's a start: SET @username := 'jonesr'; SELECT id,fname,lname FROM staff... -
MySQL Error Number 1045
Posted on December 4, 2010 | No CommentsConnection attempts to a MySQL database can return "MySQL Error Number 1045″. This is a frustrating error, but has a reasonably simple solution. While this solution is presented in the... -
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... -
Loading configuration data from a MySQL into PHP constants
Posted on May 12, 2010 | No CommentsThe following code will take the contents of the first row of a configuration table and create a constant for each attribute stored in it. 1 2 3 4 5... -
Cannot edit table data in MySQL Query Browser
Posted on March 26, 2010 | No CommentsIf a table cannot be edited in MySQL, check to ensure that it has a primary key. This can arise if a table is copied from another table – the...