Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Stored Procedures | Forum profile

Forum profile page for Stored Procedures on http://www.mysql.com. This report page is the aggregated overview from a single forum: Stored Procedures, located on the Message Board at http://www.mysql.com. This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional forum profile information for "Stored Procedures" on the Message Board at http://www.mysql.com is also shown in the following ways:

1) Latest Active Threads
2) Hot Threads for Last Week

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.

Site: MySQL AB - MySQL Forums - Stored Procedures (site profile, domain info mysql.com)
Title: Stored Procedures
Url: http://forums.mysql.com/list.php?98
Users activity: 2 posts per thread
Forum activity: 23 active threads during last week
 

Posting activity on Stored Procedures:

  Week Month 3 Months
Threads: 23 74 209
Post: 47 173 422
 

Stored Procedures Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
Peter Brawley
10
user's latest post:
Re: sqlcode in mysql?
Published (2009-11-28 15:03:00)
Again, read about mysql_error() in the PHP manual. Google for PHP/MySQL examples.
Devart Team
5
user's latest post:
Re: Sync one table between two...
Published (2009-11-27 02:29:00)
Dan, let me advice you to use Schema / Data Comparison tools in dbForge Studio for MySQL. Tools allows to compare and synchronize you databases, their objects and data. Find more information here: http://www.devart.com/dbforge/mysql/studio/ Devart Company, Database development tools http://www.devart.com/dbforge .
sy l
4
user's latest post:
Re: sqlcode in mysql?
Published (2009-11-28 12:39:00)
this might not get what i need... is mysql have something like sqlcode in oracle? it can check the current execute sql statement whether return any error..... i might really need this to ensure all my sql statement execute successfully!
Mohamed Mahir
3
user's latest post:
Re: Stored Procedure Out Parameter
Published (2009-11-19 08:19:00)
Yes. its working sorry i had query with where clause and some of the rows may not have value. select imagelink into imagelinkValue from items where imagelink is not null order by dt desc limit 1; //no output but it should be select imagelink into imagelinkValue from items where imagelink !='' order by dt desc limit 1; this works thanks for your fast reply Mohamed mahir
George Schmidt
3
user's latest post:
Re: syntax error I can't...
Published (2009-11-27 21:46:00)
The only thing that comes to mind is the problem with the delimiter. http://dev.mysql.com/doc/refman/5.1/en/stored-programs-defining.html
Keith Hicks
3
user's latest post:
Re: syntax error I can't...
Published (2009-11-27 17:37:00)
Yeah, I caught that just after I posted the problem and then it still didn't work so I edited my post without the bad commas but must have done that after you replied. Sorry about that. In any event, I have a feeling it's some sort of permissions issue. I don't have total control over this database. I couldn't even create a very simple proc. So I wrote a note to the admins to see what's up. Will post update here when I...
vyjayanth uttanoor
2
user's latest post:
Re: SELECT records with comma...
Published (2009-11-23 14:16:00)
The case here is when a perticular person is logged in with name aaa he can only view the details of people with id 49,50 so I need to build a php where I could select any one of them Edited 1 time(s). Last edit at 11/23/2009 02:18PM by vyjayanth uttanoor.
Jeremy Rottman
2
user's latest post:
Re: Little Proc Help
Published (2009-11-26 01:43:00)
I got this figured out. I had my syntax wrong. It should have been. SELECT Transaction_Main.FileNumber,, LK_Transaction_Types.TransactionPrefix, LK_Transaction_Types.TransactionDate INTO d_FileSuffix, d_FilePrefix, d_FileDate
Rick James
2
user's latest post:
Re: How to compare performance...
Published (2009-11-27 18:51:00)
There are many caches. When you say that it is slow the "first" time -- do you mean right after bringing up MySQL? At that point, everything is on disk. ANY query will be slow because of reading index blocks, schemas, data blocks, etc. from disk. If you rerun the same query again, the disk I/O is probably skipped. Furthermore, as Paul points out, you may have the "Query cache" turned on. It will, in limited...
Jasmin Yu
1
user's latest post:
Benchmarking Stored procedure ?
Published (2009-11-20 06:53:00)
 

Latest active threads on Stored Procedures::

MySQL AB - MySQL Forums
Started 1 week, 4 days ago (2009-11-18 05:36:00)  by Devart Team
>i want to make a query to check whether current record exist, if exists update, else insert. What about using REPLACE statement? http://dev.mysql.com/doc/refman/5.1/en/replace.htm l Devart Company, Database development tools http://www.devart.com/dbforge .
Thread:  Show this thread (10 posts)   Thread info: Re: sqlcode in mysql? Size: 470 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: sqlcode in mysql? :: Stored Procedures :: MySQL AB - MySQL Forums"
MySQL AB - MySQL Forums
Started 1 day, 17 hours ago (2009-11-28 11:58:00)  by Peter Brawley
IF you mean Sybase ISQL, I think it doesn't talk to MySQL. Or do you mean http://isql.sourceforge.net/ ? If the sproc runs in the mysql client, it would seem you've hit a limitation in PowerBuilder. PB http://www.artfulsoftware.com Edited 1 time(s). Last edit at 11/28/2009 12:01PM by Peter Brawley.
Thread:  Show this thread (2 posts)   Thread info: Re: The database does not currently support retrieval of procedure text. Size: 492 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: The database does not currently support retrieval of procedure text. :: Stored Procedures :: MySQL AB - MySQL Forums"
MySQL AB - MySQL Forums
Started 2 days, 14 hours ago (2009-11-27 14:52:00)  by George Schmidt
Hi Keith, Try to replace ', = ' by ' = '
Thread:  Show this thread (5 posts)   Thread info: Re: syntax error I can't figure out Size: 57 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: syntax error I can't figure out :: Stored Procedures :: MySQL AB - MySQL Forums"
MySQL AB - MySQL Forums
Started 3 days, 10 hours ago (2009-11-26 18:42:00)  by Paul Svirin
"Code caches are used to primarily lessen the impact of "hard parse" activity where, after SQL and stored code statements are initially executed and checked both syntactically and for security, the sometimes costly process of generating access plans is performed." ( http://dev.mysql.com/tech-resources/articles/mysql -query-cache.html ) Maybe this is a hint about speed-up. --- ...
Thread:  Show this thread (3 posts)   Thread info: Re: How to compare performance of two stored procedure? Size: 704 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: How to compare performance of two stored procedure? :: Stored Procedures :: MySQL AB - MySQL Forums"
MySQL AB - MySQL Forums
Started 2 months, 3 weeks ago (2009-09-07 11:23:00)  by Jay Alverson
I think MySQL strips it all out as superfluous. You could create a CODE table inside it's own schema say DOCUMENTARY and import the entire PROCEDURE into a TEXT field. Then you could refer to the full code when necessary. It's a few extra steps though. > Thanks, Jay
Thread:  Show this thread (6 posts)   Thread info: Re: Maintain comments in the stored procedure while restoration Size: 360 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Maintain comments in the stored procedure while restoration :: Stored Procedures :: MySQL AB - MySQL Forums"
MySQL AB - MySQL Forums
Started 3 days, 20 hours ago (2009-11-26 08:39:00)  by Devart Team
You could use events. They allows to execute statements periodically or once at time. http://dev.mysql.com/doc/refman/5.1/en/events.html Devart Company, Database development tools http://www.devart.com/dbforge .
Thread:  Show this thread (2 posts)   Thread info: Re: Execute stored procedure automatically Size: 404 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Execute stored procedure automatically :: Stored Procedures :: MySQL AB - MySQL Forums"
MySQL AB - MySQL Forums
Started 1 week, 3 days ago (2009-11-19 23:39:00)  by Rick James
A side note: If you run a SP 1000 times from a given session, it will be compiled once. If a 1000 users login and each run the SP once, it will be compiled 1000 times. My point is that, even if you get the benchmark to work, will it give you the 'correct' information?
Thread:  Show this thread (6 posts)   Thread info: Re: Benchmarking Stored procedure ? Size: 301 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Benchmarking Stored procedure ? :: Stored Procedures :: MySQL AB - MySQL Forums"
MySQL AB - MySQL Forums
Started 4 days, 1 hour ago (2009-11-26 03:55:00)  by Peter Brawley
The only solution I know is to write a frontend caller for each relevant param combo.
Thread:  Show this thread (2 posts)   Thread info: Re: how to create stored procedure with Optional Parameters Size: 85 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: how to create stored procedure with Optional Parameters :: Stored Procedures :: MySQL AB - MySQL Forums"
 

Hot threads for last week on Stored Procedures::

Stored Procedures
Started 1 week, 4 days ago (2009-11-18 05:36:00)  by Devart Team
>i want to make a query to check whether current record exist, if exists update, else insert. What about using REPLACE statement? http://dev.mysql.com/doc/refman/5.1/en/replace.htm l Devart Company, Database development tools http://www.devart.com/dbforge .
Thread:  Show this thread (10 posts)   Thread info: Re: sqlcode in mysql? Size: 470 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: sqlcode in mysql? :: Stored Procedures :: MySQL AB - MySQL Forums"
Stored Procedures
Started 2 days, 14 hours ago (2009-11-27 14:52:00)  by George Schmidt
Hi Keith, Try to replace ', = ' by ' = '
Thread:  Show this thread (5 posts)   Thread info: Re: syntax error I can't figure out Size: 57 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: syntax error I can't figure out :: Stored Procedures :: MySQL AB - MySQL Forums"
Stored Procedures
Started 1 week ago (2009-11-22 08:26:00)  by George Schmidt
Hi David, DELIMITER $$ DROP PROCEDURE IF EXISTS `FILL_NUMBERS_TABLE` $$ CREATE PROCEDURE `FILL_NUMBERS_TABLE` (max_num INT) BEGIN # Fill with numbers DECLARE counter INT DEFAULT 1; # Delete existing content DELETE FROM `numbers`; WHILE counter <= max_num DO INSERT INTO `numbers` (`number`) VALUES (counter); SET counter = counter + 1; END WHILE;...
Thread:  Show this thread (3 posts)   Thread info: Re: Need help with SP Size: 556 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Need help with SP :: Stored Procedures :: MySQL AB - MySQL Forums"
Stored Procedures
Started 2 months ago (2009-09-30 15:14:00)  by Peter Brawley
Send it in as a string, eg '1,2,3', an in the sproc use concat(0 to assembled the query ... set @sql = concat( 'select ... where id in(', pin, ')' ); prepare stmt from @sql; etc... PB http://www.artfulsoftware.com
Thread:  Show this thread (5 posts)   Thread info: Re: SELECT records with comma separated value Size: 331 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: SELECT records with comma separated value :: Stored Procedures :: MySQL AB - MySQL Forums"
Stored Procedures
Started 3 days, 10 hours ago (2009-11-26 18:42:00)  by Paul Svirin
"Code caches are used to primarily lessen the impact of "hard parse" activity where, after SQL and stored code statements are initially executed and checked both syntactically and for security, the sometimes costly process of generating access plans is performed." ( http://dev.mysql.com/tech-resources/articles/mysql -query-cache.html ) Maybe this is a hint about speed-up. --- ...
Thread:  Show this thread (3 posts)   Thread info: Re: How to compare performance of two stored procedure? Size: 704 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: How to compare performance of two stored procedure? :: Stored Procedures :: MySQL AB - MySQL Forums"
Stored Procedures
Started 6 days, 22 hours ago (2009-11-23 06:52:00)  by Santiago Conde
Hi Thanks for your response. I'm not sure that the error is caused by the length of the parameter because the USER column is constrained to 16. I think it has more to do with the way I was using the parameter. I was passing a full qualified user (I mean, name@host) but MySQL was interpreting the parameter as a user name. As it's greater than 16, then the error arises. I ...
Thread:  Show this thread (2 posts)   Thread info: Re: Error when dropping user with SP Size: 806 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Error when dropping user with SP :: Stored Procedures :: MySQL AB - MySQL Forums"
Stored Procedures
Started 2 months, 3 weeks ago (2009-09-07 11:23:00)  by Jay Alverson
I think MySQL strips it all out as superfluous. You could create a CODE table inside it's own schema say DOCUMENTARY and import the entire PROCEDURE into a TEXT field. Then you could refer to the full code when necessary. It's a few extra steps though. > Thanks, Jay
Thread:  Show this thread (6 posts)   Thread info: Re: Maintain comments in the stored procedure while restoration Size: 360 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Maintain comments in the stored procedure while restoration :: Stored Procedures :: MySQL AB - MySQL Forums"
Stored Procedures
Started 3 days, 20 hours ago (2009-11-26 08:39:00)  by Devart Team
You could use events. They allows to execute statements periodically or once at time. http://dev.mysql.com/doc/refman/5.1/en/events.html Devart Company, Database development tools http://www.devart.com/dbforge .
Thread:  Show this thread (2 posts)   Thread info: Re: Execute stored procedure automatically Size: 404 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Execute stored procedure automatically :: Stored Procedures :: MySQL AB - MySQL Forums"
Stored Procedures
Started 4 days, 1 hour ago (2009-11-26 03:55:00)  by Peter Brawley
The only solution I know is to write a frontend caller for each relevant param combo.
Thread:  Show this thread (2 posts)   Thread info: Re: how to create stored procedure with Optional Parameters Size: 85 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: how to create stored procedure with Optional Parameters :: Stored Procedures :: MySQL AB - MySQL Forums"
Stored Procedures
Re: Little Proc Help - 2 new posts
Started 4 days, 3 hours ago (2009-11-26 01:43:00)  by Jeremy Rottman
I got this figured out. I had my syntax wrong. It should have been. SELECT Transaction_Main.FileNumber,, LK_Transaction_Types.TransactionPrefix, LK_Transaction_Types.TransactionDate INTO d_FileSuffix, d_FilePrefix, d_FileDate
Thread:  Show this thread (2 posts)   Thread info: Re: Little Proc Help Size: 327 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Little Proc Help :: Stored Procedures :: MySQL AB - MySQL Forums"

This page was found by:   ERROR 1307 (HY000): Failed to CREATE PROCEDURE  ERROR 1307 (HY000): Failed to CREATE FUNCTION  MySql.Data.MySqlClient.MySqlException: Thread stack overrun