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';; |