海运的博客

UTF-8：

<?php
   function genstr($num)
   {
      for($i=0;$i<=$num;$i++)
      {
         $str .= '&#'.rand(19968, 40869).';';
      }

      return mb_convert_encoding($str, "UTF-8", "HTML-ENTITIES");
   }
   echo genstr(mt_rand(1,8));
?>

GBK：

<?php
   function genstr($num)
   {
      for($i=0;$i<=$num;$i++)
      {
         $str .= chr(rand(0xB0,0xF7)).chr(rand(0xA1,0xFE));
      }

      return $str;
   }
   echo genstr(mt_rand(1,8));
?>

#!/usr/bin/python
# -*- coding: utf-8 -*-  
from time import time
start = time()
stop = time()
print("程序执行时间"+str(stop-start) + "秒")

#!/bin/bash
start=`date +%s`
stop=`date +%s`
echo "程序执行时间$[ stop - start ]秒"

文本多列以,分隔，导入到指定字段：

load data local infile "file.txt" into table db.table FIELDS TERMINATED BY ',' (name,address);
load data local infile "file.txt" into table db.table (name,address) FIELDS TERMINATED BY ',';
update db.table SET aaa = 'test'; 

也可使用PHP以数组的方式逐行插入，自定义方便。

<?php  
   $hostname="localhost";
   $username="root";
   $password="passwd";  
   $dbname="dbname";
   mysql_connect($hostname,$username,$password);
   mysql_select_db("$dbname");
   $mydate=file("/root/m.txt");
   $n=count($mydate);
   for($i=0;$i<$n;$i++){
      $date=explode(",",$mydate[$i]);
      $str="insert into table (name,address) values ('$date[0]','$date[1]')";
      mysql_query($str);
   }
   mysql_close();
   echo "ok!";
?> 

<?php
   function queue() {
      static $queue =  array(a,b,c,d);
      $a = array_shift($queue);
      $queue[] = $a;
      print_r($queue);
      echo $a;
   }
   queue();
   queue();
   queue();
   queue();
?>

其它可用到的函数：

array_unshift() 在数组开头插入元素
array_push() 在数组尾部插入数据
array_pop() 删除数组尾部数据