Jump to content
Fórum Script Brasil
  • 0

Importar dados de TXT para o MySQL


Girréis

Question

Prezados, Amigos.

Estou com uma dúvida, criei um banco chamado Teste e com faço para importar os dados de um arquivo texto cujo formato está da seguinte forma:

Policy_Domain_Name                 Schedule_Name                      Associated_Nodes                                                
------------------------------     ------------------------------     ----------------------------------------------------------------
PD_EX001                           BKP-EXC-DIARIO-RJ0000NT511-EXC                                                                     
PD_EX001                           BKP-EXC-DIARIO-RJ0000NT512-EXC                                                                     
PD_EX001                           BKP-EXC-DIARIO-RJ0000SR511-EXC     RJ0000SR511-EXC                                                 
PD_EX001                           BKP-EXC-DIARIO-RJ0000SR512-EXC     RJ0000SR512-EXC                                                 
PD_EX001                           BKP-EXC-DIARIO-RJ0000SR513-EXC     RJ0000SR513-EXC                                                 
PD_EX001                           BKP-EXC-DIARIO-RJ0000SR514-EXC     RJ0000SR514-EXC

Ainda não criei tabela, pois quero além de criar uma tabela, os campos acima tem que estar presentes ao importar.

São mais 100 registros.

Grato pela ajuda.

Ramon

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Forum Statistics

    • Total Topics
      152.2k
    • Total Posts
      652k
×
×
  • Create New...