Load Data into Table


#1

I tried using the command “sudo mv data1.sql /var/lib/mysql-files” put the .sql file inside of /var/lib/mysql-files, but it doesn’t seem to work. Instead, I got ERROR 1064 (42000): You have an error in your SQL syntax. May I ask you how to address this problem?

Also, the datas, which includes Chinese, aren’t inputted correctly. Is it because they are Chinese characters or for other reasons?

I also tried to run mysql --version to check the version, but it doesn’t work as well. Instead, it shows "ERROR 1064 (42000): You have an error in your SQL syntax. How to upgrade to MySQL 5.7 or 8 on Cloud9?

Thank you for your help!!!