Thursday, 12 July 2018

sql to load csv file

 load data local infile '/home/rajiv/Downloads/words_alpha.csv' into table newwords
 fields terminated by ','
 enclosed by '"'
 lines terminated by '\n'
 (word)



Getting word with same letter left and right side




select word, length(word) from words where word like '_ido_' AND length(word) = 5

No comments :

Post a Comment