Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Sentencias

No description
by

Matias Piriz

on 17 August 2016

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Sentencias

EJEMPLOS
LOAD
UNLOAD

¿Cuando se utiliza?
¿Como utilizarlo?

Sentencias
SQL

LOAD
UNLOAD

LOAD
¿Cuando se utiliza?
¿Cómo utilizarlo?
LOAD FROM “archivo” [delimiter “char”]
INSERT INTO nom_tabla
LOAD FROM “datos” delimiter “;”
INSERT INTO PERSONAS
Ejemplos de unload
unload to “archivo” [delimiter “char”]
SELECT....

unload to “datos" delimiter “;”
SELECT * FROM PERSONAS

LOAD FROM 'clientes.txt' INSERT INTO 'clientes'

Para Exportar, se utiliza la sentencia 'UNLOAD' de forma similar :

UNLOAD TO 'clientes.txt' SELECT * FROM CLIENTES

Nota.- Por defecto, el separador de campo es el caracter "|".
EJEMPLOS:
Full transcript