Dear friends,
Load data infile 'abcd.txt' into table b.chicago;
This statement loads half of the data from file and gives error posted below.
Any guidance, please.
Thank you.
--
---
mysql use b
Database changed
Scott,
ASP.NET would be just fine !
Freddie
-Ursprüngliche Nachricht-
Von: Scott Hamm [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 20. August 2004 20:40
An: 'Mysql ' (E-mail)
Betreff: Brainstorming' time!
Looks like I will need more than just MySQL and Php/ASP.net.
I might
Many thanks for your reply Tom.
I will read it more closely over the week-end, but wanted to say thanks
straight away.
Kerry
-Original Message-
From: Tom Horstmann [mailto:[EMAIL PROTECTED]
Sent: 20 August 2004 15:52
To: 'Kerry Frater'; 'MySQL List'
Subject: RE: newbie question on
Hello This is probably real simple for someone that knows - I'm having a few
problems installing MySQL on a particular server (it's repairing a damaged
copy). I'd like to try and fix it myself so I'm recompiling with the
--with-debug option. If I manage to fix the problem, is there any overhead
mysql load data infile 'abcd.txt' into table b.chicago;
' for key 1 Duplicate entry '[EMAIL PROTECTED]
I think you have 2 e-mails that are equal in the file and the e-mail field is
declared as a primary key (which implies UNIQUE).
--
mack /
--
MySQL General Mailing List
For list archives:
Is there something wrong with this code ?
Still confused after reading the manual.
td?php echo
$rsJobShortDat-Fields('DATE_FORMAT('LFWJobBank'.'Entered','%m/%d/%Y'));
?/td
Entered is a timestamp column.
With the apostrophes off the table / column I get
errors about unexpected % .
Here is my
Stuart, why not change your select statement (assuming it is correct and
actually works, in and of itself) to give the date-formatted field an
alias:
SELECT
LFWJobBank.JobReferenceCode,DATE_FORMAT(LFWJobBank.Entered,'%m/%d/%Y') AS
date_entered,
LFWJobBank.DazeLeft, LFWJobBank.JobTitle
FROM
I had mysql running great on my Gentoo server, but
there was some kind of a problem with my host and my
machine had to be rebooted. I restart mysql with
/etc/init.d/mysql start (Gentoo syntax), but I'm
having some problems:
localhost / # mysqladmin test
mysqladmin: connect to server at
I've just installed gnome-db on my redhat system and am getting
familiar with how it works. I'm running mysql on the localhost, and
the problem right now is connecting my data sources. This seems to
require the gnomedb-mgr prog but I don't find it on my machine.
Documentation was not help, the
Terry , thank you .
The query worked on it's own, but within the PHP it
got thrown back. Alias worked well.
Sorry , sort of new to db / webdev.
Stuart
--- Terry Riley [EMAIL PROTECTED] wrote:
Stuart, why not change your select statement
(assuming it is correct and
actually works, in and
I am moving my database(s) from one server to another, did a full dump
of the data and have a large file with all the create instruction sets etc.
My question, what is the best way to recreate these db, tables etc. on
the new server. MySQL is already installed running.
Thanks
--
MySQL General
Dear friends,
I use following code
use databasea
load data infileabcd.txt' into table databasea.tablename;
Data gets loaded in table, however at the end of each record I see a square
symbol, the symbol usually we see in compiled code.
Can anyone give insight into these extra squares appearing
After 2 days in Microsoft HELL with my SQLsvr databases, I'm ready to rob the piggy
bank and build a new linux mysql server. Here's my problem: I have, at present, two
rather large databases. (A: 4Million records in one table, 15 Million in another; B:
1.5Million and 5Million) The
On Sat, 21 Aug 2004 10:18:06 -0700, Info [EMAIL PROTECTED] wrote:
After 2 days in Microsoft HELL with my SQLsvr databases, I'm ready to rob the piggy
bank and build a new linux mysql server. Here's my problem: I have, at present,
two rather large databases. (A: 4Million records in one
I have to agree with Chis on the single cpu box. We have been building
our own boxes using AMD Athlon 64 3400+. Make sure you get the chip
with 1mb cache. The hyperchannel on these make IO so much faster. A
couple of fast SATA drives in a raid config and you are ready to go. There
is a new
--- [EMAIL PROTECTED] wrote:
I posted this a little while ago, but it faded out
with very few responses
due to my not posting the necessary information, so
I seek to rectify my err
now.
Info:
OS: Windows XP
PHP: 5
Use: I'm looking for something that can easily
create and manage
At 11:02 AM 8/20/2004, you wrote:
Ok. I'm looking into alternatives. I'm trying to figure out an alternative
to mysql exporting into xls file. Is there any another way you can export
into file and make it readable? What format do you use? I'm open to ideas
from experienced database programmers :)
Hi!
On Aug 21, Robert Nagy wrote:
Hi. Can u point me to the fixed file(s) please?
Or can u send me the diff if you have it?
http://bugs.mysql.com/bug.php?id=3933
Roger, it is explained my reply to the bugreport, and in my reply to
you.
The bug is fixed in 4.0.21.
According to the manual
Stardate [040822 00:26]. Sergei Golubchik of Borg wrote:
Roger, it is explained my reply to the bugreport, and in my reply to
you.
Thanks I can read. But the question was not that.
http://www.mysql.com/doc/en/Installing_source_tree.html
I'd like to see the diff between the two revisions.
Hi!
On Aug 22, Robert Nagy wrote:
Stardate [040822 00:26]. Sergei Golubchik of Borg wrote:
Roger, it is explained my reply to the bugreport, and in my reply to
you.
Thanks I can read. But the question was not that.
http://www.mysql.com/doc/en/Installing_source_tree.html
I'd like to
Stardate [040822 01:45]. Sergei Golubchik of Borg wrote:
Ah, ok.
Here it is:
http://mysql.bkbits.net:8080/mysql-4.0/[EMAIL PROTECTED]
Regards,
Sergei
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
21 matches
Mail list logo