Below is my original table in database which save customer login information.
Before the new column that allow users to upload their display image is added, my system works fine with the existing table.
CREATE TABLE IF NOT EXISTS `customerdetail` (
`customer_id` varchar(20) NOT NULL,
`customer_pass1` varchar(20) NOT NULL,
`customer_pass2` varchar(20) NOT NULL,
`customer_pass3` varchar(20) NOT NULL,
`customer_pass4` varchar(20) NOT NULL,
`customer_pass5` varchar(20) NOT NULL,
`customer_email` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PS: I use 5 password fields due to requirement.
After i add in the line below the add the new column ( display picture function ) :
Then my system can't write any data into the table anymore even i upload an "empty" picture.
ALTER TABLE customerdetail ADD customer_display blob NOT NULL;
Can anyone please verify for me what i did wrongly ?
Thank you so much for helping. I appreciate a lot.