MySQL LOAD DATA INFILE host lookup -


I have a CSV file with a timestamp and a host IP address on each line.

The table I would like to load this file, along with the host name column is also.

I am trying to load this data using the Load Data InFile. Is there a way that I can see the hostname as it loads in the data table?

In addition to this, as a general question, how can I see the hostname for an IP address given in the stored procedure, for example.

Thank you.

I do not think anyone has a MySQL function to view the hostname for the given IP address before I I suggest loading the data and then PHP, Ruby, Python, or whatever the written script is using, seeing the hostnames and is missing.

Comments