Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cmdlinegeek

    Return query without column names...

    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!
  2. cmdlinegeek

    Return query without column names...

    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!
  3. cmdlinegeek

    Issues Importing CSV file into MySQL database

    MillerH, Much oblige, the code works perfectly. Regards, Robert
  4. cmdlinegeek

    Issues Importing CSV file into MySQL database

    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...
  5. cmdlinegeek

    Issues Importing CSV file into MySQL database

    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"...

Part and Inventory Search

Back
Top