RE: Triggers For Radius DB

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 Trigger ftp BEFORE UPDATE

Another Trigger Question!

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',

Triggers For Radius DB

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

RE: Replication

wrote: Hi, On Mon, Dec 8, 2008 at 9:20 AM, Marcel Grandemange thavi...@thavinci.za.net wrote: WHat errors are you getting when you try and start the slave? That's the exact thing mysql show slave status\G *** 1. row

RE: Replication

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

RE: Replication

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

Replication

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

combining rows

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 try to show

Re: SELECT from multiple tables...

(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... Hi NG, this is my first visit here, so

Re: SELECT from multiple tables...

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 PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, May 29

Re: Select name, email where birthday = ??

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:20 PM Subject: Select name, email where

SSL

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: http

Tables and Indexes

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

STRING TO NUMBER

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

big-tables option = Your help

? ### Marcel Bariou = [EMAIL PROTECTED] Thank for your interest -- Merci pour votre attention ###