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 Limit 9, 1 But i am getting erorr. pls can anybody let me know the exact syntax for this ? regards Manisha

Re: How to get the last record from the slected record set - Thanks

Thanks to all of, I could get it Thanks Manisha - Original Message - From: "Karl Pielorz" <[EMAIL PROTECTED]> To: "Manisha Sathe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, August 23, 2004 9:52 PM Subject: Re: How to get the l

Re: How to get the last record from the slected record set

yes, but is there any better way of doing it ? regards Manisha - Original Message - From: "Karl Pielorz" <[EMAIL PROTECTED]> To: "Manisha Sathe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, August 23, 2004 8:34 PM Subject: Re: How to get t

Re: How to get the last record from the slected record set

I want to select first 10 records out of 100. And then get the 10th position. If i make use of order by score asc limit 1 then I will get 100th record, How shall i pick up 10th position? regards Manisha - Original Message - From: "Karl Pielorz" <[EMAIL PROTECTED]> To

How to get the last record from the slected record set

advance, regards Manisha

Compare dates

? I tried some different combinations but in not successful. regards, manisha

Re: PASSWORD() function problem

Thanks all, it helped me a lot Manisha - Original Message - From: "Director General: NEFACOMP" <[EMAIL PROTECTED]> To: "Nitin" <[EMAIL PROTECTED]>; "Manisha Sathe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, October 16,

Re: PASSWORD() function problem

thanks all, it works (i just increase it to 20) but one more thing, now if i want to get this password (e.g for option forget password), can we retrieve, i believe we can not- just want to confirm manisha - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To

PASSWORD() function problem

result. please help me. what's going wrong ? Thanks in advance Manisha

Re: Want to create mySQL user through phpMyAdmin

oh! god! - Thanks a lot, I have a root access and with that I could create a user directly from command line. I was thinking that thr phpMyAdmin 2.1.0 I can do it (New version can - but seems not this version) Thanks once again Manisha At 10:21 PM 12/8/02 -0500, Joe Stump wrote: It'

Re: Want to create mySQL user through phpMyAdmin

I am using phpMyAdmin 2.1.0. I created user from this (mysql.user) but do not know how to reload it ? I am not finding any such option on it. Can u please tell me more about it. Thanks, Manisha At 09:45 PM 12/8/02 -0500, Joe Stump wrote: Did you reload the privileges? --Joe On Sunday

Want to create mySQL user through phpMyAdmin

I want to create mySQL user thr phpMyAdmin. I inserted one record in mysql.user table and one in mysql.db table, testing with following program $conn = @mysql_connect ("localhost:/usr/home/nets/mysql/mysql-demo.sock", "manisha", "pass"); echo("before conn a&qu

Re: Facing some problem in installation

all I check ? Thanks and regards Manisha At 11:22 AM 7/25/02 +0200, you wrote: >Hello! > >Barnali wrote: > >>If you are NOT installing as root, you are trying to create mysql.sock in >>an area where >>you don't have write permission. >>what is the --pre

Facing some problem in installation

with database from /usr/home/mysql-src/mysql-/data rm /tmp/mysql.sock - Operation not permitted mysqld end Can anybody help me in this matter - What is the meaning of it ? Thanks and regards Manisha - Before posting, ple

URGENT - problem in inserting single quote

I am inserting into the table values with single Quote (MySql table). If I give the command through text file - Insert into test values ('manisha\' test') - then this is ok, but when i try to insert the manisha ' test value through http:///sqladmin using GUI then MySql is