r.callproc() method to
call stored procedures whose names include backticks.
Here is the entire traceback (with minor redactions):
Traceback (most recent call last): File
"C:\Users\[...]\Bottle\Website\website.py", line 108, in
cursor.callproc('`insert_page`', args) Fi
Hi, everyone
I'm having trouble using MySQL Connector/Python's cursor.callproc() method to
call stored procedures whose names include backticks.
Here is the entire traceback (with minor redactions):
Traceback (most recent call last): File
"C:\Users\[...]\Bottle\Website\websit
I have discovered that in MySQL client program I can define "definer" and
"sql security". This is the detail.
Thanks everybody.
Best regards,
Antonio.
Hi everybody,
Firstly thanks for your reply.
I'm using MySQL only in one server (I have only one), without replication
and without cluster configuration. I have defined the stored procedure as a
normal user, not as a root. And the call is make as a normal user also.
Occurs with MySQL 5.1.49 on De
>>>> 2013/04/17 14:16 +0200, Antonio Fernández Pérez >>>>
I have a doubt with stored procedures functionality. Is possible that a
stored procedure works with all databases form the server? I have created a
stored procedure on dataBaseA and also works with dataBaseB. Is tha
- Original Message -
> From: "Antonio Fernández Pérez"
> Subject: Doubt with stored procedures
>
> I have a doubt with stored procedures functionality. Is possible that
> a stored procedure works with all databases form the server? I have
> created a store
Hi everybody,
I have a doubt with stored procedures functionality. Is possible that a
stored procedure works with all databases form the server? I have created a
stored procedure on dataBaseA and also works with dataBaseB. Is that
correct? Independently of the user privileges defined.
Thanks
At 03:36 PM 2/28/2011, Michael Dykman wrote:
One statement will do:
SELECT Min(prod_price) , Max(prod_price), Avg(prod_price) INTO pl, ph, pa
from products;
- michael dykman
Michael,
Brilliant! Thanks. :-)
Mike
On Mon, Feb 28, 2011 at 4:30 PM, mos wrote:
> I want to have a store
One statement will do:
SELECT Min(prod_price) , Max(prod_price), Avg(prod_price) INTO pl, ph, pa
from products;
- michael dykman
On Mon, Feb 28, 2011 at 4:30 PM, mos wrote:
> I want to have a stored procedure that returns 5 columns from a table and do
> some calculations on it. But when I tr
I want to have a stored procedure that returns 5 columns from a table and
do some calculations on it. But when I try it, it complains there is a
syntax error on the 2nd "INTO" clause.
It appears I can have only 1 INTO clause per SQL statement. That means I
have to execute 5 different SQL stateme
> | @delete_id |
> ++
> | NULL |
> ++
> 1 row in set (0.00 sec)
>
>
>
>The delete_id should however return the value 3823054 and not null.
>
> Regards
> Machiel
>
>
>
>
>
> -Original Message-
> From: Ma
rn the value 3823054 and not null.
Regards
Machiel
-Original Message-
From: Machiel Richards
To: mysql mailing list
Subject: Database procedures
Date: Tue, 14 Dec 2010 08:37:10 +0200
HI All
I am hoping that someone with more experience than me can assist
here.
I
HI All
I am hoping that someone with more experience than me can assist
here.
I am trying to find out how to write a database procedure within
MySQL, however I have never worked with procedures in my life and the
resources I found on the net thus far seems greek to me
tored procedures
I am afraid you need to construct the whole stored procedure using CONCAT.
> -Original Message-
> From: Shawn Green [mailto:shawn.l.gr...@oracle.com]
> Sent: Friday, April 30, 2010 9:49 PM
> To: Ashley M. Kirchner
> Cc: mysql@lists.mysql.com
> Subject: [MySQL] Re: Variables in stored procedures
>
> Two options
>
> 1) u
Ashley M. Kirchner wrote:
I have the following procedure:
--
CREATE PROCEDURE `geodistance`(IN userid int, IN maxdist int)
begin
declare userlng double;
declare userlat double;
declare lng1 float;
declare lng2 float;
declare lat1 float;
declare lat2 float;
select ln
I have the following procedure:
--
CREATE PROCEDURE `geodistance`(IN userid int, IN maxdist int)
begin
declare userlng double;
declare userlat double;
declare lng1 float;
declare lng2 float;
declare lat1 float;
declare lat2 float;
select lng, lat into userlng, userla
ments, yet.
http://dev.mysql.com/doc/refman/5.1/en/stored-program-restrictions.html
SQL prepared statements (PREPARE, EXECUTE, DEALLOCATE PREPARE) can be
used in stored procedures, but not stored functions or triggers.
Hope that helps!
--
Shawn Green
MySQL Principle Technical Suppor
as a totally off-topc question, wouldn't something along the lines of
LIMIT COUNT(*)/2, 1 do that trick?
On 4/15/10, Rhino wrote:
>
>
> Shawn Green wrote:
>> Tompkins Neil wrote:
>>> Hi,
>>>
>>> I've used mainly of the older versions of MySQL. However am looking
>>> to port
>>> a application acr
Shawn Green wrote:
Tompkins Neil wrote:
Hi,
I've used mainly of the older versions of MySQL. However am looking
to port
a application across to MySQL 5. My question is when would one
decide to
use a Stored Procedure over a query written at the application level ?
The decision to encap
Tompkins Neil wrote:
Hi,
I've used mainly of the older versions of MySQL. However am looking to port
a application across to MySQL 5. My question is when would one decide to
use a Stored Procedure over a query written at the application level ?
The decision to encapsulate a particular proce
In phpmyqdmin in SQL window type :
show create procedure procedureName;
eg; SHOW CREATE PROCEDURE circle_area; in SQL
Check more on :
http://adminlinux.blogspot.com/2009/12/mysql-tips-verify-database-objects.html
Thanks
On Fri, Apr 9, 2010 at 1:00 PM, alba.albetti wrote:
> Since I work on My
Since I work on MySQL by using phpMyAdmin, is there anyone saying to me if and
how it's possibile to see the code of a stored procedure that I've created? For
example on Oracle I use sql-developer but with phpMyAdmin is it possible to see
the whole code of a procedure or of a trigger after creat
Hi,
I've used mainly of the older versions of MySQL. However am looking to port
a application across to MySQL 5. My question is when would one decide to
use a Stored Procedure over a query written at the application level ?
Cheers
Neil
On 07/03/2010, at 3:30 AM, Brent Clark wrote:
Hi everyone,
Currently we have a policy that prohibit our customers from
creating stored procedures and triggers on their DB's which I
imagine must be driving them up the walls. It's like having a car
with a boot but you are not a
Hi everyone,
Currently we have a policy that prohibit our customers from creating
stored procedures and triggers on their DB's which I imagine must be
driving them up the walls. It's like having a car with a boot but you
are not able to use it. :)
Are there any reasons why we wou
Ted, all,
Ted Yu wrote:
> Hi,
> We currently use SQL statements embedded in Java code. I believe stored
> procedures would give us better performance.
In general, this is likely, because you would (at least) save on the
number of statements and the amount of data communicated bet
Hi,
We currently use SQL statements embedded in Java code. I believe stored
procedures would give us better performance.
I found http://lists.mysql.com/maxdb/16680 which is very old.
Can someone share stored procedures tuning practices ?
Thanks
I'm trying to edit one of my stored procedures using MySQL Query Browser
and this is what I get back as a listing when I select Edit All
Procedures:
DROP PROCEDURE IF EXISTS `kwbo4418_2008bookworminventory`.`UpdateStock`
$$
/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='&#x
> Does anyone have examples on creating stored procedures?
There are quite a few in
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html
PB
-
ML wrote:
I am working on moving a database from SQL Server to MySQL 5. Tables,
data, etc I already know.
I have some procedu
I am working on moving a database from SQL Server to MySQL 5. Tables,
data, etc I already know.
I have some procedures that i would like to move as well.
Does anyone have examples on creating stored procedures?
Best,
-Jason
--
MySQL General Mailing List
For list archives: http
Hi all
I am new to stored procedures and have just started using them. Is there
any Web site you could suggest which discusses common optimization tips
for MySQL SPs?
Vikram
--
Operator: "So what do you need? Besides a miracle."
Neo: "Guns. Lots of guns."
-- The Matr
For embedded server do I need to configure
--with-embedded-privilege-control?
It looks like stored procedure is looking for mysql.proc table.
Thanks.
Hi all,
I am just getting started with replicating my servers and noticed that
queries executed by procedures on the master are not replicated to my
slaves. I need to know if this can be changed or if I have to get rid of my
procedures?
Thanks
Olaf
I usually use the --tabs option on mysqldump. However, if a table has a
function, procedure, or trigger, the code is not written to a file but
rather to standard out. Is this the only way to dump them using the --tabs
option? I thought of trying to use the Information Schema database somehow
but
On Fri, 11 Apr 2008 14:52:30 -0700
"Rob Wultsch" <[EMAIL PROTECTED]> wrote:
> On Fri, Apr 11, 2008 at 2:15 PM, Joshua D. Drake
> <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> > Can MySQL functions/stored procedures access database data?
> >
At 2:15 PM -0700 4/11/08, Joshua D. Drake wrote:
Hello,
Can MySQL functions/stored procedures access database data?
Yes, with some limitations. You will want to read this
section to see whether what you want to do is restricted:
http://dev.mysql.com/doc/refman/5.0/en/routine
On Fri, Apr 11, 2008 at 2:15 PM, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Can MySQL functions/stored procedures access database data?
>
> Joshua D. Drake
Yes. Is there something in particular you are looking to do?
--
Rob Wultsch
[EMAIL PROTECTED]
wul
Hello,
Can MySQL functions/stored procedures access database data?
Joshua D. Drake
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate
ies inside stored
procedures when they contains variable parameters
I just created this stored procedure to identify the problem
CREATE PROCEDURE `proc_test_qcache`(IN mailbox_number VARCHAR(64)) READS
SQL DATA DETERMINISTIC
BEGIN
SELECT password FROM users WHERE mailbox = mailbox_number;
Hi all,
I'm benchmarking performance improvement with MySQL Query Cache turned
on but I'm facing some problem with queries inside stored procedures
when they contains variable parameters
I just created this stored procedure to identify the problem
CREATE PROCEDURE `proc_test_
In the last episode (Jul 10), Andrey Dmitriev said:
> How do I view and backup my procedural code?
>
> In oracle it would be something like
> Select text from user_source where name='MY_PROCEDURE' order by line;
>
> I did mysqldump, and didn't see any of the f
How do I view and backup my procedural code?
In oracle it would be something like
Select text from user_source where name='MY_PROCEDURE' order by line;
I did mysqldump, and didn't see any of the functions or procedures
created.
In Oracle they'd be backed up either via
y OK, 0 rows affected (0.00 sec)
>
> the same, "drop function/trigger xxx" is also not supported in prepare
> statment.
>
> Is it a lack of feature in MySQL-5.0 version ??
Exactly. MySQL doesn't support dropping/creating functions/procedures or
triggers in funct
re
> statment.
>
> Is it a lack of feature in MySQL-5.0 version ??
Exactly. MySQL doesn't support dropping/creating functions/procedures or
triggers in functions or triggers.
regards
Nils
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
hi guys,
I'm searching stored procedures with prepare statment in mysql-5.0.
It seems that can not use 'drop procedure xxx' in prepare statment , like
this:
mysql> create procedure drpsp()
-> begin
-> prepare aa from 'drop procedure ct_tb&#x
On Wednesday 06 December 2006 17:13, Ed Reed wrote:
> Can someone tell me if it is possible to create stored procedures with
> Query Browser and if it is can you provide an example the works?
>
> Thanks
Should just be "Script->Create Stored Procedure/Function", give
Can someone tell me if it is possible to create stored procedures with
Query Browser and if it is can you provide an example the works?
Thanks
>> You seem to be mimicking the prepared query feature of mysqli in PHP5.
Do you
>> have the mysqli extension available? If so, you can use things like:
>>
>> http://www.php.net/manual/en/function.mysqli-stmt-bind-param.php
>>
>> which has an example as to how to utilize a prepared query.
>>
>>
Chris White wrote:
On Monday 27 November 2006 09:12, Filipe Freitas wrote:
CREATE PROCEDURE `getListaDeNewsflashes`(in quantidade smallint)
COMMENT 'Devolve uma tabela com um número limite de newsflashes'
begin
PREPARE statement FROM "SELECT * FROM newsflashes ORDER BY RAND() LIMIT ?";
SE
On Monday 27 November 2006 09:12, Filipe Freitas wrote:
> CREATE PROCEDURE `getListaDeNewsflashes`(in quantidade smallint)
>COMMENT 'Devolve uma tabela com um número limite de newsflashes'
> begin
> PREPARE statement FROM "SELECT * FROM newsflashes ORDER BY RAND() LIMIT ?";
> SET @limit=quanti
Filipe Freitas wrote:
Hi,
This is not a mysql thing but maybe you can help me.
I want to call a stored procedure from PHP, so I tried it like normal
querys: mysql_query("CALL mySP();"); with no success.
thx
I'm not PHP expert but I've managed to do this in perl using DBI (in
spite of all d
ise advice.
My understanding of using PHP with MySQL stored procedures is that you
have to call them through the mysqli extension. It doesn't appear that
you are using them. With them your would be using the mysqli_query()
function.
I don't do a lot of PHP, but I stumbled into a simil
uccess how? Generally with stored procedures and returning values, you
use a session variable and utilize it as OUT like so:
DROP PROCEDURE IF EXISTS CURVAL $
CREATE PROCEDURE CURVAL (OUT current INT)
BEGIN
SELECT value INTO current FROM sequence;
END $
DELIMITER ;
so when I go to call cur
ess how? Generally with stored procedures and returning values, you
use a session variable and utilize it as OUT like so:
DROP PROCEDURE IF EXISTS CURVAL $
CREATE PROCEDURE CURVAL (OUT current INT)
BEGIN
SELECT value INTO current FROM sequence;
END $
DELIMITER ;
so when I go to call curv
Remove the Semicolon
mysql_query("CALL mySP()");
Give it a try !!!
- Original Message -
From: Filipe Freitas <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Monday, November 27, 2006 10:59:09 AM GMT-0500 US/Eastern
Subject: Calling Stored Procedures from PHP
Hi
Hi,
This is not a mysql thing but maybe you can help me.
I want to call a stored procedure from PHP, so I tried it like normal
querys: mysql_query("CALL mySP();"); with no success.
thx
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
bleNameIn,"
order by ",ColNameIn);
Prepare s1 from @selStmt;
Execute s1;
Deallocate Prepare s1;
END|
DELIMITER ;
Dan
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 04, 2006 10:58 AM
To: mysql@lists.mysql.com
Subject: Stored Procedures Q
I have a dozen tables and I need to perform the same operations on them so
I thought I'd create a stored procedure and just pass the table name,
column name.
I was hoping it would take the parameters and substitute that in the code.
So it looks like this:
create procedure RankStock(IN TableN
Hi
Can mysql's stored procedures do regex function
--
Gregory Machin
[EMAIL PROTECTED]
www.linuxpro.co.za
It seems that mysqldump on mysql 5.0 does not export my stored
procedures.
How do I dump these out so that other people can load them into their
copies of my database?
Matt
--
A better way of running series of SAS programs:
http://overlook.homelinux.net/wilsonwiki/SasAndMakefiles
--
MySQL
Hi again folks,
The problem is solved.Was entirely my fault because i didn't check the version
of mysqlclient library.
-Original Message-
From: Gelu Gogancea
Sent: Monday, 21 August, 2006 12:47 PM
To: mysql@lists.mysql.com
Subject: How to call stored procedures using C API
Hi t
if is some one which have experience whith the handling store
procedures using MySQL C API, to give me a solution.
I use mysql-5.0.2x on Fedora 5.
Thank you,
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I have been trying very hard to get this working but I have NOT been
able to call the stored procedures in my MySQL database using the ADO
(**NOT** Ado.NET) Command object. I want to use stored procedures
'cos I want to restrict access to stored procedures and views only.
However, it
On Wednesday 09 August 2006 07:27 am, Vittorio Zuccalà wrote:
> Hello,
> i'm searching for a manual about stored procedures and triggers.
> I'm new about this arguments but i want to study them.
> Unfortunally, mysql online manual is not rich about examples so, can you
>
Hello,
i'm searching for a manual about stored procedures and triggers.
I'm new about this arguments but i want to study them.
Unfortunally, mysql online manual is not rich about examples so, can you
suggest me
some online manuals on stored procedures and triggers?
Thank you,
Hi,
In my stored procedures, i want to ROLLBACK when I encounter any
invalid values. However, as it happens, I cannot because MySQL does
not support COMMIT/ROLLBACK functionality right now (as of ver. 5.0.22
on WinXP Pro). I am setting session variables (Set @XX="Error
Message') ac
Thanks both Devanada and Peter, your replies helped me resolve it.
/Jon
On 7/30/06, Peter Brawley <[EMAIL PROTECTED]> wrote:
*>I'm trying to make stored procedures use parameters for limit and
tables, I
>guess this is either me using the wrong datatype or it's not pos
>I'm trying to make stored procedures use parameters for limit
and tables, I
>guess this is either me using the wrong datatype or it's not
possible. I'm
>having the same issue with seting the table for the query:
SET @sql = CONCAT( 'select * from some_table l
Jon wrote:
Hi list
I'm trying to make stored procedures use parameters for limit and tables, I
guess this is either me using the wrong datatype or it's not possible. I'm
having the same issue with seting the table for the query:
CREATE PROCEDURE sp_test1 (IN some_limit int
You would perform the prepare within the stored procedure.
Dan.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jon
Sent: Tuesday, July 25, 2006 10:31 AM
To: mysql@lists.mysql.com
Subject: Re: Stored procedures
But the scope of a prepared statement
My question is how do I send multiple sets of data into a stored
procedure
without doing the things I had outlined.
MySQL doesn't have arrays. Pass the data in a comma-delimited string
and PREPARE the statement, or pass it as a temp memory table.
PB
-
L P wrote:
Chris,
thank you fo
Chris,
thank you for the response, but that was not my question.
My question is how do I send multiple sets of data into a stored procedure
without doing the things I had outlined.
On 7/17/06, Chris <[EMAIL PROTECTED]> wrote:
L P wrote:
> Folks,
> say I have a need to add multiple rows at the
_table;
Well, first off with stored procedures the format is:
DELIMITER $$
CREATE PROCEDURE name ()
BEGIN
..
END $$
DELIMITER ;
DELIMITER is done so you can use ;'s within the stored procedure.
no need for using blocks and setting delimiter when it's only a single query
T
On Tuesday 25 July 2006 02:10 am, Jon wrote:
> CREATE PROCEDURE sp_test1 (IN some_limit int)
> select * from some_table limit some_limit;
>
> and
> CREATE PROCEDURE sp_test2 (IN some_table table)
> select * from some_table;
Well, first off with stored procedures the for
http://dev.mysql.com/doc/refman/5.0/en/sqlps.html
Dan.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jon
Sent: Tuesday, July 25, 2006 7:44 AM
To: Visolve DB Team
Cc: mysql@lists.mysql.com; Sena
Subject: Re: Stored procedures
On 7/25/06, Visolve DB Team &
@lists.mysql.com; Sena
Subject: Re: Stored procedures
On 7/25/06, Visolve DB Team <[EMAIL PROTECTED]> wrote:
>
> Hello Jon.
Hi there Team :)
And thanks for the quick reply
Could you tell me the version of MySql ?. You can find the version by
> excuting the command
>
> SELECT version()
;
To:
Sent: Tuesday, July 25, 2006 2:40 PM
Subject: Stored procedures
> Hi list
>
> I'm trying to make stored procedures use parameters for limit and
tables,
> I
> guess this is either me using the wrong datatype or it's not possible.
> I'm
> having the same i
OTECTED]>
To:
Sent: Tuesday, July 25, 2006 2:40 PM
Subject: Stored procedures
Hi list
I'm trying to make stored procedures use parameters for limit and tables,
I
guess this is either me using the wrong datatype or it's not possible.
I'm
having the same issue with seting t
Hi list
I'm trying to make stored procedures use parameters for limit and tables, I
guess this is either me using the wrong datatype or it's not possible. I'm
having the same issue with seting the table for the query:
CREATE PROCEDURE sp_test1 (IN some_limit int)
select *
L P wrote:
Folks,
say I have a need to add multiple rows at the same time.
for instance, say I'm collecting customer information and I want to add 3
addresses and 3 phone numbers at the same time for a customer.
The above is quite straightforward to accomplish when there is only one set
of data
Folks,
say I have a need to add multiple rows at the same time.
for instance, say I'm collecting customer information and I want to add 3
addresses and 3 phone numbers at the same time for a customer.
The above is quite straightforward to accomplish when there is only one set
of data to deal wit
Hi all.
I have a long and complicated chain of queries in MS Access that I want
to port to using stored procedures & views.
What I'd like to do is something like:
1) stored procedures grabs original data set, and dumps into temporary
tables
2) I open a view, which is in turn based
On Friday 09 June 2006 02:31 pm, Paul DuBois wrote:
> When you use the mysql client, you must redefine the statement delimiter
> during definition of a stored routine (or trigger or event) that uses
> compound statement syntax with multiple statements making up the body of
> the routine. See the e
Hello all and thanks again for any responses.
I'm hoping this is something really basic I'm not seeing. I have MySQL
5.0.22-log, and I'm having a weird time creating a basic stored procedure. I
get this far:
mysql> CREATE PROCEDURE getRootId (IN company_id INT)
-> BEGIN
-> DECLARE vari
Hello all and thanks again for any responses.
I'm hoping this is something really basic I'm not seeing. I have MySQL
5.0.22-log, and I'm having a weird time creating a basic stored procedure. I
get this far:
mysql> CREATE PROCEDURE getRootId (IN company_id INT)
-> BEGIN
-> DECLARE var
> The MySQL Stored Procedures and Functions is ready to use on production
> systems ?
>
> or support is very ammature ?
>
> I need to know because is a project desing decision !
>
> Tnks !!
>
> PLEASE I NEED OPINIONS
By the time your project is finish
The MySQL Stored Procedures and Functions is ready to use on production
systems ?
or support is very ammature ?
I need to know because is a project desing decision !
Tnks !!
PLEASE I NEED OPINIONS
i'm crazy to use this ?
Tnks in advance
MySQL , InnoDB and
If the features available in stored procedures {i.e. looping etc.} are
required, have you tried having the procedure 1st write/edit the data in a
temporary table and at the end select the values you want from that table.
I think I might write 2 procedures. One that does the data manipulation
> I just mean is it possible to hook a set of stored procedures to a view as
> opposed to a temporary table that we'd have to explicitly update?
"hook"?
If you mean: using the views in select statements inside a procedure:
sure it. Did you try?
Martijn Tonies
Database Wo
I just mean is it possible to hook a set of stored procedures to a view as
opposed to a temporary table that we'd have to explicitly update?
Chris
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: Friday, March 24, 2006 10:26 AM
To: mysql@lists.mysql.com
Su
this functionality over to stored procedures in
> mySql. My question is this: Is it possible to hook a series of stored
> procedures to a view so that the data is live and current?
What do you mean by that?
A view is always current.
Can you explain it a bit better?
>We could set i
onality over to stored procedures in
mySql. My question is this: Is it possible to hook a series of stored
procedures to a view so that the data is live and current? We could set it
up to run our procedures on some regular interval and dump the result into a
temporary table but having up-to-date data
"J A" <[EMAIL PROTECTED]> wrote on 03/01/2006 11:08:10 AM:
> Does MySQL have support for temporary tables inside stored procedures?
>
> _
> Express yourself instantly with MSN Messenger! Download
"J A" <[EMAIL PROTECTED]> wrote on 03/01/2006 11:04:50 AM:
> Does MySQL have the ability to send resultsets from stored procedures?
> (similar to ref cursors in Oracle).
>
> _
> FREE pop-up blocking
Does MySQL have support for temporary tables inside stored procedures?
_
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
--
MySQL Ge
Does MySQL have the ability to send resultsets from stored procedures?
(similar to ref cursors in Oracle).
_
FREE pop-up blocking with the new MSN Toolbar get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01
Hi, List
Please,
Someone know wy MyOdbc don't run store procedures from windows client ?
I launch it from Asp and Fox 8 and answer with error sintax.
The Same store procedure run from Java and on MySql properly.
Thanks,
Elkin Ortiz
Medellin,Colombia
- Original Message -
Hello, list
if launch a store procedure from two differents clients from windows, Visual
FoxPro 8.0 and Asp, for eject a store procedure in the database MySql 5, the
mysql connector answer with :
>From Asp
MyOdbcConnector 3.51.12
[MySQL][ODBC 3.51 Driver]You have an error in your SQL
> syntax; che
Hi,
I am trying to do something like this in MySQL 5.0
create function myfunc(param_name varchar(100)) returns int
begin
..
if exists(select 1
from my_table
where name = param_name) then
return -1;
end if;
.
1 - 100 of 355 matches
Mail list logo
