SSH Quick Help needed for CSV to MYSQL Command
Budget: $10 – $30 USD
I need ssh command to import data from CSV file to MySQL Database Table.
CSV COLUMN NAMES
('UDPRN','Organisation Name','Department Name','PO Box','Building Name','Sub-Building Name','Building Number','Thoroughfare','Street','Double Dependent Locality','Dependent Locality','Post Town','Postcode','Postcode Type','Delivery Point Suffix','SU Organisation Flag')
Database Table Column Names
('id','UDPRN','Organisation Name','Department Name','PO Box','Building Name','Sub-Building Name','Building Number','Thoroughfare','Street','Double Dependent Locality','Dependent Locality','Post Town','Postcode','Postcode Type','Delivery Point Suffix','SU Organisation Flag')
Database table only have id auto increase column, which csv file doesn't have it
CSV COLUMN NAMES
('UDPRN','Organisation Name','Department Name','PO Box','Building Name','Sub-Building Name','Building Number','Thoroughfare','Street','Double Dependent Locality','Dependent Locality','Post Town','Postcode','Postcode Type','Delivery Point Suffix','SU Organisation Flag')
Database Table Column Names
('id','UDPRN','Organisation Name','Department Name','PO Box','Building Name','Sub-Building Name','Building Number','Thoroughfare','Street','Double Dependent Locality','Dependent Locality','Post Town','Postcode','Postcode Type','Delivery Point Suffix','SU Organisation Flag')
Database table only have id auto increase column, which csv file doesn't have it