project3 case study 3
I have imported the excel file into mysql workbench but while converting created at and activated at column from string type to date type as shown in the vedio i was getting the below error 12:11:28 update users set tempcreatedat = strtodate(created_at, '%d-%m-%y %H:%i') Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect. 0.016 sec can someone help me to resolve this I have disabled the safe mode still i was getting error while changing the datatype as per the guided video UPDATE users SET tempcreatedat = strtodate(created_at, '%d/%m/%Y %H:%i'); 17:05:08 UPDATE users SET tempcreatedat = strtodate(createdat, '%d/%m/%Y %H:%i') Error Code: 1411. Incorrect datetime value: '13-01-2013 16:00' for function strto_date 0.000 sec
