[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
On 15/02/12 17:03, Philip Hudson wrote: > Can you derive fname uniquely using prefix ÂÂ systime? Or is that not > the issue? The issue is writing to a specific file, not deriving the name. I think this is a security feature in that you can't get the database user to overwrite arbitrary files by mangling the content of a database. I'm abandoning that approach for something which will performance better. 1) On trigger store actions in a queue table. 2) Separately have a MYSQL event to process the queue table. At which point I can rely on the process eating the files to eat them fast enough to reuse the same file name. I don't like MySQL triggers, too fiddly, and the documentation is a bit odd in places. However part of my issues stem from the wrong platform, since this is actually on Windows, and I just aren't familiar enough with compiling stuff here to build my own UDF from source and lack the motivation. -- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/listfaq