Ignore:
Timestamp:
2007/06/26 10:55:54 (13 years ago)
Author:
uehara
Message:
 
File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/dev/html/install/sql/insert_data.sql

    r14655 r14913  
    9797insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_product_id4','¤ª¤¹¤¹¤á¾¦ÉÊ(4)',51,now(),now()); 
    9898insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_comment4','¤ª¤¹¤¹¤á¥³¥á¥ó¥È(4)',52,now(),now()); 
     99insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_product_id5','¤ª¤¹¤¹¤á¾¦ÉÊ(5)',53,now(),now()); 
     100insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_comment5','¤ª¤¹¤¹¤á¥³¥á¥ó¥È(5)',54,now(),now()); 
     101insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_product_id6','¤ª¤¹¤¹¤á¾¦ÉÊ(6)',55,now(),now()); 
     102insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_comment6','¤ª¤¹¤¹¤á¥³¥á¥ó¥È(6)',56,now(),now()); 
    99103insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'category_id','¥«¥Æ¥´¥êID',53,now(),now()); 
    100104insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'customer_id','¸ÜµÒID',1,now(),now()); 
Note: See TracChangeset for help on using the changeset viewer.