I am running MySQL in the command line and performing SQL saved in files. What I am attempting to do, is prompt the consumer to go in input to ensure that I'm able to include this within the SQL script? It is possible to method of doing this with MySQL?
Thank you, James
If you wish to execute sql script in the file do this:
mysql -u USER -p -D DATABASE < input_filename.sql