Abhishek Sahay writes: > Dear Sir/Mam, > > I m frequently user of Mysql as back end and PHP3 as fromt end.Sir/mam I > have some problem in delete statement . > 1.If I want to delete a particular record like record no 10.then how > can I delete? You should have a column, like auto_increment, or some other PRIMARY KEY. Then you can uniquely identify each row !!! > 2.Like statement gives a particular record > ex- select * from tablename like 2; > select * from tablename like 2,5; > through this statemt I can pick a range of record.But suppose I m having > 1000 record in a table and if i wanted to delete record from 600 to 1000 > rec then how can i delete? If you have auto_increment int, for example: delete from table where id > 600 and id < 1000 > 3.send some sql statemt for deleting a renge of record? above > 4.can I find record number of particular colume? With autoincrement. > Please send reply.I shall be highly obeliged > > > Bye Abhishek sahay > Web Developer > India > Hi! Sinisa +---------------------------------------------------------------------+ | TcX ____ __ _____ _____ ___ == [EMAIL PROTECTED] | | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic | | /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] | | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Belgrade | | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Serbia | | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ | | /*/ \*\ Developers Team | +---------------------------------------------------------------------+ ----------------------------------------------------------- Send a mail to [EMAIL PROTECTED] with unsubscribe mysql [EMAIL PROTECTED] in the body of the message to unsubscribe from this list.
