MySQL Tutorials
MySQL Strengths and Weaknesses

- 2008-11-23
- Comments
- Emiley J.
- 1161
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
- 1161
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
- 1161
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
- 1161
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
- 1161
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
- 1161
To do this, you need to use the INSERT INTO...VALUES command.
Read More
- Data Science
- Android
- AJAX
- ASP.net
- C
- C++
- C#
- Cocoa
- Cloud Computing
- HTML5
- Java
- Javascript
- JSF
- JSP
- J2ME
- Java Beans
- EJB
- JDBC
- Linux
- Mac OS X
- iPhone
- MySQL
- Office 365
- Perl
- PHP
- Python
- Ruby
- VB.net
- Hibernate
- Struts
- SAP
- Trends
- Tech Reviews
- WebServices
- XML
- Certification
- Interview
categories
Subscribe to Tutorials
Related Tutorials
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
MySQL Strengths and Weaknesses
Table __________ is marked as crashed and should be repaired.
Archived Comments
1. java.lang.IllegalArgumentException means usually t
View Tutorial By: Seink at 2008-11-12 11:03:00
2. an excellentttttttt siteee
View Tutorial By: raza at 2011-04-02 10:39:46
3. Hi,
can anyone show or send me a sample pro
View Tutorial By: jsn10 at 2011-09-14 05:41:03
4. thank you soo much .. itss realy helpful.... :)
View Tutorial By: prakriti at 2011-12-03 16:47:11
5. Excellent example! Thanks a ton:-)
One ques
View Tutorial By: Andrew at 2009-04-11 09:15:19
6. Thank so much it helped me God bless :)
View Tutorial By: Judito at 2014-06-14 06:52:18
7. @Askia-Just change RadioButton1 to RadioButton2 in
View Tutorial By: Nelson at 2010-03-06 23:12:36
8. Thank you , It is really good for beginners.
View Tutorial By: Satish Kumar at 2010-01-18 03:06:49
9. Dude, you made my day.
View Tutorial By: Sebastián at 2011-08-29 14:01:10
10. Good info.. keep providing..
View Tutorial By: Shoaeb uddin khaleefah at 2010-07-27 05:28:19