MySQL Forums
Forum List  »  Italian

Re: Problemi importazione Dump con campo DATETIME
Posted by: max dix
Date: July 30, 2008 08:58AM

c'e' addirittura un altra soluzione ancora migliore ..direttamente col comando load data strasformi le variabili al volo

LOAD DATA INFILE 'C:/LOASDASDA.TXT' INTO TABLE ASDASD
(@SKIP,@PRIMA,@DATA,CAMPO)
SET NOMECAMPO=SUBSTING(CONTACT(@DATA),1,2) ECC....E QUI IMPOSTI IL CAMBIAMENTO IN MODO CHE IL FORMATO PIACCI A MYSQL

AMEN

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Problemi importazione Dump con campo DATETIME
3725
July 30, 2008 08:58AM


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.