DBD :: CSV.

CSV ÆÄÀÏ ¿ë DBI µå¶óÀ̹ö.
Áö±Ý ´Ù¿î·Îµå

DBD :: CSV. ¼øÀ§ ¹× ¿ä¾à

±¤°í

  • Rating:
  • ƯÇã:
  • Perl Artistic License
  • °¡°Ý:
  • FREE
  • °Ô½ÃÀÚ À̸§:
  • Jeff Zucker
  • °Ô½ÃÀÚ À¥»çÀÌÆ®:
  • http://search.cpan.org/~timb/DBI-1.604/lib/DBD/DBM.pm

DBD :: CSV. ű×


DBD :: CSV. ¼³¸í

CSV ÆÄÀÏ ¿ë DBI µå¶óÀ̹ö. DBD :: CSV´Â CSV ÆÄÀÏ ¿ë DBI µå¶óÀ̹öÀÔ´Ï´Ù .SNOPSIS´Â DBI¸¦ »ç¿ëÇÕ´Ï´Ù. $ dbh = dbi-> connect ( "dbi : csv : f_dir = / home / joe / csvdb") ¶Ç´Â "¿¬°áÇÒ ¼ö ¾ø½À´Ï´Ù." $ dbi :: errstr; $ sth = $ dbh-> prepare ( "Å×À̺í A (ID Á¤¼ö, À̸§ char (10))")¸¦ / die "»ý¼º ÇÒ ¼ö ¾ø½À´Ï´Ù.". $ dbh-> errstr (); $ sth-> execute () ¶Ç´Â die "´Â ½ÇÇàÇÒ ¼ö ¾ø½À´Ï´Ù :". $ sth-> errstr (); $ sth-> finish (); $ dbh-> disconnect (); # "CSV ÆÄÀÏÀ» Àаí"; " ¼¼ÆÛ·¹ÀÌÅͷμ­ # MS Excel·Î ³»º¸³»´Â °Íó·³. ¸Þ¸ð´Â ";"¸¦ À̽ºÄÉÀÌÇÁÇؾßÇÕ´Ï´Ù. ±×·¸Áö ¾ÊÀ¸¸é #Àº ¼Ó¼º ºÐ¸®±â·Î Ãë±ÞµË´Ï´Ù. $ dbh = dbi-> connect (qq {dbi : csv : csv_sep_char =;}); $ sth = $ dbh-> Áغñ ( "¼±Åà *¿¡¼­ ¼±ÅÃ"); # ¶È°°Àº ¿¹ :ÀÌ ½Ã°£Àº "info.csv"¸¦ Å×À̺í·Î ÀнÀ´Ï´Ù. $ dbh = dbi-> connect (qq {dbi : csv : csv_sep_char =;}); $ dbh -> {csv_tables '} -> {'Á¤º¸ '} = {'ÆÄÀÏ '=>'info.csv '}; $ sth = $ dbh-> Áغñ ( "Á¤º¸¿¡¼­ *¿¡¼­ ¼±ÅÃ"); DBD :: CSV ¸ðµâÀº DBI (PerlÀÇ µ¥ÀÌÅͺ£À̽º µ¶¸³ ÀÎÅÍÆäÀ̽º)ÀÇ ¶Ç ´Ù¸¥ µå¶óÀ̹öÀÔ´Ï´Ù. ÀÌ °ÍÀº SQL "Engine"SQL :: ¸í·É¹® ¹× Ãß»ó DBI µå¶óÀ̹ö DBD :: ÆÄÀÏÀ» ±â¹ÝÀ¸·ÎÇÏ°í ¼ÒÀ§ CSV ÆÄÀÏ (½°Ç¥·Î ±¸ºÐ µÈ °ª)¿¡ ´ëÇÑ ¾×¼¼½º¸¦ ±¸ÇöÇÕ´Ï´Ù. ÀÌ·¯ÇÑ ÆÄÀÏÀº MS Access ¹× MS Excel Data.see dbi (3)¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº DBI, SQL :: ¸í·É¹® (3)¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº SQL :: ¸í·É¹® ¹× DBD :: FILE (3)¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ Á¤º¸´Â ±âº» Ŭ·¡½º DBD :: ÆÄÀÏ. ¿ä±¸ »çÇ× : ¡¤ Perl.


DBD :: CSV. °ü·Ã ¼ÒÇÁÆ®¿þ¾î