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

How to get only number from string in Python?

Categories

Main Tags

Latest Posts

Most Popular

How to get only number from string in Python?

ModuleNotFoundError: No module named 'psycopg2' django

How to change the date format in Laravel view page