RE: How to delete all rows....

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

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 cli

Re: DateTime limits

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 tha

Re: How to get machine independent unique id??

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