Good Day once again.
Im needing assistance again with triggers!
Create Trigger hostchange
BEFORE UPDATE ON host
FOR EACH ROW
BEGIN
IF NEW.status != OLD.status THEN
use smsgw;
insert into outbox (number, insertdate, text, phone, dreport) VALUES
('0836075144', '', 'HostDown', '1', '1
>In the last episode (Jul 07), Marcel Grandemange said:
> I hope someone can assist me. I have a freeradius server running off
> mysql. Now I would like to use triggers to negate some of the traffic
> logged within it. I tried to use following as trigger..
>
> Create Tr
om Freeradius.
I have managed to get triggers working to a separate db altogether but not
from the same db to the same db.
What am I doing wrong?
Regards.
Marcel Grandemange
>>WHat errors are you getting when you try and start the slave?
>
> That's the exact thing
>
> mysql> show slave status\G
> *** 1. row ***
> Slave_IO_State: Waiting for master to send event
>Master_Host: 192.168.11.252
ortune wrote:
>
> Hi,
>
> On Mon, Dec 8, 2008 at 9:20 AM, Marcel Grandemange
> wrote:
> >>WHat errors are you getting when you try and start the slave?
> >
> > That's the exact thing
> >
> > mysql> show slave status\G
> > **
>WHat errors are you getting when you try and start the slave?
That's the exact thing
mysql> show slave status\G
*** 1. row ***
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.11.252
Good Day.
Im wondering if someone can assist me.
Ive been using replication for a while now and it tends to fail very easily.
One of my sites lost connectivity for a while and when it came back
obviously replication broke again.
How can I get it to populate all data from master again?
Load dat
o keep all the
logic within the SQL statement since it is just one within a huge selection
of queries. A performance penalty shouldn't be a problem, since this whole
query will only be called once a day at 3 or 4 AM to generate a file.
Thank you
Marcel
PS: a simple example
I will
Sorry, I missed the last part of your email.
Try:
SELECT * FROM products p, uses u, prod_uses pu WHERE p.pid=pu.pid AND
u.uid=pu.uid AND uses='use 1';
:-)
- Original Message -
From: "Marcel Forget" <[EMAIL PROTECTED]>
To: "Mikey" <[EMAIL PROTECTE
es varchar(25) YES (NULL)
prod_uses
pid int(11) 0
uid int(11) 0
I hope this works out for you.
Marcel
- Original Message -
From: "Mikey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 29, 2003 12:54 PM
Subject: SELECT from multiple tables...
>
Try:
select name, birthday from atable where month(birthday)=month(now()) and
dayofmonth(birthday)=dayofmonth(now());
Marcel
- Original Message -
From: "Scott Haneda" <[EMAIL PROTECTED]>
To: "MySql" <[EMAIL PROTECTED]>
Sent: Tuesday, May 27, 2003 10:2
Hi all,
How is the best tool for acess Mysql By SSL protocol ?
---
Marcel P. Tardelli
DBA - DBLive Corp.
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-
Before posting, please check:
In Mysql I can have tables in one HD and Index and other Like Oracle ??
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
Hi,
In Oracle i use TO_NUMBER to convert a String to a Number what Function Do i
have to use in Mysql ??
thank´s
Marcel.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
our help please ?
###
Marcel Bariou => [EMAIL PROTECTED]
Thank for your interest -- Merci pour votre attention
###
15 matches
Mail list logo
