On Wed, 11 Aug 2004 12:49:22 -0300 (ART), Juan Pablo Herrera <[EMAIL PROTECTED]> wrote: > > "Torsten Roehr" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > >> "Juan Pablo Herrera" <[EMAIL PROTECTED]> wrote in message > >> news:[EMAIL PROTECTED] > >> > 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 >
I assume you means a csv file, not a cvs file. No, you can't directly load it into Mysql. Yes, you can load it into PHP and then do an INSERT with that data. Google for PHP CSV. -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
