Insert with While Loop in MySQL database table

Question

I'm trying to insert a bunch of records in my MySQL database table.

I am not expert to create a stored procedure.

Here is my code:

BEGIN

 DECLARE var INT; 
 SET var = 0; 
 WHILE var < 100000 DO 
  INSERT INTO stored_copy (total, active, stored) VALUES (var, 1, 1);
  SET var = var + 1; 
 END WHILE; 

END;

Here is the error:

Can anyone check what I am doing wrong?

nbk · Accepted Answer · 2020-04-20 19:41:20Z

1

stored is a reserved word you have to use backticks

see also When to use single quotes, double quotes, and backticks in MySQL

BEGIN

 DECLARE var INT; 
 SET var = 0; 
 WHILE var < 100000 DO 
  INSERT INTO stored_copy (total, active, `stored`) VALUES (var, 1, 1);
  SET var = var + 1; 
 END WHILE; 

END;

answered Apr 20, 2020 at 19:41

nbk

49.6k8 gold badges32 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Chris · Accepted Answer · 2020-04-20 19:53:11Z

1

Update the name of "stored" column in stored_copy table. stored is a reserved word.

answered Apr 20, 2020 at 19:53

Chris

511 gold badge1 silver badge11 bronze badges

Collectives™ on Stack Overflow

Insert with While Loop in MySQL database table

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related