Categories: Solutions

How to solve Invalid default value for ‘created_at’ while adding new column in database.

[Problem:]
While adding new column to the table by alter method, I used this sql code

 

ALTER TABLE investments ADD bank TEXT;
ERROR 1067 (42000): Invalid default value for ‘created_at’

 

But An eeror came thought I tried various data type
ERROR 1067 (42000): Invalid default value for ‘created_at’

 

[solution]
The problem in my database is current mode is in the sql_mode

 

SO, in the sql I typed and hit the commend
set global sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

 

 

and it solved the problem.
jaminrai

Share
Published by
jaminrai
Tags: database probleminvalid
6 years ago

Recent Posts

“Unit 3: Class and Method Design” Constraints, Contracts, Method Specification & Object Persistence

Unit3_ClassMethodDesign_OOAD   DOWNLOAD

1 day ago

Maturity of Enterprise Architecture Practice

Maturity of Enterprise Architecture Practice Maturity of Enterprise Architecture Practice   DOWNLOAD

1 week ago

Chapterwise Practise Question for Class XII Second Terminal Examination – 2082

Report-on-final-project_Sample_2

5 months ago

Computer Science Project Report Guidelines and Sample

Guidelines (Click Below to Download) SAMPLE 1 SAMPLE 2

6 months ago

How to make id card of Khwopa Secondary School ?

9 months ago

Skype Closes Its Doors After 20 Years: A Look Back and the Apps That Faded with It

After 20 years of transforming global communication, Skype has officially ceased operations. Microsoft, which purchased…

1 year ago

Privacy Policy | Terms of Use | About