根据网上例子,自己修改后,如下:
CREATE TABLE `ccs_customer` (
`customer_code` varchar(20) COLLATE utf8_bin NOT NULL,
`customer_name` varchar(20) COLLATE utf8_bin DEFAULT NULL,
`is_billing` int(11) DEFAULT NULL,
`customer_tel` varchar(30) COLLATE utf8_bin DEFAULT NULL,
`customer_mobile` varchar(15) COLLATE utf8_bin DEFAULT NULL,
`customer_type` int(11) DEFAULT NULL,
UNIQUE KEY `UK_CUSTOMERCODE` (`customer_code`)
)
CREATE TABLE `test1` (
`cust_code` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
`cust_name` varchar(45) COLLATE utf8_bin NOT NULL
)
存储过程:
delimiter //
drop procedure if exists new_procedure;
CREATE PROCEDURE `ccs5_test`.`new_procedure` ()
BEGIN
DECLARE