test_data/dump
raw| 1 | #!/usr/bin/perl -w |
| 2 | |
| 3 | use DBI; |
| 4 | my $dbh = DBI->connect('dbi:mysql:test') or die $DBI::errstr; |
| 5 | |
| 6 | my $TABLE = shift; |
| 7 | $TABLE = 'ctx_test_1_data' unless defined $TABLE; |
| 8 | |
| 9 | my $sth = $dbh->prepare("select word,idx from $TABLE order by word"); |
| 10 | $sth->execute; |
| 11 | |
| 12 | while (my @data = $sth->fetchrow_array) { |
| 13 | $data[1] = join ' ', unpack 'S*', $data[1]; |
| 14 | print "@data\n"; |
| 15 | } |
| 16 |