2012/06/15 18:14 +0900, Tsubasa Tanaka
try to use `LOAD DATA INFILE' to import from CSV file.
http://dev.mysql.com/doc/refman/5.5/en/load-data.html
"Try" is the operative word: MySQL s character format is _like_ CSV, but not
the same. The treatment of NULL is doubtless the bigg
Let's see
SHOW CREATE TABLE ...
SELECT ...
It sounds doable with MySQL; might be too big for NOSQL.
> -Original Message-
> From: abhishek jain [mailto:abhishek.netj...@gmail.com]
> Sent: Friday, June 15, 2012 1:57 AM
> To: mysql@lists.mysql.com
> Subject: Which Database when lot of insert
Hello,
> I am designing a solution which will need me to import from CSV, i am using
> my JAVA code to parse. CSV file has 500K rows, and i need to do it thrice
> an hour, for 10 hours a day.
try to use `LOAD DATA INFILE' to import from CSV file.
http://dev.mysql.com/doc/refman/5.5/en/load-data.
cc: Kaarel <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject:Re: Which database?
On Tue, Jun 10, 2003 at 10:54:52AM -0400, Peter J. Milanese wrote:
Hey Kaarel-
I've been sticking with MySQL mostly for it's support. Large
community, lots of documentation, and they
there's a pretty good comparison on the MySQL website and they were quite
fair about it. MySQL has been adding features slowly because, above all,
they don't want to sacrifice performance for the feature. Each database
has its strengths. The bottom line is that you need to figure out just
w
subselects were slated for release with 5.0 Not 4.1
P
Jeremy Zawodny <[EMAIL PROTECTED]>
06/10/2003 11:21 AM
Please respond to mysql
To: "Peter J. Milanese" <[EMAIL PROTECTED]>
cc: Kaarel <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
mpany means you are unlikely to
get the same
level of support.'
P
Roman Neuhauser <[EMAIL PROTECTED]>
06/10/2003 09:42 AM
To: [EMAIL PROTECTED]
cc:
Subject: Re: Which database?
# [EMAIL PROTECTED] / 2003-06-10 14:11:39 +0100:
> (...)
On Tue, Jun 10, 2003 at 10:54:52AM -0400, Peter J. Milanese wrote:
> Hey Kaarel-
>
> I've been sticking with MySQL mostly for it's support. Large
> community, lots of documentation, and they have a future plan (which
> they tend to actually complete ahead of schedule).
Wow. You must be the first
Hey Kaarel-
I've been sticking with MySQL mostly for it's support. Large
community, lots of documentation, and they have a future plan (which they
tend to actually complete ahead of schedule). While the featureset is
'supposedly' not as advanced as pgsql, mysql does in fact work. I hit
Peter
-Original Message-
From: Roman Neuhauser [mailto:[EMAIL PROTECTED]
Sent: 10 June 2003 14:43
To: [EMAIL PROTECTED]
Subject: Re: Which database?
# [EMAIL PROTECTED] / 2003-06-10 14:11:39 +0100:
> (...) lack of commercial support company means you are unlikely to get
> th
# [EMAIL PROTECTED] / 2003-06-10 14:11:39 +0100:
> (...) lack of commercial support company means you are unlikely to get
> the same level of support.
unlikely? perhaps. but...
how many OS programs do you use, how many of them have commercial
support, and how do those that have co
Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 10 June 2003 14:04
To: [EMAIL PROTECTED]
Cc: Kaarel; [EMAIL PROTECTED]
Subject: Re: Which database?
> Actually, the license might turn out to be your biggest problem,
> especially if arter six months of developm
> Actually, the license might turn out to be your biggest problem,
> especially if arter six months of development it turns that you
> either have to pay for MySQL or rewrite your application using
> another database. Note that I don't know the MySQL AB pricing
> scheme, and
# [EMAIL PROTECTED] / 2003-06-10 14:38:49 +0300:
> I am fairly new to databases, but my boss has assigned me to choose a
> database system for our company. I know of Oracle databases but they are
> way too expensive so it's not an option for us. I did some research and
> came up with two free da
You're on the MySQL list, so expect biased answers.
Both certainly have their merits. PostgreSQL is currently more advanced, at
least if you go by their claims. Hoever, there seems to be much less support
for PostgreSQL than MySQL, be it from books or other users. While I expect to
use PostgreS
15 matches
Mail list logo
