Displaying 1 result from an estimated 1 matches for "outfile_13mai".
2011 May 16
2
File to MYSQL
..."data.frame")
2) My script
outfile<- with(as.data.frame(Alldados),sprintf("INSERT INTO OBS
(date,TMAX_2M,TMIN_2M,TD_2M,PS,FF_10M,DD_10M,Station_NO) VALUES (%s, %s, %s,
%s,%s,%s,%s,%s)",date2,TMAX_2M,TMIN_2M,TD_2M,PS,Station_NO))
write.table(outfile,file=paste(dat.dir,"outfile_13mai.txt",sep=""),append=FALSE,col.names=FALSE,
row.names=FALSE)
3) The commands above works but the problem is that the oufile_13mai.txt
have several quotes (") . So when I am going to feed my database using the
command
/usr/bin/mysql -uxx -pxxx ormverif < ~/ormverif/syn/outf...