I import a spreadsheet (csv) into my sqli database (keeps a track of all our firewalls) there are 10 excel columns , one for each connected network on the firewall. i would like all these columns to be imported as one entry in the database, so 1 database field would contain all 10 networks. Dont want to do this manually as there are over 500 firewall devices!
could anyone suggest a way to do this?
Jump to PostHow are you importing at the moment?
How are you importing at the moment?
importing a csv straight into phpmyadmin (Im using WAMP server in my testing)
Not sure if phpMyAdmin supports that. You can probably do it if you write your own LOAD DATA INFILE query:
Ill take a look, thank you
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.