Hi,
I am trying to load data into my table from a very large file but after some
time I get this error:
ERROR 2013 (HY000): Lost connection to MySQL server during query
My file size is around 4G and I have 220M lines in my file which have to be
loaded in to my table.
I have 10 of these
Il 01/03/2012 11:03, javad bakhshi ha scritto:
Hi,
I am trying to load data into my table from a very large file but after some
time I get this error:
ERROR 2013 (HY000): Lost connection to MySQL server during query
My file size is around 4G and I have 220M lines in my file which have to be
- Original Message -
From: Baron Schwartz ba...@xaprb.com
You may be interested in this:
http://www.mysqlperformanceblog.com/2009/09/28/how-number-of-columns-affects-performance/
Heeh, very interesting. You guys keep churning out the good stuff :-)
--
Bier met grenadyn
Is als
2012/02/29 11:43 -0500, Ed Patterson
The select concat() works from the command line
I can manually add the file name but would like to automate the process
Lastly, if it makes a difference, I don't use any graphical tools for DB stuff.
Look up the command!
By using your shell's variable substitution, I'm afraid.
export outfile='/path/to/file'
mysql -e select blah into outfile '$outfile'
You'll have to build a shell script or something that generates your filename,
and then do an interactive call.
Maybe you could write a stored procedure that
On 2/29/2012 5:54 PM, LUCi5R wrote:
JW,
I'm trying to understand LEFT JOIN as we go - but it's not working.
This query
SELECT *
FROM CUSTOMERS
LEFT JOIN CALLS ON CUSTOMERS.PHONE = CALLS.PHONE
WHERE CUSTOMERS.DATE = 02/28/12 AND (CALLS.PHONE IS NULL OR CALLS.DATE =
02/28/12)
Is
On Thu, Mar 1, 2012 at 8:57 AM, Shawn L Green shawn.l.gr...@oracle.comwrote:
On 2/29/2012 5:54 PM, LUCi5R wrote:
JW,
I'm trying to understand LEFT JOIN as we go - but it's not working.
This query
SELECT *
FROM CUSTOMERS
LEFT JOIN CALLS ON CUSTOMERS.PHONE = CALLS.PHONE
WHERE
On Feb 29, 2012, at 10:43 AM, Ed Patterson wrote:
Be kind, I am by no means any type of DB expert.
I would like to eventually move this to a stored procedure but for now I am
using the \. to fire it off.
Here is what I have so far (generating a list of machines missing software)
JW,
Youre correct .. that is what I was getting with the LEFT JOIN and
therefore it wasnt the correct answer.
I was able to get the correct answer using UNION ALL, however, like you
said, I needed 2 queries in that case. One to get the PHONE numbers from
both tables
and a 2nd query to get
SELECT *
FROM CUSTOMERS LEFT JOIN CALLS USING(PHONE) WHERE CUSTOMERS.DATE =
02/28/12 OR CALLS.DATE = 02/28/12
^^^ This is going into an endless loop; I'm not getting any result at all.
I'm not sure why. I haven't used USING before so I need to read up a bit on
that to understand what you're doing
-Original Message-
From: Shawn L Green [mailto:shawn.l.gr...@oracle.com]
Sent: Thursday, March 01, 2012 6:57 AM
To: luc...@luci5r.com
Cc: 'Johnny Withers'; mysql@lists.mysql.com
Subject: Re: Getting data from 2 tables if records have same date!
Try this:
SELECT *
FROM CUSTOMERS
LEFT
Stupid wrapping helped me to make a simple mistake. I wrote
On 3/1/2012 10:40 AM, LUCi5R wrote:
SELECT *
FROM CUSTOMERS
LEFT JOIN CALLS ON CUSTOMERS.PHONE = CALLS.PHONE AND
CUSTOMERS.DATE=CALLS.DATE = 02/28/12
But I meant it to be
SELECT *
FROM CUSTOMERS
LEFT JOIN CALLS ON CUSTOMERS.PHONE =
I would imagine the installer is 32-bit only just so they don't have to
release two versions of it.
I'm sure it'll allow you to download the 64-bit version of the server
though.
JW
On Thu, Mar 1, 2012 at 3:10 PM, Dotan Cohen dotanco...@gmail.com wrote:
Although 74 bit Windows 7 is listed as
On Thu, Mar 1, 2012 at 23:13, Johnny Withers joh...@pixelated.net wrote:
I would imagine the installer is 32-bit only just so they don't have to
release two versions of it.
I'm sure it'll allow you to download the 64-bit version of the server
though.
I see, thanks. I did not realise that a
Appreciate a little guidance here:
Background: I have an invoicing system. Invoices are generated and
(invoice and Invoice Items) and Payments are generated (Payments and
Payment Items). Payment items are amount of the Payment Total
allocated to payoff open invoices. So I may have 3 open
15 matches
Mail list logo