MySQL Tutorials

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.


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.


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);


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.


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:


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.


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:


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.


9. MySQL Strengths and Weaknesses

By: Emiley J. : 2008-11-23

Description: This article contains some information about the strengths and weaknesses of MySQL.


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.