- Error Information:
No database Selected
- Forget to pass database name parameter and company name parameter to my sql script
…so much for now~
Edit @5.24
Hooray~I found that I shouldn’t have called stored procedure in “.sql” script using command line like
mysql -u username -p -e"para1=xxx,[para2=xxx]" < script.sql
or similar ways,
see this link http://stackoverflow.com/questions/18240194/how-to-script-out-stored-procedures-to-files
Since stored procedure aren’t “stored” as a separate file but in the database.
I should indicate call procedure explicitly.
Edit @5.24 7:00pm:
Since there is no thing such as a file to save procedure, MySQL provide a method of show create procedure <name>
to use MySQL