Hi, tables looks like this... 
+----------------------------+-----------------------+------+-----+---
+------+----------------+
| Field                      | Type                  | Null | Key | De
+fault | Extra          |
+----------------------------+-----------------------+------+-----+---
+------+----------------+
| met_office_id              | int(11)               | NO   | PRI | NU
+LL    | auto_increment |
| observation_datetime_utc   | datetime              | NO   |     | NU
+LL    |                |
| observation_datetime_local | datetime              | NO   |     | NU
+LL    |                |
| observation_datetime       | datetime              | NO   |     | NU
+LL    |                |
| station_id                 | char(4)               | NO   | MUL | NU
+LL    |                |
| station_name               | char(25)              | YES  |     | NU
+LL    |                |
| temp_c                     | decimal(4,2)          | YES  |     | NU
+LL    |                |
| dewpoint_c                 | decimal(4,2)          | YES  |     | NU
+LL    |                |
| humidity_rh                | decimal(5,2) unsigned | YES  |     | NU
+LL    |                |
| wind_dir_compass           | char(3)               | YES  |     | NU
+LL    |                |
| wind_speed_mph             | decimal(5,2) unsigned | YES  |     | NU
+LL    |                |
| wind_gust_mph              | decimal(5,2) unsigned | YES  |     | NU
+LL    |                |
| visibility_metres          | mediumint(8) unsigned | YES  |     | NU
+LL    |                |
| pressure_hpa               | decimal(6,2) unsigned | YES  |     | NU
+LL    |                |
| pressure_tendency          | char(1)               | YES  |     | NU
+LL    |                |
| weather_type               | char(2)               | YES  |     | NU
+LL    |                |
+----------------------------+-----------------------+------+-----+---
+------+----------------+

[download]
Fields setup to default to NULL (at least I think so)

In reply to Re^2: Writing NULL values to a MySQL record via DBI by ureco
in thread Writing NULL values to a MySQL record via DBI by ureco

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.