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 cal
- Original Message -
> From: "Larry Martell"
> 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 gets advertised on t
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
> maintai
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;
+--+---
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. wrote:
> Would you try this?
>
> CREATE PROCEDURE `reset_sortid` (IN category INT(11))
> BEGIN
> SET @a = 0;
>
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 G
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" wrote:
> maybe try 'order by sort_id desc'?
>
>
> On Mon, Jul 14, 2014 at 12:42 PM, Don Wieland wrote
maybe try 'order by sort_id desc'?
On Mon, Jul 14, 2014 at 12:42 PM, Don Wieland 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 INT(11))
> BEGIN
>
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 a
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
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 wrote:
> Hi all,
>
> As you probably now, we created "Database Workbench",
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 WHERE LIMIT 1;
Source
http://dev.mysql.com/doc/refman/5.5/en/select-into-statement
SELECT id INTO @row_id FROM myTable WHERE 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 param
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
they
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
> It seems to me that your insert statement is trying to inser
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" wrote:
Hi all,
I can't explain strange behaviour of the INSERT statement in the stored
procedure.
The idea is t
dy 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
To: Machiel Richards
Cc: mysql@lists.mysql.com
Subject: Re: Stored procedure
Date: Wed, 05 Jan 2011 12:44:07 +0100
http://dev.mysql.com/doc/refman
%3e>>
*To*: Machiel Richards 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, the bash script
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
To: Machiel Richards , mysql@lists.mysql.com
Subject: Re: Stored procedure
Date: Wed, 05 Jan 2011 12:15:59 +0100
Hi,
Use
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.
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
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();
+---
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: mysql@lists.m
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
narrowing-
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 GROU
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 "
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 a
> -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 tha
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, a
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 ass
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
inbetwee
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 passInParam(
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 usin
[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:
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?
--
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, Critters
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 quest
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 Procedu
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
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
> Selec
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
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
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 i
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,
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 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
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
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
param
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]
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
gettin
"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
-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 St
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
> >
> 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]
> -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:
> -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
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
> >
> > DECL
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% |
> +-
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
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 Lim
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 (finall
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: 'mysql@
message in error, 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
e in error, 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 -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. Un
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 (4200
-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
But
-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 i
-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 5.0.
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 g
-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 decisi
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
Nobody
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 adva
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 neces
t;Michael Stassen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Wolfram Kraus" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; "news" <[EMAIL PROTECTED]>
Sent: Tuesday, November 30, 2004 11:49 AM
Subject: Re: Stored Procedure?
>
> [EMAIL
[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 se
ing system would be fantastic
as well!!
Mark
-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]
- 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.
- 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/
nd is still very
applicable.. I just thought this might be a slightly more "insightful"
example of what SP's can really handle.
Best regards
Mark
Mark Leith
Cool-Tools UK Limited
http://www.cool-tools.co.uk
-Original Message-
From: news [mailto:[EMAIL PROTECTED] On Be
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 explanatio
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 tha
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
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
[...]
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
ha
- 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?
4, 2004 5:07 AM
To: Nawal Lodha; [EMAIL PROTECTED]
Subject: Re: Stored Procedure Limitation
Nawal Lodha wrote:
Dear All,
On executing a Stored Procedure
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
http://bugs.mysql.com/b
-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 t
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 t
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
Any
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 spon
So sprach »Fredrick Bartlett« am 2001-12-26 um 07:30:44 -0800 :
> Explain how to configure the handlers for myperl under the win32 platform...
I don't know.
filter: sql
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.is
- 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
[ 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
proced
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 m
1 - 100 of 104 matches
Mail list logo
