home *** CD-ROM | disk | FTP | other *** search
/ Chip 2000 April / Chip_2000-04_cd.bin / sharewar / DBF / Sample.scp < prev   
Text File  |  1999-09-25  |  2KB  |  41 lines

  1. ;***********************************************************************
  2. ;                        DBF2MySQL  demo script
  3. ;                  Copyright (C) by Alexander Eltsyn 
  4. ;                 E-mail: ae@nica.ru, a.eltsyn@usa.net
  5. ;                     WWW: http://www.nica.ru/~ae
  6. ;***********************************************************************
  7. ;
  8. ; Script format description:
  9. ;
  10. ; <dbf_file_name>,<mysql_table_name>,<ReCreate>,<delete_rows>,<TargetCP>{,<dbf_field_name>=<mysql_field_name>}
  11. ;
  12. ; Where:
  13. ;
  14. ;  <dbf_file_name>      - file name to transfer data from
  15. ;  <mysql_table_name>   - table name to transfer data to
  16. ;  <ReCreate>           - Recreate MySQL table structure. Possible values:
  17. ;                         0: leave table structure unchanged
  18. ;                         1: drop table and create new trable structure
  19. ;                            according to .DBF file.
  20. ;  <delete_rows>        - empty table before data transfer. Values:
  21. ;                         0: append .DBF data into table
  22. ;                         1: delete all existing data before data transfer
  23. ;  <TargetCP>           - Target code page. Values:
  24. ;                         0: Current Windows codepage
  25. ;                         1: Russian KOI-8
  26. ;                         2: Russian MS-DOS (866)
  27. ;                         3: OEM
  28. ;  <dbf_field_name>=<mysql_field_name> - associate DBF field name 
  29. ;                         with mysql field name. Empty value in
  30. ;                         <mysql_filed_name> means, that field should 
  31. ;                         not be transfered
  32. ;
  33. ; ! All of the arguments may be quoted with `"`
  34. ;
  35. ;Example of script lines
  36. ".\db\abit.dbf", abit, 1, 1, 1, lock=""
  37. ;
  38. ;db\stud.dbf, abit, 0, 1, 0, lock=
  39. ;
  40.  
  41.