asked on

Importing CSV to MySQL DB

Hello Experts,

When importing a csv file to a mysql db my neagtive numbers come in as zeros (0.00)

columns are decimal(50,2)

Any ideas?

johanntagle

What method are you using to import?

decoded

ASKER

i am using the GUI that Php admin provides. Is there something better solution.

johanntagle

Can you provide phpmyadmin version, structure of the table being imported to, and a sample csv file? I will try to replicate.

decoded

ASKER

Please see data example.
example.csv

i am currently MYSQL workbench to see it would help and same problem.

my db layout:

CREATE TABLE `er` (
  `Ticker` text NOT NULL,
  `CompanyName` text NOT NULL,
  `Exchange` text NOT NULL,
  `Shareout` decimal(50,2) NOT NULL,
  `Last` decimal(50,2) NOT NULL,
  `MarketCap` decimal(50,2) NOT NULL,
  `EnterpriseValue` decimal(50,2) NOT NULL,
  `Rev_LTM` decimal(50,2) NOT NULL,
  `Rev_NTM` decimal(50,2) NOT NULL,
  `EPS_LTM` decimal(50,2) NOT NULL,
  `EPS_NTM` decimal(50,2) NOT NULL,
  `EBITDA_LTM` decimal(50,2) NOT NULL,
  `EBITDA_NTM` decimal(50,2) NOT NULL,
  `EBIT_LTM` decimal(50,2) NOT NULL,
  `TotalDebt` decimal(50,2) NOT NULL,
  `Equity` decimal(50,2) NOT NULL,
  `WorkingCapital` decimal(50,2) NOT NULL,
  `TotalAssets` decimal(50,2) NOT NULL,
  `RetainedEarnings` decimal(50,2) NOT NULL,
  `Capex` decimal(50,2) NOT NULL,
  `OCF` decimal(50,2) NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=501 DEFAULT CHARSET=latin1$$

Open in new window

ASKER CERTIFIED SOLUTION

Insoftservice inso

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial