Array in double quotes interpolates into its members separated by spaces. That's not the syntax for CREATE TABLE, though: you need the column names separated by commas. Also, if the input is dynamic, there can be a control character in the column name, so you need quoting.
#!/usr/bin/perl
use warnings;
use strict;
use feature qw{ say };
use DBI;
my @columns = qw( author year` day" month; 42 );
my $dbh = DBI->connect('dbi:SQLite::memory:')
or die "Cannot connect: $DBI::errstr";
$dbh->{RaiseError} = 1;
my $column_list = join ', ', map $dbh->quote_identifier($_), @columns;
$dbh->do("CREATE TABLE data ($column_list)");
$dbh->do('INSERT INTO data VALUES(' . join(', ', 1 .. @columns) . ')')
+;
my $sth = $dbh->prepare("SELECT $column_list FROM data");
$sth->execute;
while (my @row = $sth->fetchrow_array) {
say "@row";
}
($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,
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|