#! /usr/bin/perl use warnings; use strict; use DBI; use Data::Dumper; my $dbfile = '1.db'; my $db = 'DBI'->connect("dbi:SQLite:dbname=$dbfile", q(), q()); END { unlink $dbfile } $db->do('CREATE TABLE text (id INT, line_n VARCHAR, word VARCHAR, word_position INT)'); my $insert = $db->prepare('INSERT INTO text VALUES(?, ?, ?, ?)'); { no warnings 'qw'; $insert->execute(@$_) for [qw[1 a1 Lorem 1]], [qw[2 a1 ipsum 2]], [qw[3 a1 dolor 3]], [qw[4 a1 sit 4]], [qw[5 a1 amet, 5]], [qw[6 b2 consectetuer 1]], [qw[7 b2 adipiscing 2]], [qw[8 b2 elit. 3]], [qw[9 c3 Phasellus 1]], [qw[10 c3 non 2]], [qw[11 c3 erat 3]]; } #### my $select = $db->prepare('SELECT line_n, word, word_position FROM text'); $select->execute; my $text; while (my ($line, $word, $pos) = $select->fetchrow_array) { $text->{$line}[$pos - 1] = $word; } print Dumper($text); #### ($q=q:Sq=~/;[c](.)(.)/;chr(-||-|5+lengthSq)`"S|oS2"`map{chr |+ord }map{substrSq`S_+|`|}3E|-|`7**2-3:)=~y+S|`+$1,++print+eval$q,q,a,