hey guys,, im newbie to stored procedure,,im using the localhost server now,I would like to ask if where to put the stored procedure in my phpmyadmin?Is it from information schema?or in the tables?
jay_412
0
Newbie Poster
Recommended Answers
Jump to PostIf you mean you want to store data in mysql/phpmyadmin then you will need to first open phpmyadmin. Then create a new database. In that new database create a new table. Then bingo php should be able to write into that table.
Jump to PostYou don't need to "put" your stored procedure somewhere, you create one by executing a
CREATE PROCEDURE
statement. As cwarn23 mentioned, you will need a database with tables etc for your procedure to be able to do anything.
Jump to PostTake a look at this tutorial :
http://www.brainbell.com/tutorials/MySQL/Using_Stored_Procedures.htm
Jump to PostI'm sorry jay_412 but I don't understand what you are asking. You simply need to run the mysql create procedure query. This can be done in php, or on the command line in Windows, or the shell in Linux, or in a MySQL editor such as SQLyog.
All 15 Replies
cwarn23
387
Occupation: Genius
Team Colleague
Featured Poster
jay_412
0
Newbie Poster
darkagn
315
Veteran Poster
Featured Poster
jay_412
0
Newbie Poster
darkagn
315
Veteran Poster
Featured Poster
jay_412
0
Newbie Poster
darkagn
315
Veteran Poster
Featured Poster
jay_412
0
Newbie Poster
cwarn23
387
Occupation: Genius
Team Colleague
Featured Poster
jay_412
0
Newbie Poster
cwarn23
387
Occupation: Genius
Team Colleague
Featured Poster
jay_412
0
Newbie Poster
cwarn23
387
Occupation: Genius
Team Colleague
Featured Poster
jay_412
0
Newbie Poster
darkagn
315
Veteran Poster
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.