I believe the syntax is Delete from MyTable Where MyCriteria LIMIT HowMany.
God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web technologies. GOD BLESS AMERICA! To God Be The Glory! -----Original Message----- From: Manisha Sathe [mailto:[EMAIL PROTECTED] Sent: Monday, August 23, 2004 6:08 AM To: [EMAIL PROTECTED] Subject: How to delete records after particular position ? Hi, Here i am again. I can select particular record by using LIMIT 9,1 But e.g. if i want to delete this record then how shall i do ? I tried to use Delete from <table name> Limit 9, 1 But i am getting erorr. pls can anybody let me know the exact syntax for this ? regards Manisha -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
