I have this on my batch file:
drop database if exists inventory;
create database inventory;
use inventory;
mysql -u root -p inventory < C:\wamp\www\test\inventory.sql
And I already copied all the contents of
C:\wamp\bin\mysql\mysql5.1.36\bin
Into
C:\windows\system32
Just to make sure that it has the file that it needs to run. But when I executed the batch file. It just said that. create and use is not an operable command, it said it does not recognize the command. I also tried setting the path to
C:\wamp\bin\mysql\mysql5.1.36\bin
But still no luck. Please help