Skip to content

Instantly share code, notes, and snippets.

@flaviomicheletti

flaviomicheletti/create-table.sql

Last active August 9, 2021 01:43
Show Gist options
  • Save flaviomicheletti/8359890 to your computer and use it in GitHub Desktop.
Save flaviomicheletti/8359890 to your computer and use it in GitHub Desktop.
Download ZIP
Exercício LOAD DATA LOCAL
Raw
create-table.sql
CREATE TABLE pet (
name VARCHAR(20),
owner VARCHAR(20),
species VARCHAR(20),
sex CHAR(1),
birth DATE,
death DATE
);
Raw
pet.txt
Fluffy Harold cat f 1993-02-04 \N
Claws Gwen cat m 1994-03-17 \N
Buffy Harold dog f 1989-05-13 \N
Fang Benny dog m 1990-08-27 \N
Bowser Diane dog m 1979-08-31 1995-07-29
Chirpy Gwen bird f 1998-09-11 \N
Whistler Gwen bird \N 1997-12-09 \N
Slim Benny snake m 1996-04-29 \N
@flaviomicheletti
Copy link
Author

flaviomicheletti commented Jan 22, 2014 •
edited
Loading

Gist complementar da matéria:
www.devfuria.com.br/sql/populando-tabela-a-partir-de-um-arquivo-de-texto-no-mysql/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment