Hi, I've been following a tutorial on mysql. In one part it explains how to import a query (in a .dat file) from the command line:
1). Move the file to c:\mysql\bin.
2). Make sure MySQL is running.
3). Issue the following command
mysql employees <employee.dat
employee.dat just contains queries like this:
But it doesn't seem to work when I issue the command in step 3). I just get an error 1064.
INSERT INTO employee_data (f_name, l_name, title, age, yos, salary, perks, email) values ("John", "Hagan", "Senior Programmer", 32, 4, 120000, 25000, "firstname.lastname@example.org");
I've read that error 1064 is the result of mysql version mismatch. How do I find out the mysql version from the command line?
Is there a different/better way to get that info into my tables?