|
|
Posted by giancarlodirisioster on 10/30/05 01:28
With the second approach you present I am getting a parse error,
unexpected ')' in /usr/home/test.php on line 14
On the first one, I am getting this : MySQL said: Documentation
#1064 - You have an error in your SQL syntax near 'customer1 from
customer1,customer WHERE customer1.column1 = customer.column1' at line
1
Best regards,
Carly
scott Johnson wrote:
> If they are two different tables it could be as easy as:
>
> "DELETE table2 from table2,table1 WHERE table2.column1 = table1.column1"
>
> This will of course delete the row of table2 that has similar data in
> column of table1 and table2.
>
> If you are just trying to clear the data out of a column in the same table:
>
> <?php
> /*
> Connect to your DB
> */
> $query = "SELECT table.column1 FROM table";
> $result = mysql_query($query);
> while($column = mysql_fetch_array($result)){
> $column1 = $column['column1'];
> $update = "UPDATE test SET column2 = ''
> WHERE column2 = '$column1'";
> mysql_query($update))
> }
> ?>
>
> This is as basic as I can get it.
>
> giancarlodirisioster@gmail.com wrote:
> > Everyone is usually so friendly and helpful in here, I need help with
> > this:
> >
> > I need a MySQL routine that takes one column of data and compares it to
> > a second column of like data. What I want it to do is remove all
> > instances of duplicate data from the second column only. Non-case
> > sensitive. How would I accomplish this?
> >
>
> --
> Scott Johnson
> http://www.seaforthsailingclub.com
Navigation:
[Reply to this message]
|