Skip to content

Instantly share code, notes, and snippets.

@ChoWonmin

ChoWonmin/load_tsv.sql

Last active October 24, 2019 01:38
Show Gist options
  • Save ChoWonmin/31552da3659a2d73dcc383ff732e0cac to your computer and use it in GitHub Desktop.
Save ChoWonmin/31552da3659a2d73dcc383ff732e0cac to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. ChoWonmin revised this gist Oct 24, 2019. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion load_tsv.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    use databasename;

    DELETE FROM tablename WHERE partition = 'condition';
    LOAD DATA INLOCAL FILE 'file.tsv' INTO TABLE tablename FIELDS TERMINATED BY '\t';
    LOAD DATA LOCAL INFILE 'file.tsv' INTO TABLE tablename FIELDS TERMINATED BY '\t';
  2. ChoWonmin revised this gist Oct 24, 2019. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion load_tsv.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    use databasename;

    DELETE FROM tablename WHERE partition = 'condition';
    LOAD DATA LOCAL FILE 'file.tsv' INTO TABLE tablename FIELDS TERMINATED BY '\t';
    LOAD DATA INLOCAL FILE 'file.tsv' INTO TABLE tablename FIELDS TERMINATED BY '\t';
  3. ChoWonmin revised this gist Oct 24, 2019. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion load_tsv.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    use databasename;

    DELETE FROM tablename WHERE partition = 'condition';
    LOAD DATE LOCAL FILE 'file.tsv' INTO TABLE tablename FIELDS TERMINATED BY '\t';
    LOAD DATA LOCAL FILE 'file.tsv' INTO TABLE tablename FIELDS TERMINATED BY '\t';
  4. ChoWonmin revised this gist Oct 24, 2019. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion load_tsv.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    use databasename;

    DELECT FROM tablename WHERE partition = 'condition';
    DELETE FROM tablename WHERE partition = 'condition';
    LOAD DATE LOCAL FILE 'file.tsv' INTO TABLE tablename FIELDS TERMINATED BY '\t';
  5. ChoWonmin created this gist Oct 24, 2019.
    4 changes: 4 additions & 0 deletions load_tsv.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,4 @@
    use databasename;

    DELECT FROM tablename WHERE partition = 'condition';
    LOAD DATE LOCAL FILE 'file.tsv' INTO TABLE tablename FIELDS TERMINATED BY '\t';
    3 changes: 3 additions & 0 deletions mysql.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,3 @@
    mysql -u username -p password -h hostname --port=3306

    mysql -u username -p password -h hostname --port=3306 < load_tsv.sql