Handling Error Messages and Warnings with MySQL

To ensure that your MySQL Database works as efficiently as possible, it is important to know how to handle error messages and warnings.

Error messages have three components:

  • A MySQL-specific error code, such as 1146
  • A SQLSTATE error code. These codes are defined by standard SQL and the ODBC standard.
  • A text message that describes the problem

MySQL Server generates a warning when it is not fully able to comply with a request or when an action has possibly unintended side effects. You can display these warnings with the SHOW WARNINGS statement.

To learn about handling error messages and warnings along with other developer topics, consider taking the MySQL for Developers training course.

You can take this 5-day course as a:

  • Live-virtual event: Attend a live training event from your own desk, no travel required. Choose from a selection of events on the schedule to suti different timezones.
  • In-class event: Travel to an education center to attend a class. Below is a selection of the events already on the schedule.

 Locaation

 Date

 Delivery Languaage

 Vienna, Austria

 27 November 2014

 German

 Brussels, Belgium

 8 December 2014

 English

 Sao Paolo, Brazil

 13 October 2014

 Brazilian Portuguese

 London, England

 29 September 2014

 English

 Belfast, Ireland

 6 October 2014

 English

 Dublin, Ireland

 27 October 2014

 English

 Milan, Italy

 10 November 2014

 Italian

 Rome, Italy

 13 October 2014

 Italian

 Nairobi, Kenya

 15 September 2014

 English

 Petaling Jaya, Malaysia

 25 August 2014

 English

 Utrecht, Netherlands

 8 December 2014

 English

 Makati City, Phillippines

 29 September 2014

 English

 Warsaw, Poland

 25 August 2014

 Polish

 Lisbon, Portugal

 13 October 2014

 European Portuguese

 Porto, Portugal

 13 October 2014

 European Portuguese

 Barcelona, Spain

 29 October 2014

 Spanish

 Madrid, Spain

 3 November 2014

 Spanish

 Valencia, Spain

 24 November 2014

 Spanish

 Basel, Switzerland

 13 October 2014

 German

 Bern, Switzerland

 13 October 2014

 German

 Zurick, Switzerland

 13 October 2014

 German

The MySQL for Developers course is the recommended training for the MySQL 5.6 Developers OCP certification exam.

To register for the MySQL for Developers course, request an additional event, or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Comments:

Post a Comment:
Comments are closed for this entry.
About

Get the latest updates on products, technology, news, events, webcasts, customers and more.

Twitter


Facebook

Search

Archives
« May 2015
SunMonTueWedThuFriSat
     
2
3
4
5
6
8
9
10
13
14
15
16
17
19
20
21
22
23
24
25
26
27
28
29
30
31
      
Today