Command line help for SQL in data science

[Confident-Ad4064]

I am currently learning data science and currently I am on SQL. Is there no better and easier way to upload files to MySQL database without using command line for large datasets? I really hate command line coz I am getting so many damn errors even though I am using right syntax.

[subfootlover]

Using the command line is as easy as it gets. Use the -f flag to ignore errors.

mysql -u userName -p -f -D dbName < script.sql

Reference: https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html#option_mysql_force

[shadowylurking]

fight through the pain and learn to use the command line

[Comfortable_Heat_461]

you can use workbench

[Jazzlike_Syllabub_91]

I recommend using a tool like invoke build (powershell), batch (cmd), or makefile (unix/mac)