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

Evolution History of computer Technology

Evolution History of computer Technology (HISTORY OF COMPUTER) Evolution of computer is a study of…

2 days ago

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

Unit3_ClassMethodDesign_OOAD   DOWNLOAD

3 weeks ago

Maturity of Enterprise Architecture Practice

Maturity of Enterprise Architecture Practice Maturity of Enterprise Architecture Practice   DOWNLOAD

4 weeks ago

Chapterwise Practise Question for Class XII Second Terminal Examination – 2082

Report-on-final-project_Sample_2

6 months ago

Computer Science Project Report Guidelines and Sample

Guidelines (Click Below to Download) SAMPLE 1 SAMPLE 2

7 months ago

How to make id card of Khwopa Secondary School ?

10 months ago

Privacy Policy | Terms of Use | About