1. Windows cannot access the specified device, path or file. You may not have the appropriate permissions to access them.
By: Norman : 2011-09-23
Description: If you getting this error "Windows cannot access the specified device, path or file. You may not have the appropriate permissions to access them." then probably, you are trying to execute a exe file or a program downloaded from the internet, or copied from another location. In Windows, a downloaded executable or a copied executable is automatically marked as blocked.
Read the full article
 
2. ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client
By: Emiley J. : 2011-03-18
Description: When you use mysql to login to a MySQL server, if you receive this error, then it is something to do with your password versions. To resolve it, do the following.
Read the full article
 
3. Changing the Structure of an Existing Table in MySQL
By: Sathya Narayana : 2010-10-24
Description: First you'll add the price field to the table, using the ADD command and specifying the properties of the field: mysql> ALTER TABLE book ADD (price INTEGER);
Read the full article
 
4. Inserting Data into Tables in MySQL
By: Sathya Narayana : 2010-10-24
Description: To do this, you need to use the INSERT INTO...VALUES command.
Read the full article
 
5. Querying the Database in MySQL
By: Sathya Narayana : 2010-10-24
Description: When retrieving data with a SELECT query, you can order the returned rows by adding an ORDER BY clause to the command. The ORDER BY statement is followed by the column that you want to sort on, and finally you specify whether to order highest to lowest (a descending sort as indicated by DESC) or lowest to highest (an ascending sort, as indicated by ASC). ASC is the default sort, so it's assumed if neither DESC nor ASC is specified. For instance, the following command displays books in order of price, highest price first:
Read the full article
 
6. Modifying data and using WHERE clause in MySQL
By: Sathya Narayana : 2010-10-24
Description: You can modify data using the UPDATE...SET command. When using this syntax, you simply specify the table where you want to change column values after the UPDATE statement and specify which column or columns are to be affected after the SET statement.
Read the full article
 
7. Deleting Data in MySQL
By: Sathya Narayana : 2010-10-24
Description: To delete a given row or set of rows, you use the DELETE FROM...WHERE command. For instance, you can delete the book called Mr Bunny's Guide to JDO with this command:
Read the full article
 
8. What is SQL Injection
By: Emiley J. : 2008-11-23
Description: SQL Injection is a method in which an attacker inserts malicious code into queries that run on your database.
Read the full article
 
9. MySQL Strengths and Weaknesses
By: Emiley J. : 2008-11-23
Description: This article contains some information about the strengths and weaknesses of MySQL.
Read the full article
 
10. Table __________ is marked as crashed and should be repaired.
By: Emiley J. : 2008-09-18
Description: Recently a friend of mine called me at 12 midnight. His voice was shaky and had a sense of urgency. "My Site is down. Can you help me with it?". I told him, "Its midnight here, do you mind?". He didn't seem to like my sense of humour. He was in panic. I recalled that his site was entirely dynamically generated with PHP and MySQL. All the pages were dynamically generated from the database. So if the database is down, his site is down.
Read the full article