senti word net to mysql

sentiwn-to-mysql.sql

-- Step 1; table_name = sentwn

CREATE TABLE `sentiwn` (
  `pos` varchar(64) DEFAULT NULL,
  `id` varchar(32) DEFAULT NULL,
  `p` int(11) DEFAULT NULL,
  `n` int(11) DEFAULT NULL,
  `synset` varchar(64) DEFAULT '',
  `gloss` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- Step 2; 
-- We don't want hashes (#) From SentiWordnet E.g.
--     26 #
--     27 # POS   ID      PosScore        NegScore        SynsetTerms     Gloss

-- From Bash Run ↓ 
-- tail -n +27 SentiWordNet_3.0.0_20130122.txt

-- Step 3;

LOAD DATA LOCAL INFILE '/Users/kevincobain2000/Downloads/data/SentiWordNet.txt'
INTO TABLE `sentiwn`
COLUMNS TERMINATED BY '\t';