mysql5.x函数和存储过程
CREATE TABLE IF NOT EXIST Osob(O_Id int NOT NULL,OrderNo int NOT NULL,P_Id int,PRIMARY KEY (P_Id));CREATE TABLE uzytkownicy2(O_Id int NOT NULL,OrderNo int NOT NULL,P_Id int,PRIMARY KEY (O_Id),FOREIGN KEY (P_Id) References Osob(P_Id));-----------------------------------INSERT INTO `osob`(`O_Id`, `OrderNo`, `P_Id`) VALUES (1,2,3)INSERT INTO `uzytkownicy2`(`O_Id`, `OrderNo`, `P_Id`) VALUES (1,2,3)-----------------------------------DELIMITER $$CREATE PROCEDURE wam2(OUT param1 INT)BEGINSELECT COUNT(*) INTO param1 FROM trenowanie_mysql.osob;END$$DELIMITER ;------------------------------------CALL wam2(@a);
?
?
?
