Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.69 KB | None | 0 0
  1. $ dbf2mysql -vvv -q -h localhost -P password -U root smb/C_clist.DBF -d opera_dbf -t pricelists -c
  2. Opening dbf-file smb/C_clist.DBF
  3. dbf-file: smb/C_clist.DBF - Visual FoxPro w. DBC, MySQL-dbase: opera_dbf, MySQL-table: pricelists
  4. Number of records: 12
  5. Name Length Display Type
  6. -------------------------------------
  7. CL_CODE 8 0 C
  8. CL_DESC 30 0 C
  9. CL_CURR 3 0 C
  10. CL_FCDEC 1 0 N
  11. Making connection to MySQL-server
  12. Dropping original table (if one exists)
  13. Building CREATE-clause
  14. Sending create-clause
  15. CREATE TABLE pricelists (CL_CODE varchar(8) not null,
  16. CL_DESC varchar(30) not null,
  17. CL_CURR varchar(3) not null,
  18. CL_FCDEC int not null)
  19.  
  20. fields in dbh 4, allocated mem for query 279, query size 139
  21. Inserting records
  22. Inserting record 0
  23. LOAD DATA LOCAL INFILE '/tmp/d2mygo04TM' REPLACE INTO table pricelists fields terminated by ',' enclosed by ''''
  24. Closing up....
  25.  
  26. mysql> use opera_dbf;
  27. Reading table information for completion of table and column names
  28. You can turn off this feature to get a quicker startup with -A
  29.  
  30. Database changed
  31. mysql> describe pricelists;
  32. +----------+-------------+------+-----+---------+-------+
  33. | Field | Type | Null | Key | Default | Extra |
  34. +----------+-------------+------+-----+---------+-------+
  35. | CL_CODE | varchar(8) | NO | | NULL | |
  36. | CL_DESC | varchar(30) | NO | | NULL | |
  37. | CL_CURR | varchar(3) | NO | | NULL | |
  38. | CL_FCDEC | int(11) | NO | | NULL | |
  39. +----------+-------------+------+-----+---------+-------+
  40. 4 rows in set (0.13 sec)
  41.  
  42. mysql> select * from pricelists;
  43. Empty set (0.00 sec)
  44.  
  45. mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement