Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re^3: SQLite handling of errors through common function

by mje (Deacon)
on Nov 07, 2013 at 11:04 UTC ( #1061547=note: print w/ replies, xml ) Need Help??


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

I presume you really mean is the DBI handle I obtained from connect still actively connected to my database. If that is the case see the DBI ping method. As for the second part of your post I've no idea what you are asking. Of course you can create tables in a database.


Comment on Re^3: SQLite handling of errors through common function
Re^4: SQLite handling of errors through common function
by techman2006 (Sexton) on Nov 07, 2013 at 12:39 UTC

    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

      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://1061547]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (15)
As of 2014-08-22 18:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (163 votes), past polls