upload csv to mysql selected columns only - laravel
Want to upload CSV file into MySQL Database, upload only selected columns other will be blank when the upload has an option to select the column or field want to upload and upload only selected, how can I do that anybody has any solution
I know PHPMyAdmin, for example, has a feature where you can upload a CSV file into a table. However, I'm not sure if you can pick certain columns.
If you really need to pick custom columns, it might be better to build this yourself as well. So you build an upload form that shows which columns are present and based on the selected columns you create an insert query for the data. You can easily do this with Laravel as well ;)
