On Wednesday 09 January 2002 19:49, you wrote:
> =A daunting task indeed, however it's a move for the better, so more power
> to your right arm/kung-fu grip... However let's not jump to quickly to PHP,
> and keep it all within MySQL if we can...
I was hoping we could ;-)
> =So you started with
Markus,
> I have the daunting task of porting an Access database to
> MySQL. It's unbeliveably poorly designed, and columns
> id, name, issn, year, info, volume, numbers and remarks.
> I made another table, names, that's got columns id and name.
>
> I used
>
> INSERT INTO names (name) SELECT DIST
Hello, all!
I have the daunting task of porting an Access database to
MySQL. It's unbeliveably poorly designed, and columns
id, name, issn, year, info, volume, numbers and remarks.
I made another table, names, that's got columns id and name.
I used
INSERT INTO names (name) SELECT DISTINCT ma