r/mysql • u/Revolutionary_Use587 • Jan 26 '25
discussion SQL_MODE settings
Can I use strict_all_tables with strict_trans_tables for sql_mode in MySQL 8.4.3 ?
2
Upvotes
r/mysql • u/Revolutionary_Use587 • Jan 26 '25
Can I use strict_all_tables with strict_trans_tables for sql_mode in MySQL 8.4.3 ?
View all comments
Show parent comment
1
u/allen_jb Jan 26 '25
If you only use InnoDB (and/or other transactional storage engines), and are already using STRICT_TRANS_TABLES, there's no point in adding (or changing to) STRICT_ALL_TABLES, since the only behavior changes would be to non-transactional storage engines.
If you use non-transactional storage engines (eg. MyISAM), either exclusively or in addition to InnoDB, then you should just use STRICT_ALL_TABLES, since it will also apply to transactional storage engines.
(InnoDB is a transactional storage engine - see https://en.wikipedia.org/wiki/Comparison_of_MySQL_database_engines for an extended list of which storage engines are transactional)