11_12_2018

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.kahn11_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