- Original Message -
From: Larry Martell larry.mart...@gmail.com
Subject: Stored procedure debuggers
Does anyone know of any debuggers for stored procs that run on Mac and/or
Linux?
Not aware of native ones, but I seem to remember that I managed to get the one
that occasionally
Hello Larry,
Subject: Stored procedure debuggers
Does anyone know of any debuggers for stored procs that run on Mac and/or
Linux?
Although all our tools are Windows tool, we have customers running Database
Workbench
under Wine without major problems.
We have a standalone debugger tool
I would second what m. dykman says. There is no reason I can think of that
you would even be doing the order by clause.
keith
On Sun, Jul 13, 2014 at 11:16 PM, yoku ts. yoku0...@gmail.com wrote:
Would you try this?
CREATE PROCEDURE `reset_sortid` (IN category INT(11))
BEGIN
SET @a
The order makes quite a big difference, actually. In this case it
ensures that the ordering of the values in the sort_id column is
maintained, even though the numbers are different.
Say this is your data (I have ignored the category thingy for now):
SELECT id, sort_id FROM documents;
Anders,
I didn't see that at first, but now. I'd agree. Maybe I should read
up on stored procedures.
On Mon, July 14, 2014 16:25, Anders Karlsson wrote:
The order makes quite a big difference, actually. In this case it
ensures that the ordering of the values in the sort_id column is
maybe try 'order by sort_id desc'?
On Mon, Jul 14, 2014 at 12:42 PM, Don Wieland d...@pointmade.net wrote:
I am trying to create this stored procedure, but can't understand why my
editor is chocking on it. Little help please:
DELIMITER //
CREATE PROCEDURE `reset_sortid` (IN category
why do you need the 'order by' in your update at all? The statement, if
innodb, will certainly be atomic; the order in which they are updated means
nothing.
On Jul 13, 2014 11:46 PM, kitlenv kitl...@gmail.com wrote:
maybe try 'order by sort_id desc'?
On Mon, Jul 14, 2014 at 12:42 PM, Don
Would you try this?
CREATE PROCEDURE `reset_sortid` (IN category INT(11))
BEGIN
SET @a = 0;
UPDATE
documents SET sort_id = (@a := @a + 1)
WHERE
document_category = category
ORDER BY
sort_id;
END
//
2014-07-14 11:42
2012/11/23 10:49 +0530, Girish Talluru
I have a scenario where I have to screen a huge bunch of records for in db
using certain rules. I have done in traditional php style record by record
and it took 90 mins for 4000 records. I have 800k - 900k records in
production which might possibly lead to
when I call a
stored procedure does the control get backs immediately to the php script?
No, sprocs wil lvery likely slow you down.
Probably best to split the job into several part-tasks (i) read rows into a
work buffer, (ii) walk the work buffer and mark done rows, (iii) walk the done
list
In my community, interest would be VERY high. I often counsel putting
logic on the server; the biggest point of relunctance is the
difficulty debugging.
- michael dykman
On Wed, Feb 15, 2012 at 10:45 AM, Martijn Tonies m.ton...@upscene.com wrote:
Hi all,
As you probably now, we created
SELECT id INTO @row_id FROM myTable WHERE blah blah LIMIT 1;
Source
http://dev.mysql.com/doc/refman/5.5/en/select-into-statement.html
On Sep 21, 2011, at 2:23 PM, Brandon Phelps wrote:
Hello all,
I would like to create a stored procedure that does the following:
1. Accepts 4 values as
Ah ha! Thanks Derek. I thought INTO was used strictly for inserting the
selected records into another table.
Much appreciated.
On 09/21/2011 02:34 PM, Derek Downey wrote:
SELECT id INTO @row_id FROM myTable WHEREblah blah LIMIT 1;
Source
It seems to me that your insert statement is trying to insert duplicate rows
into the storage table. This is why insert ignore and replace work.
On Jul 9, 2011 3:49 AM, Igor Shevtsov nixofort...@googlemail.com wrote:
Hi all,
I can't explain strange behaviour of the INSERT statement in the stored
That's what is bad of SP in MySQL, debugging.
Just out of the blue,
can you try to disable query cache?
*SET GLOBAL query_cache_size = 0;*
*
SET GLOBAL query_cache_type = 0;
*
it could be a bug
Claudio
2011/7/9 Johnny Withers joh...@pixelated.net
It seems to me that your insert
Thanks Johnny,
In this case I wouldn't be able to insert a completely new row but
replace the existent one, so row count would stay the same.
This is a storage table with the only unique constraints on:
dda_debits_id column.
the test data is very small, so I would've noticed any duplicates and
() statement.
Can anybody give me some ideas as I have tried so many options
and yet none of them has worked as yet.
Regards
Machiel
-Original Message-
From: petya pe...@petya.org.hu
To: Machiel Richards machi...@rdc.co.za
Cc: mysql@lists.mysql.com
Subject: Re: Stored procedure
Date
Hi,
Use the mysql event scheduler instead of cron, the bash script is quite
pointless, and call your stored procedure with now() - interval 1 day
parameter.
Peter
On 01/05/2011 11:00 AM, Machiel Richards wrote:
Good day all
I am hoping that someone can assist me here.
HI
How do I use the mysql event scheduler?
I have not used this as yet so not sure how to use it.
Regards
Machiel
-Original Message-
From: petya pe...@petya.org.hu
To: Machiel Richards machi...@rdc.co.za, mysql@lists.mysql.com
Subject: Re: Stored procedure
Date: Wed, 05
%3cpe...@petya.org.hu%3e
*To*: Machiel Richards machi...@rdc.co.za
mailto:machiel%20richards%20%3cmachi...@rdc.co.za%3e,
mysql@lists.mysql.com mailto:mysql@lists.mysql.com
*Subject*: Re: Stored procedure
*Date*: Wed, 05 Jan 2011 12:15:59 +0100
Hi,
Use the mysql event scheduler instead of cron
I think, you have to use prepare() before run that select statement.
i.e
SET @s = CONCAT(SELECT * INTO OUTFILE, c ,FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED
BY '' LINES TERMINATED BY '\n' FROM cells_summary WHERE PMMDATEANDTIME=b);
PREPARE stmt FROM @s;
EXECUTE stmt;
regards,
nilnandan
Creating a temporary merge table works fine for me on 5.0.
Your table isn't innodb is it? That will fail with an error like you're
getting.
Regards,
Gavin Towey
-Original Message-
From: Dante Lorenso [mailto:da...@lorenso.com]
Sent: Thursday, December 10, 2009 3:20 PM
To:
Gavin Towey wrote:
Creating a temporary merge table works fine for me on 5.0.
Your table isn't innodb is it? That will fail with an error like you're
getting.
Strange. Now that I am on my home network and trying this again, it
seems to be working.
mysql SELECT version();
Hi,
Use a temporary table to store the ids and join to it for the final
update? That will at least avoid an error when the cursor selects zero
records.
Cheers,
-Janek
On Wed, 2009-05-20 at 16:05 -0400, W. Scott Hayes wrote:
Hello,
I would like to do a select on a table to get back the IDs
Ratheesh,
There's a specific list for PHP database functions, Databases and
PHP (PHP-DB), which you can find at http://php.net/mailinglists .
I'm forwarding your message over to there, and recommend that you
subscribe to that list. You'll probably get more direct responses by
Dynamic SQL would work for Imbedding String for the IN clause.
That would be too messy for such a little query.
Here is a crazy suggestion
CREATE PROCEDURE additems ()
BEGIN
DECLARE grammatures VARCHAR(128) DEFAULT '7,12,1,13,2,5,14,21';
DECLARE newids VARCHAR(128);
SELECT
Just use the type varchar.I always use it in my regular life.
On Feb 11, 2008 4:44 PM, Magne Westlie [EMAIL PROTECTED] wrote:
Jerry Schwartz wrote:
SELECT user_id, user_name FROM user_test WHERE user_id IN (SELECT
uid
FROM temp_uids);
[JS] Couldn't you replace the WHERE user_id IN
Jerry Schwartz wrote:
SELECT user_id, user_name FROM user_test WHERE user_id IN (SELECT
uid
FROM temp_uids);
[JS] Couldn't you replace the WHERE user_id IN (SELECT uid FROM
temp_uids)
with a simple JOIN? If IN is badly optimized, as I've read here, wouldn't
that be more efficient? Or am I
Hi again,
I found a way that works for the query I wanted in my sproc. It uses
your solution to insert into a temporary table, and then uses a SELECT
in the IN-part.
I don't know yet if this solution may have side-effects. I need to read
more about how temporary tables is handled by MySQL, as
-Original Message-
From: Magne Westlie [mailto:[EMAIL PROTECTED]
Sent: Friday, February 08, 2008 5:37 AM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: stored procedure, parameter type help needed
Hi again,
I found a way that works for the query I wanted in my sproc
Hi,
Thanks a lot Peter, that was useful and it worked fine. The only problem
is that the query I actually want to use this in, is a 100 line query
with lots of arguments. I don't feel to good about creating it into a
bunch of strings (16) that I have to concatenate with the variables
Magne,
I want to create a stored procedure that runs a query using the IN
operator ...
See 'Variable-length argument for query IN() clause' at
http://www.artfulsoftware.com/queries.php
PB
-
Magne Westlie wrote:
Dear List,
I want to create a stored procedure that runs a query using
Hi Magne
...the query I actually want to use this in, is a 100 line query with
lots of arguments.
I don't feel to good about creating it into a bunch of strings (16)
that I have to
concatenate with the variables inbetween.
The only alternative I know for current versions of MySQL is to
Magne,
Sorry, the server is down at the moment, here is the entry ...
To have an sproc accept a variable-length parameter list for an
|IN(...)| clause in a query, code the sproc to |PREPARE| the query
statement:
|
DROP PROCEDURE IF EXISTS passInParam;
DELIMITER |
CREATE PROCEDURE
Surely, you don't have legacy stored procedure in ASP under MySQL?
are you sure this is the right list to be asking?
- michael
On 5/30/07, Critters [EMAIL PROTECTED] wrote:
Hi
How do you get multiple record sets from a stored procedure in legacy
ASP? It doesn't seem to work for us.
The
The stored procedure is in MySQL, but when called using ASP it fails to
return more than the first record.
Anyone?
--
Dave
Michael Dykman wrote:
Surely, you don't have legacy stored procedure in ASP under MySQL?
are you sure this is the right list to be asking?
- michael
On 5/30/07,
Would you care to send the source of that procedure plus tell us why
you believe it works when called by something other than C#?
On 5/30/07, Critters [EMAIL PROTECTED] wrote:
The stored procedure is in MySQL, but when called using ASP it fails to
return more than the first record.
Anyone?
--
[snip]
The stored procedure is in MySQL, but when called using ASP it fails to
return more than the first record.
Anyone?
[/snip]
You need a while loop. Does the SP work from the command line properly?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi Paul,
I've spent the past two days trying to reproduce my problem and I think
I may have brought this on myself. I've had been trying to create a
procedure with the Query Browser GUI and was unable to do so. So I tried
to create them with MySQL-Front and MySQL Control Center and somehow I
was
At 11:34 AM -0800 12/1/06, Chris White wrote:
On Friday 01 December 2006 11:22, Ed Reed wrote:
I have a problem/question I'd like to find someone else to verify/answer
for me.
I'm using MySQL 5.1.09 running on Netware. I've created a stored
procedure that has one parameter,
Create
On Friday 01 December 2006 11:22, Ed Reed wrote:
I have a problem/question I'd like to find someone else to verify/answer
for me.
I'm using MySQL 5.1.09 running on Netware. I've created a stored
procedure that has one parameter,
Create Procedure MyTest(strVal VarChar)
Begin
Select
Got it.
Thanks
Chris White [EMAIL PROTECTED] 12/1/06 11:34 AM
On Friday 01 December 2006 11:22, Ed Reed wrote:
I have a problem/question I'd like to find someone else to
verify/answer
for me.
I'm using MySQL 5.1.09 running on Netware. I've created a stored
procedure that has one
What you are asking for is exactly what DEFINER security does. The
applicxation owner grants appuser the right to execute the procedure,
but not to SELECT from any tables. The procedure is then run with the
security attributes of the definer of the procedure, the application
owner, even though
*Disclaimer - this will be kind of vague mainly because I only vaguely
recall the material.
I am trying to create a stored procedure. Now I vaguely recall reading
something that says I have to match a column type if I am messing with
one. Something like I want to match a table
Josh wrote:
I posted this same item on the mysql forum but the
only place that looked remotely appropriate was under
the Newbie section... I'm not sure if it will be
answer there so I thought I might toss it out here to
see if there were any takers.
I'm baffled as to why this stored procedure
Peter, nice catch. Changing the parameter names did
the trick. Thanks.
--- Peter Brawley [EMAIL PROTECTED] wrote:
Josh wrote:
I posted this same item on the mysql forum but the
only place that looked remotely appropriate was
under
the Newbie section... I'm not sure if it will be
I'm having some issues creating a stored procedure to optimize tables
in the database.
PREPARE accepts only CREATE TABLE, DELETE, DO, INSERT, REPLACE, SELECT,
SET and UPDATE.
PB
-
DreamWerx wrote:
I'm having some issues creating a stored procedure to optimize tables
in the database.
Hello.
This is a bug:
http://bugs.mysql.com/bug.php?id=16378
AESYS S.p.A. [Enzo Arlati] wrote:
I found a problem using stored procedure and bin-log enabled.
Suppose I stored procedure like this:
==
DELIMITER $$;
DROP
Jesse Castleberry [EMAIL PROTECTED] wrote on 11/07/2005 01:26:59 PM:
I've got a stored procedure I'm trying to convert from MS SQL. I've
gotton
so far with it, but it's complaining about the INSERT command. It's a
very
simple stored procedure, so it should easy to figure out, but I'm not
Jesse,
BEGIN
INSERT INTO Campers (FirstName, LastName, UserName, Password) VALUES
(cFirstName, cLastName, cUserName, cPassword) // ERROR RIGHT HERE.
AddedID = LAST_INSERT_ID()
END;
First, there's a right parenthesis missing. Second, the expression
AddedID = LAST_INSERT_ID()
will evaluate
Jesse,
VALUES (cFirstName, cLastName, cUserName, cPassword) // error on this
line.
return LAST_INSERT_ID() /*@@Identity*/
END
When I execute this, It bombs on the indicated line stating that there
is a
syntax error.
A stored procedure cannot return a value.
PB
-
Jesse Castleberry
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kent Roberts wrote:
I have a simple SP that is selecting rows based on a date range using
parameters. I've tried several permutations that all return 0 rows.
The select statement looks like this:
select * from 'mit_log'.'mitlog' where
Kent Roberts [EMAIL PROTECTED] wrote on 08/09/2005 10:42:24 AM:
I have a simple SP that is selecting rows based on a date range
using parameters. I've tried several permutations that all return 0
rows.
The select statement looks like this:
select * from 'mit_log'.'mitlog' where
That's it. Thanks Mark. I think I was confusinged by MS SQL Server
syntax
which prefixes both session variables and parameters with @. And you're
right
Scott, I changed the name of the SP for posting simplicity and forgot to
change the colling statement to match. Thanks a lot both of you for
Sorry, I'll try and proof reed more karefullly in the futchure. :-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Now that I think about it, if MySql forced declaration of session
variables it
would avoid some nasty bugs in SPs.
Mark Matthews 08/09/05 08:46AM
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kent Roberts wrote:
I have a simple SP that is selecting rows based on a date range using
parameters.
CREATE PROCEDURE title()
BEGIN
DECLARE title VARCHAR(255);
SET title = '%Unconditional%';
SELECT title;
END;
//
mysql CALL title()//
+-+
| title |
+-+
| %Unconditional% |
+-+
1 row in set (0.01 sec)
HTH
Mark
Mark Leith
Cool-Tools UK
Scott Hamm [EMAIL PROTECTED] wrote on 08/02/2005 10:12:01 AM:
I'm used with MS SQL and could not understand MySQL's document. I'm
trying
to create something like the simple example
DECLARE @title varchar(255)
SET @title='%Unconditional%'
SELECT @title;
How do I get around to it in
On 8/2/05, Mark Leith [EMAIL PROTECTED] wrote:
CREATE PROCEDURE title()
BEGIN
DECLARE title VARCHAR(255);
SET title = '%Unconditional%';
SELECT title;
END;
//
mysql CALL title()//
+-+
| title |
+-+
| %Unconditional% |
+-+
1 row in
MySQL 5.0.9 Beta :)
On 8/2/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Scott Hamm [EMAIL PROTECTED] wrote on 08/02/2005 10:12:01 AM:
I'm used with MS SQL and could not understand MySQL's document. I'm
trying
to create something like the simple example
DECLARE @title
-Original Message-
From: Scott Hamm [mailto:[EMAIL PROTECTED]
Sent: 02 August 2005 15:38
To: [EMAIL PROTECTED]
Cc: Mysql
Subject: Re: STORED PROCEDURE
On 8/2/05, Mark Leith [EMAIL PROTECTED] wrote:
CREATE PROCEDURE title()
BEGIN
DECLARE title VARCHAR(255);
SET title
-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]
Sent: 02 August 2005 15:56
To: mysql@lists.mysql.com
Subject: RE: STORED PROCEDURE
-Original Message-
From: Scott Hamm [mailto:[EMAIL PROTECTED]
Sent: 02 August 2005 15:38
To: [EMAIL PROTECTED]
Cc
Hmm nice screwed formatting, but anyway.. ;)
Please guys - the overquoting!!
Thank you.
--
Martijn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Your second statement hit the spot. :) Thanks!
On 8/2/05, Mark Leith [EMAIL PROTECTED] wrote:
-Original Message-
From: Scott Hamm [mailto:[EMAIL PROTECTED]
Sent: 02 August 2005 15:38
To: [EMAIL PROTECTED]
Cc: Mysql
Subject: Re: STORED PROCEDURE
On 8/2/05, Mark Leith
How effective? Very effective. Actually, I am testing it, and once I
overcame a few syntax issues, it's working great. Procedures and
functions both. I havent tested triggers yet. But so far I am using
a mini-blog thing on my web site with them and I am loving the ease of
Mysql combined
Sorry, I have found the reason why. I have MySQL 4.1 and MySQL 5.0 running on
different port. I was not passing --port=3307 to mysql client to connect to the
correct server.
-Original Message-
From: Frondoni, Giorgio
Sent: Tuesday, June 14, 2005 10:23 PM
To:
, please advise the sender immediately by reply e-mail
and delete this message. Thank you for your cooperation.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Friday, April 08, 2005 4:46 PM
To: Paul Beer; mysql@lists.mysql.com
Subject: Re: stored procedure
At 17:15
, please advise the sender immediately by reply e-mail
and delete this message. Thank you for your cooperation.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Friday, April 08, 2005 4:46 PM
To: Paul Beer; mysql@lists.mysql.com
Subject: Re: stored procedure
At 17:15
At 17:15 -0400 4/8/05, Paul Beer wrote:
I'm trying to pass a value into a stored procedure to dynamically set
which column(s) to sort by. The following code doesn't work.
The query executes but ignores my order by parameter.
I assume there is a simple answer to this that I'm just missing.
Yes.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am using mysql 5.0.3, running under Solaris 8, and I believe the error
I am getting is not possible, but I don't know what I did wrong.
I do:
call assignItem('user', 1999, 97);//
I get:
ERROR 1172 (42000): Result consisted of more than one row
On Apr 7, 2005, at 2:37 PM, James Black wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am using mysql 5.0.3, running under Solaris 8, and I believe the
error
I am getting is not possible, but I don't know what I did wrong.
I do:
call assignItem('user', 1999, 97);//
I get:
ERROR 1172
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
It would appear, based on my testing, so far, that using stored
procedures is some between 25% slower and 10x slower, depending on the test.
I am using jdk1.5, on Solaris 8, and mysql 5.0.3.
I hope that when 5 comes out of beta that the performance
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Is it possible to have a stored procedure query another database?
I have two databases where the second (B) uses information from (A) to
make decisions.
It would be great if the stored procedure on database B could query A,
so that it can make
James Black [EMAIL PROTECTED] wrote on 04/01/2005 04:11:49 PM:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Is it possible to have a stored procedure query another database?
I have two databases where the second (B) uses information from (A) to
make decisions.
It would be great if
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am curious if this should be the norm, that the stored procedure took
879 ms when I called it 9 times, with slightly different values, and the
non-stored procedure test took 512ms with also slightly different values.
I am using jdk1.5 and mysql
matt_lists wrote:
Anybody have any recommendations for a stored procedure editor/debugger?
We are developing a test program with 5.x.x and procedures to see if
it'll work for us
stuck trying to get variables sorted out, and without a proper
debugger it's extremely hard
thanks in advance
From 5.0.1 you can write database-specific stored procs but the
language is SQL not Perl, see
http://dev.mysql.com/doc/mysql/en/Stored_Procedures.html.
PB
sam wrote:
Hi,
Can anyone tell me where I can download examples for creating Stored
Procedure in perl DBI?
It seems that I can't create
Rhino wrote:
Well, I think you've just succeeded in demolishing my wonderful example; it
turns out that we don't need to use a stored procedure to find a median
after all ;-)
That wasn't my intention. I thought I was adding support to your example.
Just because it can be done in SQL doesn't
[...]
Suppose you have a table with a million records, test scores from a widely
taken exam for example. You need to find the median mark - NOT the
average! - so your algorithm needs to read all million records, sort them
into ascending or descending sequence by the test score, then read exactly
Because you will be downloading 500,000 rows... And I don't really
think that was the point. Who cares what the example is. Personally I
was quite impressed with great explanation.
I would have simply said a chunk of code that runs on the server that
the client can call. And this guy took the
Michael J. Pawlowsky wrote:
Because you will be downloading 500,000 rows... And I don't really
think that was the point. Who cares what the example is. Personally I
was quite impressed with great explanation.
I second that it was a great explanation! Please don't get me wrong!
And furthermore I
news [EMAIL PROTECTED] wrote on 11/30/2004 07:58:18 AM:
Michael J. Pawlowsky wrote:
Because you will be downloading 500,000 rows... And I don't really
think that was the point. Who cares what the example is. Personally I
was quite impressed with great explanation.
I second that it was
Heyho!
[EMAIL PROTECTED] wrote:
news [EMAIL PROTECTED] wrote on 11/30/2004 07:58:18 AM:
Michael J. Pawlowsky wrote:
Because you will be downloading 500,000 rows... And I don't
really think that was the point. Who cares what the example is.
Personally I was quite impressed with great
Limited
http://www.cool-tools.co.uk
-Original Message-
From: news [mailto:[EMAIL PROTECTED] On Behalf Of Wolfram Kraus
Sent: 30 November 2004 12:58
To: [EMAIL PROTECTED]
Subject: Re: Stored Procedure?
Michael J. Pawlowsky wrote:
Because you will be downloading 500,000 rows... And I don't
- Original Message -
From: Wolfram Kraus [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 30, 2004 10:04 AM
Subject: Re: Stored Procedure?
Heyho!
[EMAIL PROTECTED] wrote:
news [EMAIL PROTECTED] wrote on 11/30/2004 07:58:18 AM:
Michael J. Pawlowsky wrote
- Original Message -
From: Mark Leith [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 30, 2004 10:47 AM
Subject: RE: Stored Procedure?
I think a much better example of store procedures is one showing actual
procedural processing. Whilst they also allow a lot less
would be fantastic
as well!!
Mark dreaming away the day
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: 30 November 2004 16:04
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Stored Procedure?
- Original Message -
From: Mark Leith [EMAIL PROTECTED
[EMAIL PROTECTED] wrote:
news [EMAIL PROTECTED] wrote on 11/30/2004 07:58:18 AM:
Michael J. Pawlowsky wrote:
Because you will be downloading 500,000 rows... And I don't really
think that was the point. Who cares what the example is. Personally I
was quite impressed with great explanation.
I
Kraus [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; news [EMAIL PROTECTED]
Sent: Tuesday, November 30, 2004 11:49 AM
Subject: Re: Stored Procedure?
[EMAIL PROTECTED] wrote:
news [EMAIL PROTECTED] wrote on 11/30/2004 07:58:18 AM:
Michael J. Pawlowsky wrote:
Because you will be downloading
- Original Message -
From: Steve Grosz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, November 29, 2004 10:55 PM
Subject: Stored Procedure?
Ok, I'm new to MySql (or SQL in general). I'm curious what exactly a
stored procedure in MySql is, and what the benefit would be?
To: Nawal Lodha; [EMAIL PROTECTED]
Subject: Re: Stored Procedure Limitation
Nawal Lodha wrote:
Dear All,
On executing a Stored Procedure (in MySQL
5.0.0
Nawal Lodha wrote:
Dear All,
On executing a Stored Procedure (in MySQL 5.0.0-alpha) containing
multiple Select statements, I get the error
"SELECT in a stored procedure must have INTO".
I found that this is a MyODBC bug.
http://bugs.mysql.com/bug.php?id=2273
and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
NanFei Wang wrote:
Hi,
somebody can help me!
my database is: mysql-5.0.0a-alpha
the connection driver is:mysql-connector-java-3.1.1-alpha-bin.jar
I want to test stored procedure of the new feature in MySQL version
5.0. A
I can call the
Philip Markwalder [EMAIL PROTECTED] wrote:
I have a few questions concerning stored procedures:
1. If I create a stored procedure (like the one below), why does the
returned values not change, though in the stored prcoedure the id has
been generated?
2. Is there any better way to hand
And I hope triggers as a collegue and I have to submit a evaluation
report on why our department should consider Mysql to be used in
conjuction with Postgrsql
which is our default RDBMS in our organisation.
So I have a few link's regarding performaces etc as well as the Mysql V
PostGresql
Tonino,
Friday, October 11, 2002, 10:05:42 AM, you wrote:
T Just a short question - Does anyone know the progress of stored
T procedure support in MySQL 4
Stored procedures will come in v5.0
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
So sprach »Cafetechno« am 2001-12-26 um 10:34:59 +0700 :
If mysql will include the stored procedure feature, what kind of langguage
to be used for the stored procedure ?
If you use myperl, it will be perl.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to
Explain how to configure the handlers for myperl under the win32 platform...
Alexander Skwar wrote:
So sprach »Cafetechno« am 2001-12-26 um 10:34:59 +0700 :
If mysql will include the stored procedure feature, what kind of langguage
to be used for the stored procedure ?
If you use myperl,
[ obfilter: mysql database ]
Sinisa Milivojevic wrote:
Cafetechno writes:
When The Stored Procedure Capability will be
included in mySQL
Take a look at myperl on http://freshmeat.net
Interesting start, of course.
What would be nice is to support a proper create or replace
- Original Message -
From: Shankar Unni [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, December 27, 2001 12:57 AM
Subject: Re: Stored Procedure
[ obfilter: mysql database ]
Sinisa Milivojevic wrote:
Cafetechno writes:
When The Stored Procedure Capability
1 - 100 of 104 matches
Mail list logo