Re: INSERT using SELECT results

[Afan Pasalic]

INSERT INTO ztipos (type)  VALUES (SELECT DISTINCT type FROM locais)
?

-afan


Miguel Vaz wrote:

    Hi,

    I have a table LOCAIS with:

    id    type    desc
    1    t1    blah blah
    2    t1    uihuih
    3    t2    pokpokp

I want to list only the distinct types and create a table with those results. I know how to list the distinct and i thought i got the insert right, but it doesnt work:

    INSERT INTO ztipos('type') SELECT DISTINCT type FROM locais

    Whats wrong with that command?
    I want the result to be:
    results table ZTIPOS:

    id    type
    1    t1
    2    t2

Thanks

    Miguel

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]