rodrigao.net 2.0

//Arquivo CSV
Blumenau,Santa Catarina,
Joinville,Santa Catarina,
Florianopolis,Santa Catarina,
Curitiba,Parana,
Londrina,Parana,
Porto Alegre,Rio Grande do Sul,
Sao Paulo,Sao Paulo,

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| hssegue            |
| java               |
| joomla             |
| mark               |
| mysql              |
| rodrigo            |
| test               |
| wikidb             |
+--------------------+
9 rows in set (0.00 sec)

mysql> USE test;
Database changed
--Criando Tabela
mysql> CREATE TABLE import(
    ->   city  varchar(50),
    ->   state varchar(50));
Query OK, 0 rows affected (0.06 sec)

--Inicia Transação
mysql> begin;
Query OK, 0 rows affected (0.00 sec)

--Importa Arquivo
mysql> LOAD DATA LOCAL INFILE 'test.csv'
    -> INTO TABLE import
    -> FIELDS TERMINATED BY ','
    -> LINES TERMINATED BY '\n'
    -> (city, state);
Query OK, 7 rows affected, 7 warnings (0.00 sec)
Records: 7  Deleted: 0  Skipped: 0  Warnings: 7

--Confirmando dados importados
mysql> SELECT city, state
    ->   FROM import;
+---------------+-------------------+
| city          | state             |
+---------------+-------------------+
| Blumenau      | Santa Catarina    |
| Joinville     | Santa Catarina    |
| Florianopolis | Santa Catarina    |
| Curitiba      | Parana            |
| Londrina      | Parana            |
| Porto Alegre  | Rio Grande do Sul |
| Sao Paulo     | Sao Paulo         |
+---------------+-------------------+
7 rows in set (0.00 sec)

--comita transação
mysql> commit;
Query OK, 0 rows affected (0.03 sec)

Relacionados

• April 20, 2009 -- Papo Geek #1
• March 20, 2009 -- IBM e Sun, eu torço!
• January 16, 2008 -- Quicknews