MySQL stored procedures

DROP PROCEDURE IF EXISTS schema_change; --If this stored procedure is present, delete
DELIMITER//--delimiter,//For Start, touch next//End
CREATE PROCEDURE Schema_change ()--Define stored procedure name
BEGIN
IF EXISTS (SELECT * FROM information_schema.columns WHERE table_name = ' busi_finance_details ' and column_name = ' Order_typ E ') then--Determine if the column name exists
--Financial Table modification Order_type field remarks--2017-6-20
ALTER TABLE ' busi_finance_details '
MODIFY COLUMN ' order_type ' tinyint (2) not NULL DEFAULT 0 COMMENT ' number Type 1 repair order 2 Purchase Order 3 return order 4 refill 5 Purchase Card 6 Car wash single 7 beauty single 8 Care order 90 Sell Order 10 Inventory single ' after ' Order_no ';
END IF;
end//--End

DELIMITER;
Call Schema_change (); --Call the stored procedure

MySQL stored procedures