Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re^4: SQLite handling of errors through common function

by techman2006 (Beadle)
on Nov 07, 2013 at 12:39 UTC ( #1061555=note: print w/replies, xml ) Need Help??


in reply to Re^3: SQLite handling of errors through common function
in thread SQLite handling of errors through common function

Thanks I want to mean the DBI handle which is obtained after connect call.

For the second point let me try to explain further with an example. Say we want to create an database called EmpRec which will comprises of a set tables e.g. EmpAdd, EmpSal etc. Now when we try to connect first we need to connect to EmpRec database. Below are the set of queries which is fired in MySql

mysql> CREATE DATABASE EmpRec;

mysql> USE EmpRec Database changed

So is something like above is supported in SQLite and if yes how we can do that

  • Comment on Re^4: SQLite handling of errors through common function

Replies are listed 'Best First'.
Re^5: SQLite handling of errors through common function
by mje (Curate) on Nov 07, 2013 at 14:09 UTC

    SQLite does not support create database. For different databases you use different files i.e. call connect with a different dbname.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1061555]
help
Chatterbox?
[davido]: If you ever doubt the progress made in CPU technology: I have a script that runs in 2m20s on a Core2-Duo with 8GB RAM and an SSD. On an i7-2700K, also with SSD, same script runs in 12.5s.
[davido]: That's a 2nd Gen i7, but it is OC'ed from 3.5GHz to 4.6. ...things break down for awhile following 2nd gen though; the 2nd gen i7 2700k beats my Haswell (4th gen) i7 laptop by about 30%

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (8)
As of 2017-11-22 15:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    In order to be able to say "I know Perl", you must have:













    Results (326 votes). Check out past polls.

    Notices?