whole resul

and that's right

yes but how can i get the whore result for further working on it ?

think a second how SELECT … INTO a; would make sense with more than one row
CURSOR + LOOP + FETCH INTO

can you give me an example

http://jan.kneschke.de/projects/mysql/sp/ is full of it

ok thx very much have a nice day

could i get help with a trigger, please?

just ask

http://www.pastebin.ca/623111 is not working properly.
it works fine in the test environment 5.0.45 but does not write every change in the same version on the production machine.
the difference between teh two is that the production machine is incrementing by 10s instead of 1s for replication purposes

what exactly is happening and what do you expect to happen ?

when the member table is updated this trigger is supposed to create a record for every field changed.

could you trace it down to specific statements which are not execute the trigger ?

on the production machine it will, intermittently, write only one value or none if there is only one change, or only a few of multi changes

and did you check that you don't run into a rollback ?

so, if i change my lname in the table, sometimes the trigger will write it, and sometimes not.
if i change my fname, lname, address, it might do the first or the second, but not all.

please show me a log (binlog or generallog) which shows it
what is the storage engine of spp_auditlog ?

checking re the logs
myISAM

on both machines ?

let me check.
yes, the storage engines are both the same.

please add a 2nd table to the TRIGGER which logs every execution
INSERT INTO spp_calllog VALUES ( NOW(), … )

*chuckle*
MyBS stands for "BLOB Streaming for MySQL"

my first thought: Paul, MyBS is a bad name

could you give me the whole statement (sorry!)?
wait, i have someone helping. thanks.

lol yes true

the binlog file is very large.

MyBullShit

what do you need to particularly?
to see, i mean.

wtf is proxyscan.freenode.net all about?
my firewall just got nailed by it

you should try to reproduce it on a machine which is equivalent to your production machine, but without the load
your test machine has a slightly different configuration you said
as the name says
it checks at login to the irc-server if you are a evil-bot

o ok thx
im evil

the load on the production machine is very low.
current load avg is zero.

call FLUSH LOGS; and it will rotate the binlogs
try your experiment afterwards again

i have the binlog file. it is big; should i look for anything in particular?
ok.
will do.

hmm, but I think you won't see result of the trigger in the binlog as you use Statement based execution

ok.

the trigger will be executed on the master and on the slave

admin is not keeping generallog

I'm running out of ideas how to track it

ok. going to work on the new trigger.
how to enable generallog?

general log contain everything the server receive, trigger is not likely to be there

ok.

hi, all
can i write a sql hosting that get a field name or table name of any database in MySql like oracle do, select field_name from XYZ where T1 = 'ABC' where T1 is a table name and XYZ is the database name

show fields from 'table' like 'field'

!m SAMXYZ information schema

SAMXYZ see http://dev.mysql.com/doc/refman/5.0/en/information-schema.html

show columns from {$table} like \"$field\"