Ahh, good point, yes, keep in mind you may have some index rows.. On Wednesday 01 March 2006 10:18 am, tg-php@xxxxxxxxxxxxxxxxxxxxxx wrote: > Haha.. oh yeah.. DISTINCT works too.. in this case you'd get a list of all > totally 100% unique records. > > If you had an auto_increment column though, you'd want to exclude it from > the list. > > -TG > > = = = Original message = = = > > SELECT DISTINCT * FROM `tablename` > > On Wednesday 01 March 2006 7:24 am, Miguel Guirao wrote: > > My dear beloved friends, > > > > I have a catalog of products that a product provider gave, sadly for me, > > in this CSV file there are many duplicated rows. > > I edited the file in my Linux system with the "uniq -u" command, and it > > worked somewhat fine, it eliminated some duplicated rows, originally the > > file had 24K rows, and now it has been reduced to 15k rows. > > > > Anyhow, there are still duplicated rows, and since this is a catalog, it > > should not have duplicated rows!!! > > Now the catalog has been has been loaded into the DB. > > > > How can I continue eliminating duplicated rows? > > As far as I remember the is a sentence in SQL to only show ONE row of > > duplicated rows, maybe if I do a select using this sentence and then put > > this new recordset in another table, it will work!! > > > > Any ideas? > > > > ----------------------- > > Miguel Guirao Aguilera > > Logistica R8 TELCEL > > Tel. (999) 960.7994 > > > > > > Este mensaje es exclusivamente para el uso de la persona o entidad a > > quien esta dirigido; contiene informacion estrictamente confidencial y > > legalmente protegida, cuya divulgacion es sancionada por la ley. Si el > > lector de este mensaje no es a quien esta dirigido, ni se trata del > > empleado o agente responsable de esta informacion, se le notifica por > > medio del presente, que su reproduccion y distribucion, esta > > estrictamente prohibida. Si Usted recibio este comunicado por error, > > favor de notificarlo inmediatamente al remitente y destruir el mensaje. > > Todas las opiniones contenidas en este mail son propias del autor del > > mensaje y no necesariamente coinciden con las de Radiomovil Dipsa, S.A. > > de C.V. o alguna de sus empresas controladas, controladoras, afiliadas y > > subsidiarias. Este mensaje intencionalmente no contiene acentos. > > > > This message is for the sole use of the person or entity to whom it is > > being sent. Therefore, it contains strictly confidential and legally > > protected material whose disclosure is subject to penalty by law. If the > > person reading this message is not the one to whom it is being sent > > and/or is not an employee or the responsible agent for this information, > > this person is herein notified that any unauthorized dissemination, > > distribution or copying of the materials included in this facsimile is > > strictly prohibited. If you received this document by mistake please > > notify immediately to the subscriber and destroy the message. Any > > opinions contained in this e-mail are those of the author of the message > > and do not necessarily coincide with those of Radiomovil Dipsa, S.A. de > > C.V. or any of its control, controlled, affiliates and subsidiaries > > companies. No part of this message or attachments may be used or > > reproduced in any manner whatsoever. > > ___________________________________________________________ > Sent by ePrompter, the premier email notification software. > Free download at http://www.ePrompter.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
