Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

DBI: interpreting column_info()

by ibm1620 (Hermit)
on Feb 17, 2013 at 06:43 UTC ( [id://1019110]=perlquestion: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    # Get all columns for each table of interest
    #
    ...
        my @list = map $_ // 'undef', @$aref;
        say join '|', @list;
    }
    
  2. or download this
    dw_contact_source
    undef|dwcust1|dw_contact_source|contact_id|4|BIGINT|20|undef|undef|10|
    +0|undef|undef|4|undef|undef|1|NO|undef|undef|undef|undef|undef|undef|
    +undef|undef|undef|undef|undef|undef|undef|undef|undef|undef|undef|und
    +ef|1|bigint(20)|undef|0
    ...
    undef|dwcust1|dw_contact_source|contact_type_id|4|TINYINT|4|undef|unde
    +f|10|0|undef|undef|4|undef|undef|3|NO|undef|undef|undef|undef|undef|u
    +ndef|undef|undef|undef|undef|undef|undef|undef|undef|undef|undef|unde
    +f|undef||tinyint(4)|undef|0
    undef|dwcust1|dw_contact_source|insert_date|11|DATETIME|19|undef|0|und
    +ef|0|undef|undef|9|-79|undef|4|NO|undef|undef|undef|undef|undef|undef
    +|undef|undef|undef|undef|undef|undef|undef|undef|undef|undef|undef|un
    +def||datetime|undef|0
    undef|dwcust1|dw_contact_source|update_date|11|DATETIME|19|undef|0|und
    +ef|0|undef|undef|9|-79|undef|5|NO|undef|undef|undef|undef|undef|undef
    +|undef|undef|undef|undef|undef|undef|undef|undef|undef|undef|undef|un
    +def||datetime|undef|0
    

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://1019110]
Front-paged by Corion
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others chilling in the Monastery: (4)
As of 2024-03-19 03:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found