Wesley Furgiuele <[EMAIL PROTECTED]> wrote:
>I think one way to solve it would be to move your data to a new copy of
>your table. Assuming record_ref and keyword are separate fields...
>
>CREATE TABLE newtable SELECT * FROM oldtable GROUP BY CONCAT(
>record_ref, keyword );
Or, more simply and
I think one way to solve it would be to move your data to a new copy of
your table. Assuming record_ref and keyword are separate fields...
CREATE TABLE newtable SELECT * FROM oldtable GROUP BY CONCAT(
record_ref, keyword );
Wes
On Jul 16, 2004, at 7:08 PM, L a n a wrote:
Hello,
I'm trying to s
Hello,
I'm trying to solve a task in Mysql 4:
I have a table
rec_id | record_ref | keyword
**
1| 2| apple
2| 2|orange
3| 2|apple
4| 3|mango
**
How can I delete
Hello,
I'm trying to solve a task in Mysql 4:
I have a table
rec_id | record_ref | keyword
**
1| 2| apple
2| 2|orange
3| 2|apple
4| 3|mango
**
How can I delete
