Class
  • Tip&Tech
[¾Ë°í¸®Áò] ¹«ÀÛÀ§ ¹®ÀÚ¿­·Î ´Ù·®ÀÇ Å×½ºÆ® °Ô½Ã±Û INSERT
±Û¾´ÀÌ ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¸¶³Ä ³¯ Â¥ 12-03-30 10:03 Á¶ ȸ 1596
°£ÆíURL http://www.phpschool.com/link/tipntech/75368 º¹»ç

SyntaxHighlight·Î º¸±â

Link1 http://www.tested.co.kr/exper/code/31 (161)
Link2 http://board.tested.co.kr/board/testtest (128)
ÄÚµå ÇÏÀ̶óÀÌÆ®°¡ ¾ø³×¿ä.
»ö±ÛÀº ¸µÅ© #1¿¡¼­ º¸½Ã¸é µË´Ï´Ù.
¸µÅ© #2´Â Àû¿ë ¿¹Á¦

Á¦ VPS ±âÁØÀ¸·Î ¸î¸¸ °ÇÀº Çѹø¿¡ Àß µé¾î°¡´Â µí½Í¾î¿ä. -_-


----    ----    ----    ----


ini_set('max_execution_time', -1);
ini_set('memory_limit', '128M');

// DB ¼³Á¤
mysql_connect('localhost', 'user', 'password');
mysql_select_db('db');
mysql_query(' set names euckr; ');

// ÇöÀç µî·ÏµÈ ÃÑ °Ô½Ã±Û °³¼ö
$row = current(mysql_fetch_row(mysql_query(" select count(*) from ki_write where bo_table = 'testtest'; ")));

// ¹«ÀÛÀ§ ¹®ÀÚ¿­
$str = "°¡³ª´Ù¶ó¸¶¹Ù»ç¾ÆÀÚÂ÷īŸÆÄÇÏAaBbCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz1234567890";

// Á¦ VPS ±âÁØÀ¸·Î 1500 ÀÌ»óÀÌ¸é ¿À·ù°¡ ¹ß»ýÇÔ
$max = 1500; // MAX limit 1500

// $max * $loop = µî·ÏµÉ °Ô½Ã±Û ¼ö
$loop = 10;

// ½ÃÀÛ ¹øÈ£
$cur = $row + 1;

// ³¡ ¹øÈ£
$end = $row + $max;

// ³¯Â¥ -_-
$date = date('Y-m-d H:i:s', time());

for ($i=1; $i<=$loop; $i++) {
  // ÇÊµå ¼³Á¤
  $sql = "INSERT INTO `ki_write` (`bo_table`, `wr_id`, `wr_subject`, `wr_content`, `wr_datetime`) VALUES";

  for ($k=$cur; $k<=$end; $k++) {
    $len = 76; // ¼³Á¤µÈ ¹«ÀÛÀ§ ¹®ÀÚ¿­ ±æÀÌ
    $sp = array();
    while ($len-- > 0) {
      $sp[] = mb_substr($str, $len, 4, 'EUC-KR'); // ³»¿ëÀÇ ±æÀÌ´Â ¼ýÀÚ 4¸¦ ¼öÁ¤
    }
    shuffle($sp);
    $content = implode('', $sp);
    $title = substr($content, 0, 30); // ³»¿ëÀÇ ¾ÕÀÚ¸®¸¦ Á¦¸ñÀ¸·Î

    $sql .= " ('testtest', ".$k.", '".$title."', '".$content."', '".$date."'),";
  }
  $sql = substr($sql, 0, -1).';';

  if (mysql_query($sql)) {
    echo 'No'.$i.': '.$date.'<br/>';

    $cur += $max;
    $end += $max;
  }
  else
    echo 'Fail'.$i.': '.$date.' - '.mysql_errno().': '.mysql_error().'<br/>';
}

// ÃÑ °Ô½Ã±Û ¼ö
$total = $row + ($max * $loop);

Àüü´ñ±Û¼ö 1

  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¼ÛÈ¿Áø 12-03-30 13:38

    ¼Ò½ºº¸±â

  • Äõ¸®±æÀÌ¿¡ ¿ä°Ô ¿µÇâ ÀÖÀ» µí. max_allowed_packet
  • °Ô½Ã¹° 12,478°Ç RSS
¹øÈ£ºÐ·ùÁ¦¸ñ±Û¾´À̳¯Â¥Á¶È¸
12,418 HTML scss (sass) ¼Ò°³ ¹× À©µµ ¼³Á¤ ¹æ¹ý [5] ¸µÅ© ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¼ÛÈ¿Áø 13-02-27 636
12,417 ½ºÅ©¸³Æ® Restful API¸¦ Á¦°øÇϴµ¥ ¾µ¸¸ÇÑ framework ¸µÅ© ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Æø½ºÅ׸®¾î 13-02-27 632
12,416 Á¤º¸ µµ·Î¸í ¿ìÆíÁÖ¼Ò (¾÷µ¥ÀÌÆ®, À¥È£½ºÆÃ, ¿µ¹® »ç¿ë°¡´É) [2] ÷ºÎÆÄÀÏ ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§casis 13-02-26 743
12,415 ¼­¹ö¿î¿µ ÁÖ±âÀûÀÎ ·ÎÄÃ>¸®¸ðÆ® rsync ½Ã mtime °Ë»ç·Î ¿äû ÁÙÀ̱â [1] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¼ÛÈ¿Áø 13-02-26 478
12,414 HTML Google Chrome 25 CSS ¹ö±×. inline-block Ç¥½Ã [1] ¸µÅ© ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Æø½ºÅ׸®¾î 13-02-26 564
12,413 HTML À¥ÆùÆ® ¾ÆÀÌÄÜ Font Awesome [6] ¸µÅ© Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¼ÛÈ¿Áø 13-02-22 1092
12,412 ½ºÅ©¸³Æ® ¼­¹ö¿¡¼­ ºê¶ó¿ìÀú¸¦ ¸¾´ë·Î ÄÁÆ®·ÑÇÏ´Â casper.js [3] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Å©¾î¾ï123 13-02-22 1050
12,411 ½ºÅ©¸³Æ® ÀÚ¹Ù½ºÅ©¸³Æ® ¹®ÀÚ¿­ ¿¬»êÇÒ ¶§ ÃÖ°í ºü¸¥°Í [2] ¸µÅ© ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Æø½ºÅ׸®¾î 13-02-22 736
12,410 ½ºÅ©¸³Æ® NodeJS ±â¹ÝÀÇ NET ¸ðµâ·Î ±¸ÇöÇÑ À¥ ¼­¹ö [7] ¸µÅ© ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¹®ÇÐû³â 13-02-20 874
12,409 ½ºÅ©¸³Æ® JavaScript Garden, ¾Ë½ö´Þ½öÇÑ ÀÚ½º ¹®¹ýÀ» ±ò²ûÈ÷ [8] ¸µÅ© ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Æø½ºÅ׸®¾î 13-02-20 764
12,408 ½ºÅ©¸³Æ® ¼ø¼ö ÀÚ¹Ù½ºÅ©¸³Æ®·Î ±¸ÇöÇÑ Simple jQuery [10] ¸µÅ© Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¹®ÇÐû³â 13-02-19 1176
12,407 ±âŸ ÇÁ¸®Ã§ °Ô½ÃÆÇ °¡Á®¿À±â ¼Ò½º [2] ÷ºÎÆÄÀÏ Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¾Æ´Ï¿À 13-02-14 1711
12,406 Á¤º¸ À¥ÆùÆ® ¾øÀÌ ¿¹»Û ÇÑ±Û ±Û²Ã »ç¿ëÇϱâ (À̹ÌÁö ÀÚµ¿»ý¼º) [14] ¸µÅ© Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§°õÅÊÀÌǪ 13-02-12 1504
12,405 ±âŸ ¿µ¹® ¿Â¶óÀÎ Çʱâ ÀÎ½Ä [2] ¸µÅ© ÷ºÎÆÄÀÏ ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§wkpark 13-02-09 881
12,404 DBMS mysql bin log º¹±¸ [6] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¼ÛÈ¿Áø 13-02-07 892
12,403 DBMS [mssql] group by + case¿Í where+group byÀÇ ºñ±³ [7] ¸µÅ© ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§º½µ¹#3141 13-02-06 703
12,402 ¾Ë°í¸®Áò ¸ð¹ÙÀϴ亯Çü °Ô½ÃÆÇ ±¸Çö¿ø¸® [29] ÷ºÎÆÄÀÏ Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§°³¹ß»ç¶û 13-02-06 1462
12,401 Á¤º¸ 10¿ø, ÇÑ±Û »ç¿ë¿¡ °üÇÏ¿©.... [6] ÷ºÎÆÄÀÏ ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§·¹¾î´Ð 13-02-06 871
12,400 ¼³Ä¡/¼³Á¤ atime À» ²¨¼­ ¾µµ¥¾ø´Â write ¿äûÀ» ÁÙÀÌÀÚ. [5] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¼ÛÈ¿Áø 13-02-05 693
12,399 Á¤º¸ zen coding 0.7.5 for dreamweaver ´ÜÃàŰ º¯°æ¹öÀü. [2] ¸µÅ© ÷ºÎÆÄÀÏ ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¼ÛÈ¿Áø 13-02-04 639
 
12345678910