Code Gripper

MySQL

SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'

byMahabubur Rahman -July 15, 2023

I finally found the solutions a days ago and I remembered this post. In the config/database.php file in mysql tag, the sql modes should be added in order to skip this error. https://de…

MySQL

How to add 'created_at' and 'updated_at' columns?

byMahabubur Rahman -September 21, 2022

According to the reference manual * you can use the DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP clauses in column definitions: With both DEFAULT CURRENT_TIMESTAMP and…

MySQL

Like or Like Query MySQL

byMahabubur Rahman -December 26, 2021

MySQL Like Or Like Query Exmaple - SELECT * FROM users WHERE name LIKE '%Value1' OR name LIKE '%Value2%';

Breaking

Code Gripper

SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'

How to add 'created_at' and 'updated_at' columns?

Like or Like Query MySQL

Categories

Main Tags

Latest Posts

Most Popular