perlÀûÓÃÄÚ´æʹÓÃsqlÓï¾ä
´ó¼ÒºÃ£¡×î½üÓÖÓÐÁËһЩģ¿éÓ÷¨µÄÐĵã¬ÄǾÍÊÇÀûÓÃÄ£¿éʹÄãµÄÄÚ´æ±ä³ÉÒ»¸öÐéÄâµÄÊý¾Ý¿âģʽ£¬Ê¹Äã¿ÉÒÔÔÚûÓÐÊý¾Ý¿âµÄÇé¿öÏ£¬½«txtÎļþµÄÊý¾Ý½øÐÐ sqlÓï¾ä´¦Àí£¬¸Ð¾õºÜÐÂÏÊ°É£¬²»¹ýÕâ¸ö²»Óøе½¾ªÑÈ£¬PerlÒ»Ö±ÊǺÜÍêÃÀµÄ£¬¹þ¹þ£¬ÄÇÎÒÃǾÍÀ´¿´¿´Õâ¸öÉñÆæ°É£¡
ÐèÒª°²×° Ä£¿é£º
SQl::Library;
DBI
ÏÂÃæÊdzÌÐò(±È½ÏÎļþ1ºÍÎļþ2ÖеĹؼü×ֶΣ¬±ÈÈç¸èÇú±È¸èÇú£¬¸èÊֱȸèÊÖ£¬Èç¹ûÏàͬ¾ÍÊä³ö)£º
#!/usr/bin/perl
use SQl::Library;
use DBI;
my $data1='T';
my $data2='R';
my $dbh = DBI->connect('dbi:AnyData(RaiseError=>1):');
$table='students';
$format='Tab'; #ÎļþÊÇÒÔÖƱí·û·Ö¸îµÄ
$file='d:/test.txt'; #Îļþ1
$flags = { col_names => 'a,b,c,d,e,f,g,h'}; #ÎļþÓм¸¸ö±í×Ö¶Î
$dbh->func( $table, $format, $file, $flags, 'ad_import');
$table1='students1';
$format1='Tab'; #ÎļþÊÇÒÔÖƱí·û·Ö¸îµÄ
$file1='d:/test2.txt' #Îļþ2
flags1 = { col_names => 'a,b,c,d,e,f,g,h,i'}; #ÎļþÓм¸¸ö±í×Ö¶Î
$dbh->func( $table1, $format1, $file1, $flags1, 'ad_import');
my $tel_sth=$dbh->prepare("select b.*,a.i from students1 a,students b
where a.f=b.c and a.g=b.d"); #µ÷ÓÃsqlÓï¾äµÄ·½Ê½½øÐвéѯ£¬ÔÚÎÒµÄÊý¾ÝÀïÃæÊÇ ¸èÇúºÍ¸èÊÖ2¸ö×ֶνøÐеIJéѯ
$tel_sth->execute; #Ö´ÐÐÓï¾ä
while (my @ref = $tel_sth->fetchrow_array()) {
chomp(@ref);
my $file_data = join "\t", @ref;
print 'ÕâЩÊý¾ÝÊǸèÇúºÍ¸èÊÖÏàͬµÄ'."$file_data\n"
}
ÕâÑù¾Í¿ÉÒÔºÜÇáËɵĽ«Êý¾Ý½øÐÐÕûÀíÁË£¬¶ÔÓÚÓÐʱºòÎÞ·¨Ê¹ÓÃÊý¾Ý¿â½øÐд¦ÀíµÄʱºòÕâÊǸö²»´íµÄÑ¡Ôñ¡£
µ«ÊÇ»¹ÊÇÐèÒªÉæ¼°µ½ÐÔÄÜÎÊÌâµÄ£¬ÒòΪÕâÊǸöÄ£·ÂÊý¾Ý¿âÔÚÄÚ´æÉϽøÐеIJÙ×÷£¬ÔÚËÙ¶ÈÉÏÃæÊDz»¿ÉÄܺÍÊý¾Ý¿âµÄÏà±È£¬¶øÇÒÕ¼ÓÃ×ÊÔ´±È½Ï´ó£¬µ±ÄãµÄÎļþºÜ´óµÄʱºò£¬¿ÉÄܸù±¾¾ÍûÓа취ȥÔËÐÐÁË£¬Òò´ËÖ»ÊʺÏÊý¾ÝÁ¿±È½ÏСµÄÀ´ÔËÓÃÁË£¬¿ÉÒÔ¿´×Ô¼ºµÄÄÚ´æºÍÊý¾ÝµÈÀ´ºÏÀíÔËÓÃÁË°¡£¬¾Í˵µ½×ÅÁË¡£
Ïà¹ØÎĵµ£º
×îºóÒ»¿Î Òì³£´¦Àí±¾ÕÂÖص㣺
¡¡¡¡
¡¡¡¡1¡¢¶¨ÒåPLSQLÒì³£
¡¡¡¡2¡¢Áоٲ»Í¬µÄÒì³£´¦Àí·½·¨
¡¡¡¡3¡¢²¶»ñ·ÇÔ¤ÆڵĴíÎó
¡¡¡¡4¡¢ÃèÊöÒì³£µÄÓ°Ïì
¡¡¡¡5¡¢¶¨ÖÆÒì³£µÄ·µ»ØÐÅÏ¢¡¡¡¡Ò»¡¢PLSQLÒì³£´¦Àí
¡¡¡¡Òì³£ÊÇÓÉORACLE´íÎó»òÏÔʽµÄÅ׳öÒ»¸ö´íÎó²úÉúµÄ¡£
¡¡¡¡ÈçºÎ´¦Àí£º
¡¡¡¡ÓÃÒ»¸ö´¦Àí³ÌÐòÀ´²¶»ñËü£»
¡¡¡¡½«Ëü´«µÝ ......
NO ACTION
Ö¸¶¨Èç¹ûÊÔͼɾ³ý/ÐÞ¸ÄijһÐУ¬¶ø¸ÃÐеļü±»ÆäËû±íµÄÏÖÓÐÐÐÖеÄÍâ¼üËùÒýÓã¬Ôò²úÉú´íÎ󲢻عö DELETE/UPDATEÓï¾ä¡£
CASCADE¡¢SET NULL ºÍ SET DEFAULT
ÔÊÐíͨ¹ýɾ³ý»ò¸üмüÖµÀ´Ó°ÏìÖ¸¶¨¾ßÓÐÍâ¼ü¹ØϵµÄ±í£¬ÕâЩÍâ¼ü¹Øϵ¿É×·Ëݵ½ÔÚÆäÖнøÐÐÐÞ¸ÄµÄ±í¡£Èç¹ûΪĿ±ê±íÒ²¶¨ÒåÁ˼¶ÁªÒýÓòÙ×÷£¬ÄÇôָ¶¨µÄ¼¶Áª²Ù ......
3¡£±íÄÚÈÝÈçÏÂ
-----------------------------
ID LogTime
1 2008/10/10 10:00:00
1 2008/10/10 10:03:00
1 2008/10/10 10:09:00
2 ¡ ......
×÷Õß Haidong Ji ·Òë GoodKid
ÎÒÃǵ±ÖеĴ󲿷ÖÈ˹¤×÷ÔÚÒ»¸öµ¥Ò»µÄ RDBMS ϵͳÖУ¬Èç MSSQL, Oracle, or IBM DB2¡£È»¶ø£¬ÎÒÃÇÈÕÒæ¸Ð¾õµ½£¬ÎÒÃÇÕý´¦ÓÚ²»Í¬µÄÊý¾Ý¿â»·¾³µ±Öв¢ÇÒÐèÒª½â¾öÊý¾ÝµÄ»¥ÓÃÐÔÎÊÌâ¡£
¾¡¹ÜÖ÷ÒªµÄ RDBMS ³§ÉÌÊÔͼȥ×ñѹØϵÊý¾Ý¿âÄ£ÐÍÔÀí£¬²¢ÇÒÓ÷dz£Ð¡µÄ²îÒìȥʵÏÖËüÃÇ¡£ÁíÍ⣬¼¸ºõÖ÷ÒªµÄ ......
--ºÏ²¢Öظ´ÐÐ
select * from A
union
select * from B
--²»ºÏ²¢Öظ´ÐÐ
select * from A
union all
select * from B
°´Ä³¸ö×Ö¶ÎÅÅÐò
--ºÏ²¢Öظ´ÐÐ
select *
from (
select * from A
union
select * from B) AS T
order by ×Ö¶ÎÃû
--²»ºÏ²¢Öظ´ÐÐ
select *
from (
select * from A
union all
select * ......