Re: Re: Load data and Insert

> "Torsten Roehr" <roehr@zilleon.com> wrote in message > news:20040811150349.86315.qmail@pb1.pair.com... >> "Juan Pablo Herrera" <juampi@linuxeducativo.com.ar> wrote in message >> >> news:1660.200.69.0.166.1092236555.squirrel@linuxeducativo.com.ar... >> > Hi! >> > i need do two querys in one. >> > First query is a load data and the second query is insert into. My >> > idea is to concatenate with "and", but i'not know. >> > Is it possible? >> > >> > Regards, >> > Juan >> >> Please specify a bit more clearly *what* data you want to load *from > where* >> and insert into *what*. Then we may be able to help you. >> >> Regards, Torsten Roehr > > If you refer to MySQL you can use the INSERT ... SELECT syntax to do > this in one query. See here: > http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html > > Regards, Torsten Roehr > It's OK, but i need concatenate "load data" with "insert". I have a file *.cvs that used three fields (a,b,c), my database have four fields(a,b,c,d). The "insert" have the data for last field. Regards, Juan