mysql> LOAD DATA INFILE 'file.db.txt' INTO TABLE nameTABLE FIELDS TERMINATED BY '\t';
Mysql / LOAD DATA INFILE
mysql> LOAD DATA INFILE 'file.db.txt' INTO TABLE nameTABLE FIELDS TERMINATED BY '\t';
Related Posts:
Perl with SQLServer -> =) use DBI; my $dsn = 'DBI:ODBC:Driver={SQL Server}'; my $host = 'WINSRV'; my $database = 'Relatorios'; my $user = 'sa'; my $auth = 'm1f1g1f4$'; my $… Read More
Rman / Oracle / Backuprman target / catalog rman/pass@rmandb >crosscheck archivelog all;… Read More
Perl Date Time [ yyyymmdd ] #!/usr/bin/perl my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst)=localtime(time); my $yyyy_mm_dd = sprintf( "%4d%02d%02d", $year+1900,$mon+… Read More
Oracle [ Size by Partitions ] How do I know if an object is partitioned or not? SELECT * FROM dba_tab_partitions WHERE table_name = '<table_name>'; SELECT * FROM dba_in… Read More
Oracle Tablespace [ Check +ASM | Add Tablespace] Check +ASM SQL> select name, total_mb, free_mb from v$asm_diskgroup; Check Disk SQL> show parameter create Add Tablespace SQL> alt… Read More
0 comentários:
Post a Comment