Errors while importing CSV to database
I am trying to import a very large file (CSV) to my database in mySQL (I am using Dbeaver btw) and everytime I import it finds a new error. An example of such errors is ‘X has no default value’ etc… So I need to arrest the importing (which takes A LOT of time), re-correct the code for the table creation and re-start the import. Every time I restart I also have to manually map almost all the columns from the CSV to the Dataset in Dbeaver.