RE: How to delete all rows....

2006-09-20 Thread cknipe
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,

RE: Aborting a greedy querry from the command line

2006-06-20 Thread cknipe
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

Re: DateTime limits

2006-06-06 Thread cknipe
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

Re: How to get machine independent unique id??

2006-06-01 Thread cknipe
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