MySQL Forums
Forum List  »  Italian

Schedulazione LOAD DATA LOCAL INFILE su server remoto
Posted by: Simone Ranucci
Date: July 27, 2007 05:21AM

Ciao a tutti!
Attualmente, utilizzando Navicat in versione Trial, il programma gestisce la connessione e schedula una query con i seguenti comandi:

LOAD DATA LOCAL INFILE '/FixedLengthFile.txt'
REPLACE INTO TABLE db.table
FIELDS TERMINATED BY '' ENCLOSED BY ''
LINES TERMINATED BY 0x0d0a

Come posso schedulare ed eseguire il comando verso il server centrale evitando di acquistare tante licenze quanti saranno i client su cui sarĂ  schedulato l'upload dei dati.

Grazie.



Edited 1 time(s). Last edit at 07/27/2007 05:28AM by Simone Ranucci.

Options: ReplyQuote


Subject
Views
Written By
Posted
Schedulazione LOAD DATA LOCAL INFILE su server remoto
6102
July 27, 2007 05:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.