===
On 2018-08-18 23:59, shawn l.green wrote:
Hello Jeff,
On 8/13/2018 12:05 PM, j...@lxvi.net wrote:
Hello, I have read through several pages of the reference manual, and
I've seen several instances where it is stated that LOCK TABLES (and
UNLOCK TABLES) is not allowed in a stored procedur
l.green wrote:
Hello Jeff,
On 8/13/2018 12:05 PM, j...@lxvi.net wrote:
Hello, I have read through several pages of the reference manual, and
I've seen several instances where it is stated that LOCK TABLES (and
UNLOCK TABLES) is not allowed in a stored procedure, but so far, I
haven'
Hello Jeff,
On 8/13/2018 12:05 PM, j...@lxvi.net wrote:
Hello, I have read through several pages of the reference manual, and
I've seen several instances where it is stated that LOCK TABLES (and
UNLOCK TABLES) is not allowed in a stored procedure, but so far, I
haven't found an expl
Hello, I have read through several pages of the reference manual, and
I've seen several instances where it is stated that LOCK TABLES (and
UNLOCK TABLES) is not allowed in a stored procedure, but so far, I
haven't found an explanation as to *why* that is. Could someone please
enlighten m
I am pleased to announce the release of ODB 2.4.0.
ODB is an open source object-relational mapping (ORM) system for C++. It
allows you to persist C++ objects to a relational database without having
to deal with tables, columns, or SQL and without manually writing any of
the mapping code.
Major ne
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
- 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 occasi
Does anyone know of any debuggers for stored procs that run on Mac and/or Linux?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
egory INT(11))
>>> BEGIN
>>> SET @a = 0;
>>> UPDATE
>>> documents SET sort_id = (@a := @a + 1)
>>> WHERE
>>> document_category = category
>>> ORDER BY
>>>
ORDER BY
sort_id;
END
//
2014-07-14 11:42 GMT+09:00 Don Wieland :
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
DECL
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 GMT+09:00 Don Wieland :
>
> &g
GMT+09:00 Don Wieland :
> 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
> DECLARE a INT;
>
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)
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`
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
DECLARE a INT;
SET a = 0;
UPDATE
documents SET sort_id = (a
L]
> Subject: Get Affected Rows after Stored Procedure COMMIT
>
> Hi,
>
> I have a number of INSERT and UPDATE statements in a MySQL Stored
> Procedure, that works in the form of START TRANSACTION followed by COMMIT.
> Also I am handling any EXCEPTION.
>
> However,
>>>> 2013/07/02 12:29 +0100, Neil Tompkins >>>>
I have a number of INSERT and UPDATE statements in a MySQL Stored
Procedure, that works in the form of START TRANSACTION followed by COMMIT.
Also I am handling any EXCEPTION.
However, after calling COMMIT, how can I get the
Hi,
I have a number of INSERT and UPDATE statements in a MySQL Stored
Procedure, that works in the form of START TRANSACTION followed by COMMIT.
Also I am handling any EXCEPTION.
However, after calling COMMIT, how can I get the number of Rows that were
affected either INSERTED or UPDATTED
What language are you using?
In Perl, there is
$sth->more_results;
> -Original Message-
> From: Girish Talluru [mailto:girish.dev1...@gmail.com]
> Sent: Wednesday, March 13, 2013 5:24 AM
> To: mysql@lists.mysql.com
> Subject: How to return resultset from MySQL Stor
@str;
execute stmt;
deallocate prepare stmt;
-Original Message-
From: Girish Talluru [mailto:girish.dev1...@gmail.com]
Sent: Tuesday, February 12, 2013 1:37 AM
To: mysql@lists.mysql.com
Subject: Please check the stored procedure
DROP PROCEDURE IF EXISTS Cursor_Test;# MyS
Rather than trying to reinvent the wheel, I was wondering if anyone might
have a stored procedure already for what I want to do.
I want to start with 4 characters using any unique combo and when all
unique matches are used, it will move to 5 characters and so on.
For example in any random order
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
ion which might possibly lead to days of execution.
I have figured out that the php script does wait for the record to execute
and then only after it it will process the next record. For this if it is
java I should have used stored procedure and multithreading concept to run
multiple threads i
ANN: Hopper, version 1.0.3 released
Dear ladies and gentlemen,
Upscene Productions is proud to announce version 1.0.3 of our
product called "Hopper".
Hopper is a Windows-based Stored Routine and Trigger Debugger,
available for InterBase, Firebird and MySQL.
This version fixes an imporant er
Hello Jan, others,
I do find your juvenile
comments about worshipping, changing product names etc just that.
Ah, you must be from the marketing department -- always willing to make
friends and influence people.
Please, Jan, I'm obviously not, I'm but a simple programmer. And given the
fact
> I do find your juvenile
> comments about worshipping, changing product names etc just that.
Ah, you must be from the marketing department -- always willing to make friends
and influence people.
In examinations, the foolish ask questions that the wise cannot answer. --
Oscar W
Hello Jan,
Can you PLEASE note in your listing when a product is Microsloth-only?
While you're at it, can you PLEASE note it prominently on your website? I
looked through your product description and saw >no specific requirements
beyond what databases were supported. It wasn't until I tried
Can you PLEASE note in your listing when a product is Microsloth-only?
While you're at it, can you PLEASE note it prominently on your website? I
looked through your product description and saw no specific requirements beyond
what databases were supported. It wasn't until I tried to download it t
ANN: Hopper, version 1.0.1 released
Dear ladies and gentlemen,
Upscene Productions is proud to announce version 1 of a new
product called "Hopper".
Hopper is a Stored Routine and Trigger Debugger, available for
InterBase, Firebird and MySQL.
For more information, see
http://www.upscene.co
On 10 Mar, 2012, at 7:06 pm, Cifer Lee wrote:
> when we call procedure
> normally we declare the parameter out of the procedure and pass the
> variable to procedure
> like this
>
> set @x=1;
> call *a_procedure*(@x);
>
> why can not directly pass the digit 1 to the* a_procedure* ?
You can pa
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",
Hi all,
As you probably now, we created "Database Workbench", a developer
tool for MySQL and other DBMSses.
This tool includes a Stored Routine Debugger for several DBMSses,
including Firebird and InterBase, but not MySQL.
Both Firebird and InterBase do not provide a debugging API, so our
too
yes
2011/10/4 Paul Nickerson
> You need a space before the word VALUES
>
> --
> *From: *"Adam Gerson"
> *To: *"luiz rodrigo mottin"
> *Cc: *mysql@lists.mysql.com
> *Sent: *Tuesday, October 4, 2011 6:00:24 PM
>
Thanks Luiz,
That got me closer. I was able to save the stored proc. It should be
execute stm; not execute @sql; right?
I get this when I try to execute it:
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near ''
you can use:
set @sql = concat( "INSERT INTO ", TABLENAME, "VALUES ('309', '0',
'statpress_mincap', 'edit_posts', 'yes')");
prepare stm from @sql;
execute @sql;
2011/10/4 Adam Gerson
> I am getting the error that "TABLENAME" does not exist. How do I get it to
> substitute the value stored in TAB
On 10/4/2011 4:20 PM, Adam Gerson wrote:
I am getting the error that "TABLENAME" does not exist. How do I get
it to substitute the value stored in TABLENAME, and not the literal
string?
See the manual page for PREPARE.
PB
-
begin
declare v_max int unsigned default 1;
declare v_counter
I am getting the error that "TABLENAME" does not exist. How do I get it
to substitute the value stored in TABLENAME, and not the literal string?
begin
declare v_max int unsigned default 1;
declare v_counter int unsigned default 21;
declare TABLENAME text;
start transaction;
while v_counter
-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 parameters
2. SELECTS 1 record (LIMIT 1) from a table where the 4 parameters match fields
in that table
a. If a record was
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. Acce
Hello all,
I would like to create a stored procedure that does the following:
1. Accepts 4 values as parameters
2. SELECTS 1 record (LIMIT 1) from a table where the 4 parameters match fields
in that table
a. If a record was returned then UPDATE the table
b. If a record was not
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" > <mailto:nixofort...@googlemail.com>> wrote:
>>
>> Hi all,
>> I can't explain strange behaviour
rying 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.
> Th
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
procedu
Hi all,
I can't explain strange behaviour of the INSERT statement in the stored
procedure.
The idea is to generate a list based on the output of 3 INNER JOIN of
regularly updated tables.
Something like :
INSERT INTO storage
(column list)
SELECT
column list
FROM t1 JOIN t2
ON t1.x=t2.y
JOIN
in my database. My problem is that I am not
able to use this simple code within the stored procedure. To overcome
this, I iterate through the table following the order defined by the
columns datumtijd and number. The code which I use to rank the table
within the stored procedure is this
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
On 1/5/2011 13:31, James Dekker wrote:
Because some sequence tables contain one to many cardinality and MySQL tables
can only have one auto_increment column...
Is there a way to do what I am trying to do (obtain max sequence id, set it to
its corresponding table, and then increment by one) in
Because some sequence tables contain one to many cardinality and MySQL tables
can only have one auto_increment column...
Is there a way to do what I am trying to do (obtain max sequence id, set it to
its corresponding table, and then increment by one) in a stored function?
Happy programming,
J
On 1/4/2011 23:23, James Dekker wrote:
Peter,
Thanks for the response!
Unfortunately, that worked but a new error arose:
check the manual that corresponds to your MySQL server version for the right
syntax to use near 'ID = (select max(CONVERT(id_field, signed)) from
my_table_t)' at line 1
I
%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
Good day all
I am hoping that someone can assist me here.
As per a client requirement, I am writing a
script/stored procedure combination in order to do the following:
- Script to be run within a cron once a day
according to a set schedule
ils):
>>
>> -- Get dynamically incremented id
>> generate_dynamic_id('my_sequence_id_s', 'my_table_t', 'table_id',
>> @dynamicId);
>>
>> Error:
>>
>> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You ha
ysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your
SQL syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near 'generate_dynamic_id('my_sequence_id_s',
'my_table_t', 'table_id', @dyn'
1.
---------
For some odd reason, dynamic function calls are not allowed in Stored Functions
or Triggers, so that's why a Stored Procedure was used.
As you can see, I am setting up varchars at the parameters and then trying to
concatenate
=b");
PREPARE stmt FROM @s;
EXECUTE stmt;
regards,
nilnandan
DAREKAR, NAYAN (NAYAN) wrote:
Hi all !
I m getting an error while writing stored procedure, the code is as below and
error
CODE
--
DELIMITER
Hi all !
I m getting an error while writing stored procedure, the code is as below and
error
CODE
--
DELIMITER $$
DROP PROCEDURE IF EXISTS `aaa` $$
CREATE definer=`ro...@`%<mailto:definer=
ge-
> > From: Sabika Gmail [mailto:sabika.makhd...@gmail.com]
> > Sent: Monday, June 07, 2010 11:14 AM
> > To: mysql@lists.mysql.com
> > Subject: Replication of MySQL Stored Procedure
> >
> > Hi!
> >
> > I have a database in the wild ignore t
@logicworks.net
>> http://www.linkedin.com/in/rolandoedwards
>>
>>
>> -Original Message-
>> From: Sabika Gmail [mailto:sabika.makhd...@gmail.com]
>> Sent: Monday, June 07, 2010 11:14 AM
>> To: mysql@lists.mysql.com
>> Subject: Replication of MySQL Stored Pro
inal Message-
From: Sabika Gmail [mailto:sabika.makhd...@gmail.com]
Sent: Monday, June 07, 2010 11:14 AM
To: mysql@lists.mysql.com
Subject: Replication of MySQL Stored Procedure
Hi!
I have a database in the wild ignore table as table.%. Recently I
created a store procedure on it and it replicated.
-660-3221 (Cell)
AIM & Skype : RolandoLogicWorx
redwa...@logicworks.net
http://www.linkedin.com/in/rolandoedwards
-Original Message-
From: Sabika Gmail [mailto:sabika.makhd...@gmail.com]
Sent: Monday, June 07, 2010 11:14 AM
To: mysql@lists.mysql.com
Subject: Replication of MySQL St
Hi!
I have a database in the wild ignore table as table.%. Recently I
created a store procedure on it and it replicated. Does any one know
if this is normal bahvior? If I wanted to make sure store procedures
do not replicate, what should I do?
--
MySQL General Mailing List
For list archiv
ute(); //obtain
resultsetResultSet result = cs.getResultSet(); //Iterate
to get the resultSet, if present //commit transactionconn.commit(); //close resultset, callableStatementresult.close();cs.close(); But, can it be a problem if
I am executing a stored procedure anywhere? Well, I am not aware of
Dear Venugopal, Here's the Sample Java Code Which Calls
stored procedure :- //get the connection to databaseConnection dbConnection = getConnection(); //create the call
for procedureString procedureCallStmtStr = "Call XYZ()"; //create callable statement objectCalla
: Strange behavior by MySQL Stored Procedure
To: mysql@lists.mysql.com
Date: Friday, 28 May, 2010, 5:44 PM
Dear All,
I have one stored procedure Which inserts data into one table.
But sometimes it does not insert record. This happens when I called it from
java application. But If I called same
mysql Version :- 5.1.42-community-log
mysql Connector/J Version :- mysql-connector-java-5.1.6-bin.jar
Sample Java Code Which Calls stored procedure :-
//get the connection to database
Connection dbConnection = getConnection();
//create the call for procedure
String procedureCallStmtStr
few records from the query
executed.
Cheers,
Anirudh Sundar
9594506474
DataVail Mumbai.
On Fri, May 28, 2010 at 5:44 PM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Dear All,
>
> I have one stored procedure Which inserts data into one table.
>
> But sometim
2010/5/28 Manasi Save :
[...]
> Or am I doing something wrong?
probably;
you better send us another e-mail writing at least:
- mysql version you are using
- mysql Connector/J version you are using
- piece of java code you are using to call the stored procedure
- source of the stored procedure
Dear All,
I have one stored procedure Which inserts data into one table.
But sometimes it does not insert record. This happens when I called it from java
application. But If I called same query from mysql command line. It executes
successfully.
Also I have one procedure which only retrieves
Hi All,I want to find out number of lines are there in
all stored procedure written.Is it possible to get the
number of lines using a SQL query.Thanks in advance.
--
Regards,
Manasi Save
Hi there,
I have a WEIRD question, that I can't find an answer too...
Here is my stored function:
DELIMITER $$
USE `mydatabase`$$
DROP FUNCTION IF EXISTS `SPLIT_STR`$$
CREATE definer=`thisus...@`%` FUNCTION `SPLIT_STR`(
X VARCHAR(255),
delim VARCHAR(12),
pos INT
) RETURNS VARCHAR(255) CH
> -Original Message-
> From: Walton Hoops [mailto:wal...@vyper.hopto.org]
> Hi all.
> I am running into a very frustrating problem trying to created a stored
> procedure.
>
> I had originally assumed I was using bad syntax, but even examples
> copied
> and pa
avin Towey
-Original Message-
From: Walton Hoops [mailto:wal...@vyper.hopto.org]
Sent: Wednesday, December 16, 2009 10:46 AM
To: mysql@lists.mysql.com
Subject: Cannot created stored procedure (Using example from mysql manual) --
mysql 5.1.37 -- Ubuntu 9.10
Hi all.
I am running into a very f
Hi all.
I am running into a very frustrating problem trying to created a stored
procedure.
I had originally assumed I was using bad syntax, but even examples copied
and pasted
directly from the manual are giving the same error.
mysql> CREATE DEFINER = 'walton'@'lo
ELECT version();
+--+
| version()|
+--+
| 5.1.41-community |
+--+
1 row in set (0.00 sec)
Here is my stored procedure:
8<
CREATE PROCEDURE `test_massage_table`(IN in_table_name VARCHAR(64))
NOT DETERMINISTIC
To: mysql@lists.mysql.com
Subject: stored procedure and random table name -> temp table, merge, prepared
statement
All,
I have a stored procedure that I'm writing where I need to run a lot of
queries against a particular table. The name of the table will be a
parameter to the stored procedure
All,
I have a stored procedure that I'm writing where I need to run a lot of
queries against a particular table. The name of the table will be a
parameter to the stored procedure ... example:
CALL normalize_data('name_of_table_here');
Since I want to run queries against this
Steve:
> I suppose maybe making this a slave table
> to the other
> server... nah... lots of work there
Setting your local server to be a slave of the
remote server is not too hard and would
be a MUCH better solution.
The steps are fairly staightforward:
1. Add a slave user to the remote datab
elect from remote server from stored procedure
Hello Johan,
On Dec 9, 2009, at 11:22 AM, Johan De Meersman wrote:
> Posted this before, but beware: federated tables do NOT use indices.
> Every
> select is a full table scan, and if you're talking about a logging
> table
> that co
hould be fine.
It is still not as fast as local access, but it's not as bad as always
doing a full table scan remotely.
On Wed, Dec 9, 2009 at 4:13 PM, Neil Aggarwal
wrote:
Is this possible to do? To make a connection, inside the
stored procedure
to a completely different machine
connection, inside the
> > stored procedure
> > to a completely different machine and access the mysql there?
>
> The only way I know to access tables from different servers
> from a single connection is federated tables:
> http://dev.mysql.com/doc/refman/5.0/en/federated-use
> Is this possible to do? To make a connection, inside the
> stored procedure
> to a completely different machine and access the mysql there?
The only way I know to access tables from different servers
from a single connection is federated tables:
http://dev.mysql.com/doc/refm
Ok, I feel silly for asking this, but I am going to do it anyway.
I have a huge stored procedure that does quite a bit of logic, and
gathering/splitting of data. I currently have our customer database on one
server, and our logging on another. What i need to do, is to pull the
customer id from
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
Hello,
I would like to do a select on a table to get back the IDs of some of
the records.
Then take those IDs and do a single update using a WHERE clause like
(recordID IN (2,44,21))
My question is:
Can I build a string using a cursor that has all of the IDs and then
issue an update using the s
Hello Mauricio,
Mauricio Tellez wrote:
Hi, I'm trying to debug a stored procedure. This SP has a few queries and
also call another SP. I'm starting mysql with the --log=my_queries.log but I
found that mysql only log the "call my_sp(param1, param2)" but don't log any
q
Hi, I'm trying to debug a stored procedure. This SP has a few queries and
also call another SP. I'm starting mysql with the --log=my_queries.log but I
found that mysql only log the "call my_sp(param1, param2)" but don't log any
query inside my_sp neither log the nested SP
hai shawn green,
thanks for ur response.My situation is to generate a production
plan.for this I collect the data from sales orders and compare the stock
availability in rthe warehouse and if the stock is less than the ordered
quantity I plan for production and for this I have to issue t
syed basha wrote:
delimiter //
create procedure sample1(in p_item varchar(30),
in p_size varchar(6),
in p_quantity decimal(10,3),
in p_unit varchar(3),
in p_autoincrement varchar(30),
out v_mess varchar(50)
)
begin
declare done int default 0;
declare v_bhqty decimal(10,3);
decl
delimiter //
create procedure sample1(in p_item varchar(30),
in p_size varchar(6),
in p_quantity decimal(10,3),
in p_unit varchar(3),
in p_autoincrement varchar(30),
out v_mess varchar(50)
)
begin
declare done int default 0;
declare v_bhqty decimal(10,3);
declare v_bhunit varchar
+
| database() |
++
| mysql |
++
However, if the database function is invoked from within a stored procedure,
it only returns the name of the database in which it exists:
use scratch;
delimiter $$
create procedure thisdb()
begin
select database();
end$$
delimiter ;
use s
cedures, but I don't see that it
>> records calls made to one procedure from within another.
>>
>> On Wed, Mar 18, 2009 at 6:42 AM, Claudio Nanni
>> > claudio.na...@gmail.com>> wrote:
>>
>>Hello Jim,
>>
>>If I unserstand well your ne
If I unserstand well your needs the steps you need to do are:
Create one user X with insert privileges on the mydb.audit_table
Create the stored procedure specifying the user X both in the
DEFINER section and in the SQL_SECURITY section
of the create procedure statement
hin another.
On Wed, Mar 18, 2009 at 6:42 AM, Claudio Nanni wrote:
> Hello Jim,
>
> If I unserstand well your needs the steps you need to do are:
>
> Create one user X with insert privileges on the mydb.audit_table
>
> Create the stored procedure specifying the user X both in
Hello Jim,
If I unserstand well your needs the steps you need to do are:
Create one user X with insert privileges on the mydb.audit_table
Create the stored procedure specifying the user X both in the DEFINER
section and in the SQL_SECURITY section
of the create procedure statement (
http
I am writing a tracking procedure that will be inserted into every procedure
(regardless of who writes the procedure) that will insert a record into an
audit table. This means the procedure, regardless of who writes it, must
have the permission to insert into the table. I am going to modify the c
Sender. This transmission is of a confidential nature and Sender does not
endorse distribution to any party other than intended recipient. Sender does
not necessarily endorse content contained within this transmission.
> Date: Mon, 26 Jan 2009 11:01:58 -0600
> Subject: how can trace
I am trying to track the usage of stored procedures on our system. My
solution so far is to parse the general log for "call" queries. This works
well for procedures that are called from the command line, but the general
log does not seem to report procedures called from within other procedures.
Hi
Is there a way to write a stored procedure that returns a result set
containing multiple rows? More specifically, I'm trying to return the
multi-row result set as an OUT parameter, which I can then access via a
session variable. If this is possible, could someone direct me t
1 - 100 of 354 matches
Mail list logo
