Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to enable STRICT_ALL_TABLES' for single MySQL database?

Tags:

mysql

Is there a way to enable STRICT_ALL_TABLES for a single MySQL database?

like image 960
Greg Avatar asked Nov 05 '22 23:11

Greg

1 Answers

set sql_mode = 'STRICT_ALL_TABLES'; will do it.

like image 168
rgh Avatar answered Nov 14 '22 20:11

rgh
Sign in to Comment

Related questions

Add a PDF to customer - laravel 5.7
Install wordpress on Ubuntu 18.04 LTS
How to use Entity Framework for applications with many clients
AWS Glue not copying id(int) column to Redshift - it's blank
Can this subquery be made to use the index?
SQL date discrepancy with some dates
docker mysql wordpress port doesn't connect
Join column from one table to another column in other table CodeIgniter
Blacklist / Whitelist Table Design
Inserting Image to the MySQL database via Spring Boot
How to have my template "load" for a second or two before refreshing after a POST
Dynamic db connection during every api calls in Sequelize which has 'n' no of databases
Entity Framework Core: Update() method INSERTs instead of UPDATEs on dependent entity
Unable to obtain isolated JDBC connection: org.hibernate.exception.JDBCConnectionException
Get count for each group, but stop counting after N result rows in each group
Inserting JSON data line by line into an SQL table
Why is limit 0,1 slower than limit 0, 17
Why do I get 'MySQL server has gone away' after running a Telegram bot for some hours?
Using utf8mb4 in MySQL

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!