INSERT using SELECT results

[Miguel Vaz]

        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]