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
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]
