Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

STRICT_TRANS_TABLES SQL Mode

Status
Not open for further replies.
a6m1n0

a6m1n0

Programmer
Mar 7, 2005
233
US
I have been using MySQL in a windows environment now for a couple of years. I have used 4.x and now have been using 5.0.

I often had problems with v5 and eventualy tracked it down to the SQL mode STRICT_TRANS_TABLES which by default is enabled when using the MySQL MSI installer.

I have read the documentation at MySQL website on SQL modes but I am still trying to understand what this SQL mode is/does exactly.

Can someone explain this SQL mode to me? What is the purpose of this mode and how does it differ from default SQL mode used in 4.x?

Thanks

-a6m1n0

Curiosity only kills cats.
 
Status
Not open for further replies.

Similar threads

dylim
  • Locked
  • Question
SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29
Replies
2
Views
479
dylim
dylim
BJZeak
  • Locked
  • Question
need help with .sql insert statement
Replies
1
Views
129
spamjim
spamjim
AM_WG
  • Locked
  • Question
I need some help with SQL
Replies
13
Views
249
AM_WG
AM_WG
Arun Mahajan
  • Locked
  • Question
How to catch SQL Exception Error number in MySQL 5.6
Replies
0
Views
109
Arun Mahajan
Arun Mahajan
OrcusDanny
  • Locked
  • Question
SQL Question
Replies
9
Views
176
OrcusDanny
OrcusDanny

Part and Inventory Search

Sponsor

Back
Top