Mysql cli

Login commands

mysql -h xxxxxxxxx.us-east-1.rds.amazonaws.com -u username  -p

password: xxxxxxxx

Test the RDS connection     

nc -v xxxxxxxx.us-east-1.rds.amazonaws.com 3306

Commands used in the db:

show databases;

show columns from keywords;

SELECT  *  from matches  WHERE keyword_id  = '15'; INTO OUTFILE "E:\\JOSE DATA\\addstock7.csv"

SELECT  *  from keywords  WHERE keyword_id  BETWEEN '1' AND '500';

SELECT  *  from keywords limit 5;

SELECT  *  from matches limit 5;

SELECT  *  from pages limit 5;

keywords  (keyword) = keyword_id = matches

matches = page_id = pages

SHOW STATUS LIKE 'delayed_insert_threads';

SHOW STATUS LIKE 'threads_connected';

SELECT  keyword_id,keyword,modified_date from  keywords WHERE keyword_id = ’15’ INTO OUTFILE “/opt/test.txt/

SELECT keywords.keyword,pages.url,pages.title,position,pages.description

FROM ((keywords

INNER JOIN matches ON keywords.keyword_id = matches.keyword_id)

INNER JOIN pages ON matches.page_id = pages.page_id) limit 300;