in reply to Re^3: Writing NULL values to a MySQL record via DBI
in thread Writing NULL values to a MySQL record via DBI

Just started to search for placeholders and I can see what you are suggesting - thanks. As I understand it (remember I've only read a small amount in the last few minutes) you substitute the ? for the corresponding variable in the statement. In the case above, first ? relates to the $file_obs_datetime_utc and the second ? relates to $file_obs_datetime_local. Does the undef statement above cover all the fields that follow? Just looking to understand fully the code you posted.
  • Comment on Re^4: Writing NULL values to a MySQL record via DBI

Replies are listed 'Best First'.
Re^5: Writing NULL values to a MySQL record via DBI
by Anonymous Monk on Feb 26, 2015 at 22:59 UTC
    Please read the documentation. The undef is very necessary here and refers only to the value for the second argument being passed to the method do. Explaining exactly what that argument is for is difficult, at best. Otherwise you are very very close to understanding how this works.
[reply]
      I might not be getting this fully - I'm trying to go through the cpan documentation for DBI. If you want to insert a NULL value for a particular field you use 'undef' but what if in my case you don't know whether the field will be undefined when you extract if from the CSV file? I need the variable (e.g. '$file_temp_c' from the original code block I included earlier) to be equal to either a value if populated or 'undef' if the CSV file did not have a value. I can test the variable and they do indicate they are undefined but, at least in my original code they do not translate to NULL in the MySQL table - hope this makes sense and is possible.
[reply]
        The first argument is your SQL statement. The second argument is a special thing. Just ignore it and use what i provided until you understand. The remaining arguments are your values you want inserted.

        Finish writing the code i provided and run it and see what happens. Let us know.

[reply]

In Section Seekers of Perl Wisdom