Okay, once I had your affirmation that it is possible, I have been looking everywhere for the syntax pertaining to omitting column names. Could someone point me in the right direction? TIA
Cheers!
I've come across the need to query my sql database for a single row of records, but is it possible to omit the column names at the same time? If not possible with straight SQL, then maybe with PHP? Thanks.
Cheers!
I made the changes and added the statement handler, no errors, but its still not adding "one" line from the CSV file. The CSV file has only one line, so there is no need for a fast and efficient process. I just want the script to read the line and add it to the already existing table as an...
Not receiving any errors after compiling, but the script isn't reading the CSV file into the MySQL table. Can someone point me in the right direction? Many thanks.
#!/usr/bin/perl -w
use DBI;
use strict;
use warnings;
# Declare varaibles
my $DBNAME = "Test";
my $DBTABLE = "Pandora"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.