Topic: ALTER TABLE ADD COLUMN NOT ACCEPTING
I was trying to update a table by adding 2 extra column using phpmyadmin.
but I am getting this error "#1067 invalid default value for 'trans_date'"
The table I am trying to ALTER IS bank_trans.
ALTER TABLE `bank_trans` ADD `cheque_no` VARCHAR(60) NULL AFTER `ref`;
This is the error I am getting "#1067 invalid default value for 'trans_date'"
What how can one add an extra column in a table to retrieve and save?
I wanted to add a check no to the payment, under reference, because, when you make payment from the bank you need a check or transfer letter(Reference)
How do I modify that?