Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010
    Posts
    15

    Unanswered: Problem to the statement

    Hi,
    Any advice to resolve this problem?

    10:33:45 insert into conv_store.c_store_vg(store_no,dscr,address_eng,ad dress_chi,location_eng,location_chi,zone,latitute, longitube,closed_on_sat,closed_on_sun,closed_on_ho liday,operation_day_eng,operation_day_chi,operatio n_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',' ','地下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_FT P',now(),'VG_FTP',0,'','',0,40,40,'','','') Error Code: 1136. Column count doesn't match value count at row 1 0.125 sec
    Many Thanks & Best Regards,
    HuaMin Chen

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    yes include all necessary columns of the table in your insert statement. This is telling you that you left something out. you have X columns in the insert statement and Y values in your values clause.
    Dave

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •