FLUSH table ??
Quoting Peter Lauri [EMAIL PROTECTED]:
DELETE FROM table
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 20, 2006 10:35 AM
To: mysql@lists.mysql.com
Subject: How to delete all rows
Hi All,
Quoting Ciprian Vizitiu [EMAIL PROTECTED]:
On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote:
Hi Chris,
I've noticed that a Ctrl-C will also leave the query
running (5.0.22 -
Linux) and I've had to use the kill from mysqladmin or
mysql client to
get rid
Quoting Barry [EMAIL PROTECTED]:
Ben Clewett schrieb:
Hi Barry,
This will happen when comparing against a TIMESTAMP field.
CREATE TABLE a ( t TIMESTAMP );
SELECT * FROM a WHERE t '0001-01-01 00:00:00';
Well my msql doesn't give me any errors using that query.
neither a
Isn't UUID() unique for each system it runs on??
--
Chris
Quoting Dan Buettner [EMAIL PROTECTED]:
Neeraj -
One idea might be to use both a client ID field and a record ID field to
uniquely identify records. This approach has benefits (easy to add
clients, doesn't require as much