I am using MySQL 5.1. As a rookie, here are some basic command I feel useful to remember.
Some basic mysql
...
commands
Use mysql client to access the database.
...
Panel |
---|
mysql> SHOW CREATE VIEW view-name; |
or
Panel |
---|
mysql> select ROUTINE_DEFINITION from information_schema.ROUTINES where ROUTINE_NAME='procedure-name';; |