CODEWITHSUNDEEP
mysqlstored-proceduresphpmyadmin
Bharanikumar
Bharanikumar

Reputation: 25733

How do I write an SP in phpMyAdmin (MySQL)?

How do I write a stored procedure in phpMyAdmin?

Upvotes: 3

Views: 6208

Answers (2)

Daniel Vassallo
Daniel Vassallo

Reputation: 344351

In phpMyAdmin you can create the stored procedure in the SQL window.

You may have to set the delimieter to something like "$$" instead of the default ";". You can change this from the bottom of the SQL window.

Stored Procedure in phpMyAdmin

Upvotes: 5

Barrie Reader
Barrie Reader

Reputation: 10713

Copied from the internets:

The answer is yes and no. Phpmyadmin has no tools for creating stored procedures but you can enter in SQL using it and in that way create them.

(Note I don't believe versions prior to MySQL 5 supported stored procedures.)

Upvotes: 1

Related Questions