mysql存储过程

最新推荐文章于 2024-04-15 10:15:00 发布

原创最新推荐文章于 2024-04-15 10:15:00 发布 · 98 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了一个用于向名为TitanicTEMP的数据库表中批量插入数据的过程。该过程通过定义一个存储过程实现，每次循环插入五条记录，涉及乘客的多个属性，如性别、船票等级等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

DELIMITER ;; 
CREATE PROCEDURE testjk4() 
BEGIN 

DECLARE i INT DEFAULT 1;

WHILE i<100000 
DO 
INSERT INTO `TitanicTEMP` (`SibSp`, `Pclass_1`, `Sex_male`, `Pclass_3`, `Embarked_S`, `Fare_scaled`, `Age_scaled`, `Sex_female`, `Pclass_2`, `Cabin_No`, `Embarked_C`, `Survived`, `Embarked_Q`, `Cabin_Yes`, `Parch`) VALUES('1','0','1','1','1','-0.502445171436','-0.56136323207','0','0','1','0','0','0','0','0');
INSERT INTO `TitanicTEMP` (`SibSp`, `Pclass_1`, `Sex_male`, `Pclass_3`, `Embarked_S`, `Fare_scaled`, `Age_scaled`, `Sex_female`, `Pclass_2`, `Cabin_No`, `Embarked_C`, `Survived`, `Embarked_Q`, `Cabin_Yes`, `Parch`) VALUES('1','1','0','0','0','0.786845293588','0.613181832266','1','0','0','1','1','0','1','0');
INSERT INTO `TitanicTEMP` (`SibSp`, `Pclass_1`, `Sex_male`, `Pclass_3`, `Embarked_S`, `Fare_scaled`, `Age_scaled`, `Sex_female`, `Pclass_2`, `Cabin_No`, `Embarked_C`, `Survived`, `Embarked_Q`, `Cabin_Yes`, `Parch`) VALUES('0','0','0','1','1','-0.488854257585','-0.267726965986','1','0','1','0','1','0','0','0');
INSERT INTO `TitanicTEMP` (`SibSp`, `Pclass_1`, `Sex_male`, `Pclass_3`, `Embarked_S`, `Fare_scaled`, `Age_scaled`, `Sex_female`, `Pclass_2`, `Cabin_No`, `Embarked_C`, `Survived`, `Embarked_Q`, `Cabin_Yes`, `Parch`) VALUES('1','1','0','0','1','0.420730236069','0.392954632703','1','0','0','0','1','0','1','0');
INSERT INTO `TitanicTEMP` (`SibSp`, `Pclass_1`, `Sex_male`, `Pclass_3`, `Embarked_S`, `Fare_scaled`, `Age_scaled`, `Sex_female`, `Pclass_2`, `Cabin_No`, `Embarked_C`, `Survived`, `Embarked_Q`, `Cabin_Yes`, `Parch`) VALUES('0','0','1','1','1','-0.486337421687','0.392954632703','0','0','1','0','0','0','0','0');
INSERT INTO `TitanicTEMP` (`SibSp`, `Pclass_1`, `Sex_male`, `Pclass_3`, `Embarked_S`, `Fare_scaled`, `Age_scaled`, `Sex_female`, `Pclass_2`, `Cabin_No`, `Embarked_C`, `Survived`, `Embarked_Q`, `Cabin_Yes`, `Parch`) VALUES('0','0','1','1','0','-0.478116428909','-0.427101530014','0','0','1','0','0','1','0','0');

SET i=i+1; 
END WHILE ; 
COMMIT; 

END;; 

CALL testjk4();