hi,
I have a database from dbf file that has almost 100 thousands records, when I
import them into mysql, it is only imported 13359 records.
my table structure is like this:
`faktur` varchar(10) NOT NULL,
`tgl` date default NULL,
`tgl_terima` date default NULL,
`kontan` varchar(1) default NULL,
`cust` varchar(10) default NULL,
`slm` varchar(3) default NULL,
`term` bigint(3) default NULL,
`muka` decimal(8,2) default NULL,
`disc1` decimal(4,2) default NULL,
`ndisc1` decimal(10,2) default NULL,
`ppn` decimal(4,2) default NULL,
`mtr` decimal(8,2) default NULL,
`netto` decimal(12,2) default NULL,
`ket` varchar(30) default NULL,
`total` decimal(12,2) default NULL,
`f_pajak` varchar(10) default NULL,
`tgl_pajak` date default NULL,
`ncust` varchar(30) default NULL,
`wil` varchar(3) default NULL,
`so` varchar(10) default NULL,
`satuan` varchar(1) default NULL,
`post` varchar(1) default NULL,
`vlt` varchar(3) default NULL,
`tukar` decimal(4,2) default NULL,
`sj1` varchar(10) default NULL,
`sj2` varchar(10) default NULL,
`sj3` varchar(10) default NULL,
`sj4` varchar(10) default NULL,
`sj5` varchar(10) default NULL,
`disc2` decimal(4,2) default NULL,
`ndisc2` decimal(10,2) default NULL,
`disc3` decimal(4,2) default NULL,
`ndisc3` decimal(10,2) default NULL,
I am wondering how I can enlarge the capacity of the table.
I am looking forward to a favorable reply from you. Thank you.
---------------------------------
Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.
