My server OS is Red Hat 6 with MySQL. I'm using this line in a
.sh file to run some jobs on the server:
mysql -u root -p[password] databasename < MySQL_JOBS_SENTENCES.txt
The content of the
.txt file is:
call procedure1(date(now())); call procedure2(date(now())); call procedure3(current_Date());
Can I create or load a new stored procedure from a
.txt file into my database the same way?