Importing Data from CSV file into MySQL, Scientific Notation -

-

i using load data infile read csv , insert mysql table. problem 1 column in csv in scientific notation , when read , loaded table won't go column of type double, float, or real. there solution this?

114,2015-05-11 00:00:00.000,0,100,14,2.576927e+10,1.730594e+10,1.904524e+10,1.788426e+10,69.40149

in 1 row of csv scientific notation values when loaded via load data infile become 100000


Comments

Post a Comment

Popular posts from this blog

Upgrade php version of xampp not success -

-
today decided upgrade xampp new php version (5.6.11). have downloaded , configured based on google said. after resetting server, runs successfully. when check xampp's phpinfo, has not been updated. screenshot what have missed? back htdocs files , database. download xampp . uninstall xampp control panel. manually remove xampp folder partition. install back problem solved
Read more

amazon web services - S3 and apache mod_proxy with basic authentication -

-
i'd redirect s3 bucket in ssl basic authentication of files (apk files) apache mod_proxy. ssl , mod_proxy work, basic authentication ignored. <virtualhost *:443> servername resources.mydomain.jp <filesmatch "\.apk$"> order deny,allow setenvif user-agent ".*android.*" allow_ag options followsymlinks allow env=allow_ag deny authtype basic authname "secret zone" authuserfile /etc/httpd/.htpasswd require user xxx_customer </filesmatch> sslengine on sslproxyengine on sslprotocol -all +sslv3 +tlsv1 sslciphersuite all:!adh:rc4+rsa:+high:+medium:-low:-sslv2:-exp sslcertificatefile conf.d/xxx.cer sslcertificatekeyfile conf.d/xxx.key sslcacertificatefile conf.d/xxx.cer proxypass / http://resources.mydomain.jp.s3-website-ap-zone-1.amazonaws.com/ proxypa...
Read more

powershell - This solution contains one or more assemblies targeted for the global assembly cache -

-
Image
i having sharepoint site deployed through sharepoint powershell. wsp build through visual studio 2013. all projects in solution not signed assemblies(project->right click->properties->signing->sign assemblies check box unchecked). taking wsp of solution publishing , deploying sharepoint using sharepoint powershell. when try this, getting following error: when googled solution. many of them suggesting check 'sign assemblies' check box. don't want do, because facing other issues packages install through nugget. sign libraries of solution go properties of project click signing tab , check sign libraries options , create new strong name file or without password , rebuild , deploy.
Read more