Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
11_12_2018 [2018/11/14 21:54]
cynthia.kahn
11_12_2018 [2018/11/14 22:01] (current)
cynthia.kahn
Line 11: Line 11:
 sed -i '​s/​\\//​g'​ filename \\ sed -i '​s/​\\//​g'​ filename \\
 string = string.replace("​\n",""​).replace("​\r",""​) \\ string = string.replace("​\n",""​).replace("​\r",""​) \\
 +\\ 
 **//SQL to create table tweets_info//​** **//SQL to create table tweets_info//​**
 +\\ 
 DROP TABLE IF EXISTS tweets_info;​ \\ DROP TABLE IF EXISTS tweets_info;​ \\
 +\\ 
 CREATE TABLE tweets_info( \\ CREATE TABLE tweets_info( \\
  tweetCreated VARCHAR(50),​ \\   tweetCreated VARCHAR(50),​ \\ 
Line 63: Line 63:
         matchingRulesID BIGINT ​  \\         matchingRulesID BIGINT ​  \\
 );  \\ );  \\
 +\\ 
 psql cynthiak ​  \\ psql cynthiak ​  \\
 \copy tweets_info FROM '/​home/​cynthiak/​tab_to_semi.txt'​ WITH DELIMITER ';' ​ \\ \copy tweets_info FROM '/​home/​cynthiak/​tab_to_semi.txt'​ WITH DELIMITER ';' ​ \\
  • 11_12_2018.txt
  • Last modified: 2018/11/14 22:01
  • by cynthia.kahn