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

How to get the last record from the slected record set

in advance, regards Manisha

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: Manisha Sathe

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 the last record from the slected record set

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 last record from the slected record set --On 22

Compare dates

some different combinations but in not successful. regards, manisha

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: Manisha Sathe [EMAIL

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, 2003 10:56 PM Subject: Re: PASSWORD() function problem Hi, If I

PASSWORD() function problem

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

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); if ($conn){ mysql_select_db (demo); echo

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

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's

Re: Facing some problem in installation

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 --prefix you supplied to ./configure ? I'd say install as root

Facing some problem in installation

/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, please check: http

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://hostname/sqladmin using GUI then MySql is giving