MySQL Tutorials

MySQL Strengths and Weaknesses

  • 2008-11-23
  • Comments
  • Emiley J.
  • 153210

This article contains some information about the strengths and weaknesses of MySQL.
Read More

Changing the Structure of an Existing Table in MySQL

  • 2010-10-24
  • Comments
  • Sathya Narayana
  • 153195

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 More

Querying the Database in MySQL

  • 2010-10-24
  • Comments
  • Sathya Narayana
  • 153160

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 More

Modifying data and using WHERE clause in MySQL

  • 2010-10-24
  • Comments
  • Sathya Narayana
  • 153184

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 More

Deleting Data in MySQL

  • 2010-10-24
  • Comments
  • Sathya Narayana
  • 153189

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 More

Inserting Data into Tables in MySQL

  • 2010-10-24
  • Comments
  • Sathya Narayana
  • 153176

To do this, you need to use the INSERT INTO...VALUES command.
Read More

Most Viewed Articles on MySQL

Latest Tutorials

Subscribe to Tutorials

Related Tutorials

Windows cannot access the specified device, path or file. You may not have the appropriate permissions to access them.

ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Changing the Structure of an Existing Table in MySQL

Inserting Data into Tables in MySQL

Querying the Database in MySQL

Modifying data and using WHERE clause in MySQL

Deleting Data in MySQL

What is SQL Injection

MySQL Strengths and Weaknesses

Table __________ is marked as crashed and should be repaired.

Archived Comments

1. i can saved when i run the program...
but w

View Tutorial          By: kathleen ashley at 2010-08-02 05:22:46

2. Create a lexical analyzer of the C- programming la
View Tutorial          By: lucky at 2011-05-06 23:05:22

3. it was very helpful to fix one obscure bug
View Tutorial          By: ander13 at 2009-06-30 04:51:47

4. hellow my name is samer, i have a project of final
View Tutorial          By: samer flayha at 2011-08-17 09:37:16

5. Hi all people...If i need to read a sms from the m
View Tutorial          By: Omarsi12 at 2009-09-06 17:11:15

6. it's really Nice Clock
View Tutorial          By: Mido at 2007-09-09 08:45:49

7. I am an MCA student i wanna know whether one can s
View Tutorial          By: RAJU.K at 2009-07-24 02:28:21

8. I was trying to copy your coding and execute it, b
View Tutorial          By: Guest at 2012-01-02 04:08:21

9. thank you...as a beginner this info very useful fo
View Tutorial          By: snigdha at 2012-10-17 11:41:39

10. FilenameFilter only = new OnlyExt("html"
View Tutorial          By: joyes at 2009-08-25 11:34:13