c Create table if one doesn't exist already. The field is skipped in both the CREATE clause and the INSERT clauses, i.e. Primary use is to avoid conflictsīetween field names and MySQL reserved keywords. Takes a list of field name/new field name pairs. File format is: 1st line: number ofĬharacters to convert (number of lines). Substitution ( -s), so you have to use dbf field names here. Primary use is to ease import ofĬomplex dbf files where we want only few fields.
List fields to insert into MySQL database. n Allow NULL fields: 'NOT NULL' will be not added in table creation statement. l Translate all text in the xBase file to lowercase. u Translate all text in the xBase file to uppercase. f Translate all field names in the xBase file to lowercase. vvv Even more verbose: produce a progress report. Mysql2dbf dumps a MySQL table to a dbf file. SYNOPSIS dbf2mysql ] ] ] ] ] dbf-file mysql2dbf ] -d database -t table dbf-file DESCRIPTION dbf2mysql takes an xBase file and sends queries to an MySQL server to insert it into an
Dbf2mysql, mysql2dbf - convert between xBase and MySQL databases
0 kommentar(er)
