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

SyntaxHighlight·Î º¸±â

Link1 http://www.tested.co.kr/exper/code/31 (169)
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,489°Ç RSS
¹øÈ£ºÐ·ùÁ¦¸ñ±Û¾´À̳¯Â¥Á¶È¸
12,489 Á¤º¸ Codeigniter±â¹Ý ÅÊÅ©V CMS ÀÔ´Ï´Ù. [8] ¸µÅ© ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§²Ù¼õ2 13-06-18 321
12,488 ½ºÅ©¸³Æ® JavaScript Tips (5) - ¸Þ¼Òµå ÈÄÅ· ±¸ÇöÇϱ⠸µÅ© ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¹®ÇÐû³â 13-06-17 240
12,487 ºê¶ó¿ìÀú ÁÖÀÇ]mobile webkit cookie ¿¡ ´ëÇÏ¿©. safari, chrome form act¡¦ [7] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¼ÛÈ¿Áø 13-06-15 282
12,486 ½ºÅ©¸³Æ® js ¿¡¼­ window, document, parent, contentWindow µîµîÀÇ ¼Ó¼º ¡¦ [2] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¼ÛÈ¿Áø 13-06-06 533
12,485 ½ºÅ©¸³Æ® iframe ÀÇ ºÎ¸ðű׿¡ Á¢±ÙÇϱâ. [4] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¼ÛÈ¿Áø 13-06-05 559
12,484 ±âŸ layoutit ¸¸µå½Ç¶§ À¯¿ëÇÑ ÅøÀÔ´Ï´Ù. ¿¡µðÅͰ¡ »ç¶óÁúÁöµµ --;; [4] ¸µÅ© ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Æø½ºÅ׸®¾î 13-06-04 743
12,483 ÇÔ¼ö explode 3¹øÂ° ÀÎÀÚ. a=b=c=d ==> "a" => "b=c=d" [13] ¸µÅ© ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¼ÛÈ¿Áø 13-05-27 751
12,482 Á¤º¸ 1¿ø) scss »ç¿ë Áß... [2] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§·¹¾î´Ð 13-05-24 748
12,481 DBMS mysql ¿¡¼­ÀÇ in °ú Á¶ÀÎÀÇ ¼±ÅÃÀ» À§ÇÑ Å×½ºÆ® [19] À̹ÌÁö ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§ÀüÁøÇϴ¾Ƹ£°í 13-05-22 848
12,480 ºê¶ó¿ìÀú css browser selector js to css_browser_selector.class.php [5] ¸µÅ© ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¼ÛÈ¿Áø 13-05-21 528
12,479 ºê¶ó¿ìÀú IE9 ÀÌÇÏ jquery placeholder 0.3 [4] ¸µÅ© ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¼ÛÈ¿Áø 13-05-20 636
12,478 ÇÔ¼ö redis_cache (±×´©º¸µå ÇÔ¼öij½¬. redis ¹öÁ¯) ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¾ÆºüºÒ´ç 13-05-20 470
12,477 ¼³Ä¡/¼³Á¤ redis ¼³Ä¡ [1] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¾ÆºüºÒ´ç 13-05-20 551
12,476 ¾Ë°í¸®Áò [1¿øÆÁ] php µ¿ÀûÀÎ »ó¼Ó [6] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§RGB255 13-05-18 761
12,475 ½ºÅ©¸³Æ® js ÇÔ¼ö,¸Þ¼Òµå ¸í¼¼, Ç¥ÁØÀÎÁö MSIE Áö¿ø µÇ´ÂÁö... [5] ¸µÅ© ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¼ÛÈ¿Áø 13-05-15 585
12,474 DBMS Ãʺ¸ÀÚ¸¦ À§ÇÑ mysql¿¡¼­ÀÇ ºñÆ®¿¬»ê Ȱ¿ë [4] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§ÀüÁøÇϴ¾Ƹ£°í 13-05-13 777
12,473 ¾Ë°í¸®Áò ÆäÀ̽ººÏÀÌ ¸¸µç PHP °¡»ó¸Ó½ÅÀÎ HipHop For PHP ¸¦ ¼Ò°³ÇÕ´Ï´Ù. [7] ¸µÅ© Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§egoing 13-05-13 1005
12,472 ºê¶ó¿ìÀú google chrome high contrast plugin »çÀÌÆ® °í´ëºñÈ­ µµ±¸ [3] ¸µÅ© ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¼ÛÈ¿Áø 13-05-12 494
12,471 ¾Ë°í¸®Áò Codeigniter 2.1.3 ±â¹Ý °ø°³º¸µå [2] ¸µÅ© ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¸¶³Ä 13-05-11 825
12,470 ±âŸ Äڵ尡 ¼Õ¿¡ ¾È ÀÍÀ¸½Å´Ù±¸¿ä.. ÀÌ°Í Çѹø ÇØ º¸½ÉÀÌ. [4] ¸µÅ© Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Æø½ºÅ׸®¾î 13-05-09 1143
 
12345678910