Debian Codegraph @

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