Thanks for the response, but doing this results in :
ERROR 1093: INSERT TABLE 'myTable' isn't allowed in FROM table list marc -----Ursprüngliche Nachricht----- Von: Nathan [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 14. November 2001 19:05 An: Votteler Marc Betreff: Re: INSERT with SELECT on same table > > Maybe I'm not looking at it hard enough :-) but could this work: > > INSERT INTO myTable (myCol) > SELECT DISTINCT '8888' > FROM myTable MT > WHERE MT.myCol != '8888' > > I don't have a test table setup to try this, but maybe it will work for you? I'm not totally sure I > understand the intent, so if I'm off, please explain more and I will try to help! > > Cheers, > > # Nathan --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
