或者用load data infile "c:\mytable.txt" into table pet;
如果里面的字段不是按照默认的分隔,还要用到下面的选项fields-terminate-by,lines-terminate-by,fields-enclosed-by等。
如果里面的字段不是按照默认的分隔,还要用到下面的选项fields-terminate-by,lines-terminate-by,fields-enclosed-by等。
$file_name = "/data/msg_bak/$db_id/".$table_name."_".get_day_before().".txt";
$sql = "select * into outfile '$file_name' from $table_name";