Help for this page

Select Code to Download


  1. or download this
    SQL - trace SQL statements executed
          (not yet implemented in DBI but implemented in some DBDs)
    
  2. or download this
    $ sqlite3 pm_11137916_anon
    SQLite version 3.34.0 2020-12-01 16:14:00
    ...
    5|Jupiter|gas
    9|Pluto|dwarf
    sqlite>
    
  3. or download this
    #!/usr/bin/env perl
    
    ...
    my $dbh = DBI->connect('dbi:SQLite:dbname=pm_11137916_anon');
    
    print join('|', @$_), "\n" for $dbh->selectall_array('select * from Pl
    +anet');
    
  4. or download this
    $ ./trace_none.pl
    3|Earth|rock
    5|Jupiter|gas
    9|Pluto|dwarf
    
  5. or download this
    $ ls -al *.out
    -rw-r--r-- 1 ken None  1839 Oct 24 03:50 trace_dbi_1.out
    ...
    -rw-r--r-- 1 ken None  6570 Oct 24 03:45 trace_dbi_4_sql.out
    -rw-r--r-- 1 ken None 10574 Oct 24 04:02 trace_dbi_5.out
    -rw-r--r-- 1 ken None 10632 Oct 24 04:03 trace_dbi_5_sql.out