is only the session? I want a
stored
procedure to avoid some sql in clientside code...Or do you mean a prep
in
the stored?
/Jon
On 7/25/06, Burke, Dan <[EMAIL PROTECTED]> wrote:
>
>
> If I understand correctly, what you need is prepared statements.
>
> http://dev.mysql.
If I understand correctly, what you need is prepared statements.
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.c
I have been using this set of functions to do sequences, especially for
tables where AUTO_INCREMENT can be inconvenient. Maybe it will help you
over just incrementing the ID by 1 in your code.
I based them on the DBIx::MysqlSequence perl module
http://brazil.addictmud.org/wiki/index.php/MySQL_Se
> At 10:20 AM 6/8/2006, you wrote:
> >Hi,
> >
> >I am trying to import a 3.2Gb sql dump file back into my sql server
> (4.1.12)
> >and im coming across the following error:
> >
> >mysql: Out of memory (Needed 178723240 bytes)
> >mysql: Out of memory (Needed 178719144 bytes)
> >
> >That error come
http://nagios.org
We use that to monitor dozens of servers, over 1000 individual items
(disk space, web server up/down, etc). We also do some heavy monitoring
of oracle databases and some moderate mysql monitoring. It can be
easily adapted to do what you want. And it's free!
Dan.
-Origi
I'm not sure what version of MySQL you're running, but might it be
possible to put a trigger on the tables in the slave DB to insert
deleted records into another table?
I've done such things for large tables that need trimmed from time to
time, but I need to save the old data for archival. But
I've done similar things with sequences. This method is borrowed from
the DBIx::MySQLSequence perl module (the _sequences table can contain
many sequences, named in the "sequence_name" field):
update _sequences set
sequence_value = LAST_INSERT_ID(sequence_value + 1)
where sequence_name
e END REPEAT;
CLOSE cur1;
END; //
delimiter ;
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 18, 2006 2:16 PM
To: Burke, Dan
Cc: mysql@lists.mysql.com
Subject: Re: Procedure / Prepared statements error converting table
"Burke,
I tried using prepared statements to make a procedure that converts
every table in a schema from ARCHIVE to MyISAM (there's about three
dozen archive tables here). But for some odd reason it will give an
error after doing the first table, and abort. The really odd thing is
that the table it give
To: mysql@lists.mysql.com
Subject: RE: Triggers that handle multiple events (insert and update)
onsdagen den 9 november 2005 18:07 skrev Burke, Dan:
> For example, one field has to be >= 0, so I put this validation
Why don't you just declare that field as unsigned?
Björn Persson
--
MySQL
o:[EMAIL PROTECTED]
Sent: Wednesday, November 09, 2005 9:59 AM
To: Burke, Dan
Cc: mysql@lists.mysql.com
Subject: Re: Triggers that handle multiple events (insert and update)
"Burke, Dan" <[EMAIL PROTECTED]> wrote on 11/09/2005 09:05:50 AM:
> Hello,
>
> Can triggers in 5.0 h
Hello,
Can triggers in 5.0 handle multiple events? I have some range checking
I'd like to enforce at the database level when inserting or updating a
record, and I'm finding myself duplicating trigger code to make an
INSERT and an UPDATE trigger, which makes it harder to maintain in the
long run,
This is really cool! Can something be done with this to use a
materialized view log on a table in Oracle and sync with a table in
mysql?
-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]
Sent: Friday, September 16, 2005 9:54 AM
To: mysql@lists.mysql.com
Subject: RE: databas
Has anyone tried using the embedded server with MySQL 5.0 yet? I have
an application that I'm anxious to take advantage of triggers with.
It's not a money maker, so it's no big deal if it has a few quirks, but
if it's just totally a "bad idea" right now, I won't risk it.
The main reason I'm consi
ully obvious reasons, I don't use Oracle for personal projects, so
triggers are a feature I've longed for in MySQL.
Dan.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 25, 2005 4:16 PM
To: Burke, Dan
Cc: mysql@lists.
rrent PL/SQL triggers, this is just the most basic example. I'm
getting the feeling I'm pretty rare in this situation.
Thanks,
Dan.
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Friday, August 19, 2005 10:52 AM
To: Burke, Dan
Cc: mysql@lists.mysql.com
Su
Hello,
I've been looking into converting our existing Oracle PL/SQL code to mysql. A
lot of the syntax is pretty straight forward, and really doesn't require much
change from what I've been testing with thus far. However, I'm trying to
handle exceptions, and I cannot seem to find any docume
17 matches
Mail list logo