Re: Row Number

,] rows] [PROCEDURE procedure_name] [FOR UPDATE | LOCK IN SHARE MODE]] So, LIMIT 10 ... means first 10 rows (or LIMIT 0, 10) LIMIT 10, 10 ... means next 10 rows LIMIT 20, 10 ... means ... etc Best wishes, Paul Najman [EMAIL PROTECTED] - Original Message - From

Re: database copy

) on the external server and then transfer it from there to the other PC. If this doesn't make much sense to you, let me know! Best wishes, Paul Najman - Original Message - From: Fabio Bernardo [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 4:12 PM Subject

Re(2): database copy

Fabio, I've just looked at MySQL CC properly for the first time and it doesn't seem to have any import/export options. I use MySQL-Front, which does. You can get the latest release from http://mysqlfront.venturemedia.de/ . Best wishes, Paul Najman [EMAIL PROTECTED] - Original Message

Re: Why does auto increment not take into account deleted rows?

' is not really associated with the record. Best wishes, Paul Najman [EMAIL PROTECTED] - Original Message - From: Daniel Crompton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 02, 2003 5:18 PM Subject: Why does auto increment not take into account deleted rows? I have one

Re: database newbie

means is that you cannot have, for example, two 1's in the same primary key. Trying to insert a new 1 will cause an error. But, if you've chosen it to be auto_increment, then this shouldn't be a problem. Hope that helps. Best wishes, Paul Najman [EMAIL PROTECTED] - Original Message - From