摘要:
获取 数据库 和 表信息:mysql> connect;mysql> show databases;mysql> show tables;mysql> show tables from db_name;mysql> show columns from tbl_name;mysql> show index from tbl_name;mysql> show ... 阅读全文
摘要:
MySQL 版本:5.0.45 phpMyAdmin版本:2.11.3首先看MySQL 5.0参考手册中关于创建存储过程的语法说明:CREATE [DEFINER = { user | CURRENT_USER }] PROCEDURE sp_name ([proc_parameter[,...]]) [characteristic ...] routine_body proc_parameter... 阅读全文