MySQL Modes

• The MySQL server can operate in different SQL modes.
  • These modes can apply differently for different clients.
    • This capability enables each application to tailor the server's operating mode to its own requirements.

• Modes define what SQL syntax MySQL should support and what kind of data validation checks it should perform.
  • Makes it easier to use MySQL in different environments.
  • Lets MySQL work together with other database servers.

• To change the SQL mode at runtime use the SET [GLOBAL|SESSION] sql_mode='modes' statement.

What are the important sql_mode values?

---

---

© 2007 John Michael Pierobon

Notes