手把手教你mysql十四存储过程.DOCVIP

手把手教你mysql(十四)存储过程 一: 前言 CREATE DATABASE IF NOT EXISTS `db_book2` DEFAULT CHARACTER SET GBK; USE `db_book2`; DROP TABLE IF EXISTS `t_book`; CREATE TABLE `t_book` ( `id` INT(11) PRIMARY KEY AUTO_INCREMENT, `bookName` VARCHAR(20) DEFAULT NULL, `price` DECIMAL(6,2) DEFAULT NULL, `author` VARCHAR(20) DEFAULT NULL, `bookTypeId` INT(11) DEFAULT NULL ) ENGINE=INNODB DEFAULT CHARSET=GBK; INSERT INTO `t_book` VALUES (NULL,Java编程思想,100.00,埃史尔,1),(NULL,Struts2权威指南,80.00,李刚,1),(NULL,三剑客,70.00,大仲马,2),(NULL,生理学(第二版),24.00,刘先国,3); DROP TABLE IF EXISTS `t_booktype`; CREATE TABLE `t_booktype` (