How to select a specific row in Mysql?

Select Row 56

SELECT * FROM customer LIMIT 55,1

20140227

1. What is "new_ids_in_table4.txt" file?
2. Results of running: update_pubmed_info_with_table4.py

update_pubmed_info_with_table4.py:240: Warning: Data truncated for column 'Author' at row 1
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xC5\x82otni...' for column 'Authors' at row 34775
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xC5\x9Fiogl...' for column 'Authors' at row 49380
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB1 or ...' for column 'Abstract' at row 170249
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xC4\x87 S, ...' for column 'Authors' at row 174522
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB3 ELI...' for column 'Abstract' at row 174522
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xC4\x87 S.' for column 'Authors' at row 174523
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xC4\x87 S, ...' for column 'Authors' at row 174525
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xBCM ea...' for column 'Abstract' at row 176282
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB1 and...' for column 'Abstract' at row 177475
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB22-mi...' for column 'Title' at row 177476
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB2(2)-...' for column 'Abstract' at row 177476
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xBB aut...' for column 'Abstract' at row 178076
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB3 and...' for column 'Abstract' at row 178665
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB2\xE2\x82\x82-...' for column 'Title' at row 178666
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB2\xE2\x82\x82-...' for column 'Abstract' at row 178666
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB2-hai...' for column 'Abstract' at row 178668
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xE2\x80\x897BN...' for column 'Affiliations' at row 179185
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB32 do...' for column 'Abstract' at row 179185
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB1GalC...' for column 'Title' at row 179737
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB1GalC...' for column 'Abstract' at row 179737
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB11, \xCE...' for column 'Abstract' at row 179738
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xE2\x84\xAB) s...' for column 'Abstract' at row 179942
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB1 sub...' for column 'Abstract' at row 180166
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB5RI),...' for column 'Abstract' at row 180167
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB2.' for column 'Title' at row 180169
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB2 (IL...' for column 'Abstract' at row 180169
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB1\xCE\xB2 T...' for column 'Abstract' at row 180644
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB5RI, ...' for column 'Abstract' at row 180646
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xBAB ac...' for column 'Abstract' at row 180878
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xE2\x86\x924)-...' for column 'Abstract' at row 181259
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB11 an...' for column 'Abstract' at row 181537
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB21-3G...' for column 'Abstract' at row 181538
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xE2\x80\x85nM)...' for column 'Abstract' at row 181847
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB11.' for column 'Title' at row 181848
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB11 su...' for column 'Abstract' at row 181848
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB22-mi...' for column 'Title' at row 182107
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB2(2)-...' for column 'Abstract' at row 182107
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB2) pl...' for column 'Abstract' at row 182108
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB3-Car...' for column 'Title' at row 182109
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB3-car...' for column 'Abstract' at row 182109
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xE2\x80\xB3 st...' for column 'Abstract' at row 182110
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB2 and...' for column 'Abstract' at row 182366
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB2-hai...' for column 'Abstract' at row 182749
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB2-Sec...' for column 'Title' at row 183362
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xE2\x88\xA5Dru...' for column 'Affiliations' at row 183362
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB240 a...' for column 'Abstract' at row 183362
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xC4\x8Devi\xC4...' for column 'Authors' at row 183363
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xE2\x80\x89\xC3\x97\xE2...' for column 'Abstract' at row 183611
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB2 pep...' for column 'Title' at row 184011
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB2 (A\xCE...' for column 'Abstract' at row 184011
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB2-tur...' for column 'Abstract' at row 184013
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xBCM). ...' for column 'Abstract' at row 184488
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB2-cel...' for column 'Abstract' at row 184490
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB3\xCE\xB4 T...' for column 'Title' at row 184492
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB3\xCE\xB4 T...' for column 'Abstract' at row 184492
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB1\xCE\xB2) ...' for column 'Abstract' at row 184494
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB1-cha...' for column 'Abstract' at row 184866
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB3R ef...' for column 'Abstract' at row 185759
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB2 dom...' for column 'Title' at row 185764
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB1\xCE\xB2 T...' for column 'Abstract' at row 185764
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xE2\x88\xBC12 ...' for column 'Abstract' at row 185765
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB1-hel...' for column 'Abstract' at row 185766
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\xB1-d-m...' for column 'Abstract' at row 185767
  cursor.execute(sql)
update_pubmed_info_with_table4.py:338: Warning: Incorrect string value: '\xCE\x94H7 m...' for column 'Abstract' at row 185960
  cursor.execute(sql)

20140224

How to login to the IEDB-sever

mysql --host=10.0.3.49 --protocol=TCP --port=33306 -u rdamle -p

username: rdamle
password: iedb123

use table: Table4_20140226  as the updated table 4

mysqldump -u <db_username> -h <db_host> -p db_name table_name > table_name.sql

mysqldump --host=10.0.3.49 --protocol=TCP --port=33306 -u rdamle -p pubmed pubmed_information > pubmed_information.sql 

mysqldump --host=10.0.3.49 --protocol=TCP --port=33306 -u rdamle -p pubmed t4_tokenized_pubmed_information > t4_tokenized_pubmed_information.sql

mysql> show tables;
+---------------------------------+
| Tables_in_pubmed                |
+---------------------------------+
| pubmed_information              |
| t4_tokenized_pubmed_information |
| table4_reference                |
| table4_reference_latest         |
| table_4_reference_last_updated  |
| temp_pubmed_data                |
| temp_stemmed_for_svm            |
+---------------------------------+
7 rows in set (0.00 sec)

mysqldump --host=10.0.3.49 --protocol=TCP --port=33306 -u rdamle -p pubmed table4_reference > table4_reference.sql 

mysqldump --host=10.0.3.49 --protocol=TCP --port=33306 -u rdamle -p pubmed table4_reference_latest > table4_reference_latest.sql 

mysqldump --host=10.0.3.49 --protocol=TCP --port=33306 -u rdamle -p pubmed table_4_reference_last_updated > table_4_reference_last_updated.sql   

mysqldump --host=10.0.3.49 --protocol=TCP --port=33306 -u rdamle -p pubmed temp_pubmed_data > temp_pubmed_data.sql   

mysqldump --host=10.0.3.49 --protocol=TCP --port=33306 -u rdamle -p pubmed temp_stemmed_for_svm > temp_stemmed_for_svm.sql   

2014-02-7

Need modified sample_locus.csv

Redo the analysis from 5.0.4 to 5.0.8

2013-02-06

1. Need resubmit IHW pipeline 5.0.9 from JOB 6 to JOB 88

2. Issac microarray analysis: mouse4302cdf database