Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3£©È»ºóÔÙinsertµ½Êý¾Ý¿âÀï

µ«ÊÇÖмäµÄת»»Ëƺõ³ýÁËÎÊÌ⣬ûÓÐÊý¾Ý
Çë¸÷λ°ïæ¿´¿´ÊDz»ÊÇÄÄÀï³öÁËÎÊÌâ

¡ý¡ý¡ý
if ($_FILES['csv_file_road']['tmp_name'] != '') {
$all_name = $_FILES['csv_file_road']['tmp_name'];
$file_name = $ADDRESS_CSV_COMMON_USER.'.csv';
if(!copy($all_name,CSVWAY.$file_name)){
$messageStack->add("ÎļþÉÏ´«Ê§°Ü", 'error');
return;
}
}
$handle = fopen (CSVWAY.$file_name,"r");
while ($data = fgetcsv ($handle, 5000, ",")) {
$row_num = $row_num+1;//now read csv row-num
$error_info = "";
if($row_num == 1){
continue;
}
$num = count ($data);
if($num < 14){
continue;
}
for ($c1=0; $c1 < $num; $c1++) {
            $data[$c1] = mb_convert_encoding($data[$c1],'UTF-8',"GB2312,shift_jis");
          }
         
$check_array['SUBJECT'] = trim($data['1']);
$check_array['


Ïà¹ØÎÊ´ð£º

ÈçºÎÓÃc#£¬sql2000 ¿ª·¢c/sÏµĹ¤×÷Á÷£¿

±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

pl/sqlµ¼ÈëÊý¾ÝÎÊÌâ

ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç  "2009-01","8949-232"

½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......

SQLÁ½±íÁ¬½Ó£¬²åÈëÊý¾ÝµÄÎÊÌâ

ÎÒÏÖÔÚÓÐÁ½ÕÅ±í£º
    Ò»ÕÅuser±íÓÐname£¨ÐÕÃû£©ºÍstarID£¨ÐÇ×ùµÄID£©Á½¸öÁУ¬»¹ÓÐÒ»ÕÅstars±íÓÐID£¨ÐÇ×ùµÄID£©ºÍstar£¨ÐÇ×ùÃû£©Á½¸öÁУ¬È»ºóstars±íµÄIDÊÇÖ÷¼ü£¬user±íµÄstarIDÊÇÍâ¼ü¡£

ÎÊÌâ¾Í ......

SQL 2008 ÐÂÊÖÎÊÌ⣿£¿£¿

sql 2008ÖÐР¸½¼ÓµÄÊý¾Ý¿â£¬ÈçºÎÓÃDDLÓïÑÔÌí¼Ó¡°ËùÓÐÕß¡±£»
ÊÖ¶¯µÄ·½Ê½Îª£ºÊó±êÔÚи½¼ÓµÄÊý¾Ý¿âÉÏÓÒ¼ü——>ÊôÐÔ——>Îļþ——>ËùÓÐÕߣ¬È»ºóÓұ߿հ׼üÑ¡Ôñ£»
DDLÓï¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ