Peter Chan
asked on
Problem to insert statement
Hi,
How to resolve the problem below?
10:33:45 insert into conv_store.c_store_vg(stor e_no,dscr, address_en g,address_ chi,locati on_eng,loc ation_chi, zone,latit ute,longit ube,closed _on_sat,cl osed_on_su n,closed_o n_holiday, operation_ day_eng,op eration_da y_chi,oper ation_hour _eng,opera tion_hour_ chi,open_d ate,close_ date,route _mon,route _tue,route _wed,route _thu,route _fri,route _sat,route _sun,sfzon e,in_time, in_by,mod_ time,mod_b y,deleted, sms_addr_e ng,sms_add r_chi,send _sms,Store Capacity,A vailableCa pacity) 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/0 1/2000','% m/%d/%Y'), null,'','' ,'','','', '','','852 A',now(),' VG_FTP',no w(),'VG_FT P',0,'','' ,0,40,40,' ','','') Error Code: 1136. Column count doesn't match value count at row 1 0.125 sec
How to resolve the problem below?
10:33:45 insert into conv_store.c_store_vg(stor
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.