Hi,
I'm sure this must've been done before, so if someone can point me at a
discussion or assist me in some other way I'd appreciate it.
If I'm browsing a paged list of invoices say in numerical order and I
then want to reposition the list on a certain client, I can do a second
query to the
I could be wrong but I think your problem is the unique index.
--
João Cândido de Souza Neto
"robert rottermann" escreveu na mensagem
news:4dd967a8.5040...@redcor.ch...
> Hi there,
>
> I would like to create a table that optionally links to an other table.
>
> The field company_id in the fol
Hi Everyone
I have posted this question quite a while back and noticed now
that I haven't gotten an answer as yet and this is still on my
unresolved list.
We have 2 tables which we want to archive data from.
We need to be able to delete all data from the 2 tables that is
A simple stored procedure run by the event scheduler at predetermined times
will do this quite easily. Can you post the output of SHOW CREATE TABLE for
your two tables?
John
On 23 May 2011 13:15, Machiel Richards wrote:
> Hi Everyone
>
>I have posted this question quite a while back and
Quoting Machiel Richards :
We need to be able to delete all data from the 2 tables that is
older than the start of yesterday.
Hi,
I use this ver simple script to purge data from a syslog DB:
#!/usr/local/bin/bash
/usr/local/bin/mysql -u syslog -pmypasswd -e 'DELETE FROM Syst
Here’s an email from a good friend of mine that may be of interest. It is done
in Ruby.
From: Brad Robel-Forrest [mailto:b...@gigglewax.com]
Sent: Sunday, May 15, 2011 7:01 PM
To: Daevid Vincent
Subject: MySQL shell...with parameters
Remember a long while back I was bitching about the need fo
