err columns.. sorry.. On Wednesday 01 March 2006 10:45 am, Micah Stevens wrote: > 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
