To insert values with SQL: INSERT INTO table_name VALUES (value1, value2, value3,...).
To deal with those date problems Im almost sure that R has a Date Function somewhere in its manual. You should take a look. Just the best help I can give, sorry good look JoK LoQ wrote: > > Hi, > > Im trying to complete a list of jobs using SQL Querries and some "if else" > commands but im stucked in some steps. Could any of you give me some help? > > -in COLUMN1 change the format 20JAN2000:00:00:00 to 20JAN2000 and exclude > every row that date is different from 20. > -extract the first character in COLUMN2 and creat COLUMN3 with that value > ex: > COL2,COL3 > 135,1 > 461,4 > 247,2 > -in every row in which COL3=5, value in COLUMN4=value in COLUMN5 > -create COLUMN7 where if COLUMN6="north" then COLUMN7 value="N" else > COLUMN7 value="X" > > Ill be grateful for any help, thnks > -- View this message in context: http://www.nabble.com/Some-SQL-Challenges-tp24795946p24834191.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
