Fwd: loading scripts to mysql

2007-11-13 Thread Pau Marc Munoz Torres
hi, Tanks for your help, finally i found the "source" command. It work like this: mysql> source /Lhome/geruppa/mhc/Pack_Ref_web/prova.sql 2007/11/9, Michael Gargiullo < [EMAIL PROTECTED]>: > > On Fri, 2007-11-09 at 13:22 +0100, Pau Marc Munoz Torres wrote: > > > Hi everybody > > > > I'm writi

Re: loading scripts to mysql

2007-11-09 Thread Michael Gargiullo
On Fri, 2007-11-09 at 13:22 +0100, Pau Marc Munoz Torres wrote: > Hi everybody > > I'm writing a function script in a flat file using vim, now i would like > load it into my sql, there is some command to do it similar to "load data > into" to fill tables? > > thanks > Sure, >From command lin

Re: loading scripts to mysql

2007-11-09 Thread yaya sirima
You have basic instruction SELECT (for selection) and INSERT (for write in table) What case : . Take data in one table and transfer it in other table ( select / insert ) . Take data in a file and insert it in a table ( tools of conversion) 2007/11/9, Pau Marc Munoz Torres <[EMAIL PROTECTED]>: > >

loading scripts to mysql

2007-11-09 Thread Pau Marc Munoz Torres
Hi everybody I'm writing a function script in a flat file using vim, now i would like load it into my sql, there is some command to do it similar to "load data into" to fill tables? thanks -- Pau Marc Muñoz Torres Laboratori de Biologia Computacional Institut de Biotecnologia i Biomedicina