MySQL存储过程

为什么80%的码农都做不了架构师？>>>   

预制语句的SQL语法： PREPARE stmt_name FROM preparable_stmt; EXECUTE stmt_name [USING @var_name [, @var_name] ...]; {DEALLOCATE | DROP} PREPARE stmt_name;

mysql存储过程之勾股定理 mysql> PREPARE stmt1 FROM 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse'; mysql> SET @a = 3; mysql> SET @b = 4; mysql> EXECUTE stmt1 USING @a, @b; +------------+ | hypotenuse | +------------+ | 5 | +------------+ mysql> DEALLOCATE PREPARE stmt1;

sql代码： SET @xx="name,bm"; SET @sql = CONCAT('select ',@xx,' from people'); prepare s1 from @sql; execute s1; deallocate prepare s1;

转载于:https://my.oschina.net/lfxu/blog/476814