title: Issues while trying to insert into database in PERL using DBD::SQLite module
body: <p>I am new to Databse. I installed SQLite on my system and tried running PERL program to insert into databse</p>
  
  <p>SQLite commands to create database and table</p>
  
  <p>In command prompt, I iterated to SQlite directory and given commands as</p>
  
  <pre><code>sqlite3 one.db;
  create table table1 (a int, b string);
  </code></pre>
  
  <p>It created a database and table</p>
  
  <p>I executed the followed PERL program</p>
  
  <pre><code>use strict;
  
  use warnings;
  use DBI;
  
  use DBD::SQLite;
  
  my $dbh = DBI-&gt;connect("dbi:SQLite:dbname=one.db","","") or die "cannot 
  
  connect";
  
  my $sth = $dbh-&gt;prepare("INSERT INTO 'table1'
                         (Income, LAST_NAME )
                          values
                         ('1000', 'poul')");
  $sth-&gt;execute() or die $DBI::errstr;
  $sth-&gt;finish();
  $dbh-&gt;commit or die $DBI::errstr;
  </code></pre>
  
  <p>I got the following error</p>
  
  <pre><code>DBD::SQLite::st execute failed: no such table: table1 at DBI.txt line 14.
  no such table: table1 at DBI.txt line 14.
  </code></pre>
  
  <p>After getting comments from <code>IKEGAMI</code>, I changed the <code>DBI-&gt;connect</code> as</p>
  
  <pre><code>my $dbh = DBI-&gt;connect
  
  ("dbi:SQLite:dbname=C:/Users/nitkumar/Downloads/sqllite/one.db","","
  
  ") or die "cannot connect";
  </code></pre>
  
  <p>I started getting error message as </p>
  
  <pre><code>DBI connect('dbname=C:/Users/nitkumar/Downloads/sqllite/one.db','',...) failed:
   database disk image is malformed at DBI.txt line 8
  cannot connect at DBI.txt line 8.
  </code></pre>
  
  <p>After getting more comments i got the version by using</p>
  
  <pre><code>use DBD::SQLite;
  warn $DBD::SQLite::VERSION;
  warn $DBD::SQLite::sqlite_version;
  </code></pre>
  
  <p>I got the <code>output</code> as</p>
  
  <pre><code>1.37 at version.txt line 2.
  3.7.12.1 at version.txt line 3.
  </code></pre>
  
  <p>I am using <code>sqlite3</code> . I guess there are no issues with version</p>