List:General Discussion« Previous MessageNext Message »
From:Eko Budiharto Date:May 20 2006 2:31am
Subject:limit
View as plain text  
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.
Thread
limitEko Budiharto20 May
  • Re: limitJay Pipes22 May