Regarding Store Procedures
Hi All, I am new to MySQL, can any body tell me how to write store procedures in MySQL. and How to run the same in command line. This will help me very much. Thanks in Advance. Pradeepp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Regarding Store Procedures
I am new to MySQL, can any body tell me how to write store procedures in MySQL. MySQL doesn't support stored procedures yet. and How to run the same in command line. This will help me very much. But you can create text fle with SQL commands and then run it from command line: mysql -h host -u user -ppassword your_file_with_SQL_commands Mikhail. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Regarding Store Procedures
There are no sprocs in MySQL at this time. There are plans for such, but it will be at least a 4.x (post 4.0) release. There are some 3rd party things out there to allow you to run inline Perl and stuff like that, but they are true add ons and are not an exact match to a stored procedure concept IMHO. -Original Message- From: Pradeep.C.Pangi [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 4:17 AM To: [EMAIL PROTECTED] Subject: Regarding Store Procedures Hi All, I am new to MySQL, can any body tell me how to write store procedures in MySQL. and How to run the same in command line. This will help me very much. Thanks in Advance. Pradeepp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Regarding Store Procedures
Mysql does not currently support stored procedures. Check the website for the features that will be added to the 4.x seriese. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Pradeep.C.Pangi [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 6:17 AM To: [EMAIL PROTECTED] Subject: Regarding Store Procedures Hi All, I am new to MySQL, can any body tell me how to write store procedures in MySQL. and How to run the same in command line. This will help me very much. Thanks in Advance. Pradeepp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Regarding Store Procedures
Hello. On Wed 2002-06-26 at 16:47:05 +0530, [EMAIL PROTECTED] wrote: Hi All, I am new to MySQL, can any body tell me how to write store procedures in MySQL. and How to run the same in command line. This will help me very much. More of help would be a look in the manual, which would have told you that MySQL does not support stored procedures at all (at least for now). Bye, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Regarding Store Procedures
There are no stored procedures in mySQL Andrei Cojocaru [EMAIL PROTECTED] - Original Message - From: Pradeep.C.Pangi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 05:17 Subject: Regarding Store Procedures Hi All, I am new to MySQL, can any body tell me how to write store procedures in MySQL. and How to run the same in command line. This will help me very much. Thanks in Advance. Pradeepp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Regarding Store Procedures
MySQL doesn't support stored procedures. They are on TODO and should appear in MySQL-5.0. Pradeep.C.Pangi wrote: Hi All, I am new to MySQL, can any body tell me how to write store procedures in MySQL. and How to run the same in command line. This will help me very much. -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Regarding Store Procedures
[snip] I am new to MySQL, can any body tell me how to write store procedures in MySQL. and How to run the same in command line. This will help me very much. [/snip] http://www.mysql.com/doc/T/O/TODO_sometime.html MySQL does not currently support stored procedures Jay sql, mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php