Category: Solutions
ERROR: Invalid default value for ‘created_at’ [solution]
I got a problem while adding a new column in the database as well as editing the column. The error says invalid default value for…
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.
How to recover shift+deleted files and folders in windows?
I accidentally deleted a folder in a desktop which I came to know was very useful to me. I searched in recycle Bin but could…