Displaying 2 results from an estimated 2 matches for "clcl".
Did you mean:
ccl
2011 May 09
2
Using NULL to my data?
Dear R users,
I am reading data from a file where there are some missing that are
represented by -9999.00.
I am using the command below.
=====My original data ===========
PARM = TMPC;T12X;T12N;DWPC;PALT;SKNT;DRCT;P24M;CLCL
STN YYMMDD/HHMM TMPC T12X T12N DWPC PALT
SKNT
DRCT P24M CLCL
820420 110429/1200 22.50 -9999.00 22.40 22.20 -9999.00
0.00
0.00 84.00 4.00
820980 110429/1200 26.90 -9999.00 23...
2011 May 16
2
File to MYSQL
...xx ormverif < ~/ormverif/syn/outfile_13mai.txt
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near '"INSERT INTO OBS
(date,T_2M,TMAX_2M,TMIN_2M,TD_2M,PS,FF_10M,DD_10M,TOT_PRCP,CLCL' at line 1
"INSERT INTO OBS (date,TMAX_2M,TMIN_2M,TD_2M,PS,Station_NO) VALUES
(2011051312, NULL, 20.6,19.4,1014.8,836490)"
"INSERT INTO OBS (date,TMAX_2M,TMIN_2M,TD_2M,PS,Station_NO) VALUES
(2011051312, NULL, 15.5,15.7,912.8,836920)"
So I need a file like below:
INSERT...