|
More site info...
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.
|
|
|
|
|
Posting activity on Stored Procedures:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
23
|
74
|
209
|
|
Post:
|
47
|
173
|
422
|
|
|
Stored Procedures Posting activity graph:
|
Top authors during last week:
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.
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 .
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!
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
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
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...
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.
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
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...
|
|
|
|
Latest active threads on 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 .
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.
Started 2 days, 14 hours ago (2009-11-27 14:52:00)
by George Schmidt
Hi Keith,
Try to replace ', = ' by ' = '
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.
---
...
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
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 .
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?
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.
|
|
Hot threads for last week on 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 .
Started 2 days, 14 hours ago (2009-11-27 14:52:00)
by George Schmidt
Hi Keith,
Try to replace ', = ' by ' = '
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;...
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
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.
---
...
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 ...
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
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 .
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.
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
|
|
Size: 470 bytes
