> insert/select has a different syntax than what you are trying to use.
>
> try
>
> insert into table_name (place, address, number) select "stuff",
> "stuff2", this from that where one=two
aha... this is it. thank you...
and you can sellect more then one things from 'that':
insert into table_name (place, address, number,number_too) select
"stuff","stuff2", this, this_too from that where one=two;
thanks...
>
> i may yet have the syntax wrong, but its close.
>
>
> kalin mintchev wrote:
>> hi all...
>>
>> i need some help. can somebody explain why is this insert/select not
>> working?
>>
>> insert into the_db (place,address,number) values("stuff","stuff2",select
>> this from that where one=two);
>>
>> i tried ()s around the 'select....' too but it didn't work.
>>
>> thanks.
>>
>
>
> --
> Jeff Mathis, Ph.D. 505-955-1434
> Prediction Company [EMAIL PROTECTED]
> 525 Camino de los Marquez, Ste 6 http://www.predict.com
> Santa Fe, NM 87505
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
