Calling mysql stored procedure from mysql command line in phpmyadmin

Question

i want to execute a mysql stored procedure from mysql command prompt in phpmyadmin.stored procedure is written in a file sample.sql. contents of sample.sql is:

DELIMITER //
create procedure sampleproc()
begin
declare x int;
set x=1;
while x<=1000 do
insert into dictionary (word,mean) values('a','a mean');
set x=x+1;
end while

end //

call sampleproc();

How can i run this using command line?

Venu · Accepted Answer · 2012-05-15 07:00:46Z

2

Using PHPMYADMIN

To create a stored procedure, you can use the following :

 DELIMITER //
    create procedure sampleproc()
    begin
    declare x int;
    set x=1;
    while x<=1000 do
    insert into dictionary (word,mean) values('a','a mean');
    set x=x+1;
    end while
    end//

And make sure you set the "Delimiter" field on the SQL tab to //.

Using Command Line

mysql --user=user_name --password=your_password db_name < sample.sql

edited May 15, 2012 at 7:00

answered May 15, 2012 at 5:46

Venu

7,2894 gold badges42 silver badges55 bronze badges

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

7 Comments

Venu Over a year ago

mysql --user=user_name --password=your_password db_name < sample.sql execute this command from windows/linux shell not from mysql command line

Gopesh Over a year ago

i have run it but error occurs like C:\>mysql --user=root --password=" " test < d:/sample.sql 'mysql' is not recognized as an internal or external command, operable program or batch file.

Venu Over a year ago

make sure mysql command is executable one. set the mysql path in environment variables or use abosulte path to mysql like c:\>F:\wamp\bin\mysql\mysql5.5.20\bin\mysql --user=root --password=" " test < d:/sample.sql

Gopesh Over a year ago

i didn't make it to work..i have set the path correct to /bin..and add the command..it shos that u have an error in sql syntax

Venu Over a year ago

try to remove this line "call sampleproc();" from sql file

|

Collectives™ on Stack Overflow

Calling mysql stored procedure from mysql command line in phpmyadmin

1 Answer 1

Using PHPMYADMIN

Using Command Line

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Using PHPMYADMIN

Using Command Line

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related