Link to home
Start Free TrialLog in
Avatar of Peter Chan
Peter ChanFlag for Hong Kong

asked on

Problem to insert statement

Hi,
How to resolve the problem below?

10:33:45  insert into conv_store.c_store_vg(store_no,dscr,address_eng,address_chi,location_eng,location_chi,zone,latitute,longitube,closed_on_sat,closed_on_sun,closed_on_holiday,operation_day_eng,operation_day_chi,operation_hour_eng,operation_hour_chi,open_date,close_date,route_mon,route_tue,route_wed,route_thu,route_fri,route_sat,route_sun,sfzone,in_time,in_by,mod_time,mod_by,deleted,sms_addr_eng,sms_addr_chi,send_sms,StoreCapacity,AvailableCapacity) values('3038','852A6001',' ','上水鳳南路9號翠麗花園商場地下1及2A號鋪',' ','北區','新界',0,0,0,0,0,'','','Monday-Friday   (09:00-21:00) , Saturday Sunday & Public Holiday (12:00-20:00)','星期一至五上午 09:00 - 晚上 21:00  星期六日及公眾假期  上午12:00 - 晚上20:00',str_to_date('01/01/2000','%m/%d/%Y'),null,'','','','','','','','852A',now(),'VG_FTP',now(),'VG_FTP',0,'','',0,40,40,'','','') Error Code: 1136. Column count doesn't match value count at row 1       0.125 sec
ASKER CERTIFIED SOLUTION
Avatar of Mukesh Yadav
Mukesh Yadav
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial