Thank you very much. I really appreciate your analogy to the waterfall.
This helped me out tremendously. I was able to sort out the problem and
all is now well! It appears that this wonderful little GUI tool the
lets you create ER diagrams that auto-generate CREATE scripts assumes
that you
I'm a total newbie to mySQL, but was hoping someone could answer a
question regarding adding a record into a database that has foreign key
constraints. Remember, I'm a total newbie so I'm hoping I'm using the
right words to express this. I'm taking a class that required us to use
an ER
Michael Gale [EMAIL PROTECTED] wrote:
I have a question about data loading using mysql 4.0.20. If you need to load
let's say 50,000 items into a database.
Now 50,000 is not a lot for a DB.
So my question is would it be fast to load the file using the local infile which
Hello,
I have a question about data loading using mysql 4.0.20. If you need to load
let's say 50,000 items into a database.
Now 50,000 is not a lot for a DB.
So my question is would it be fast to load the file using the local infile which is a
security concern or should I be
using
infile is a lot faster.
Matthew McNicol
Michael Gale wrote:
Hello,
I have a question about data loading using mysql 4.0.20. If you need to load let's say 50,000 items into a database.
Now 50,000 is not a lot for a DB.
So my question is would it be fast to load the file using the local infile
hi all..
i'm using mysql with php4 to develop an online ordering system.
the problem:
when it comes to save, retrieve/view and update data into mysql database, it
takes a long time for the page to load.
the problem occurs after we insert / key in data ( a lot types of data ), after
we click
Because mysql needs 'rx' permissions to read and search the directory.
755 should have been sufficient.
Menard, Inc. Information Systems wrote:
I figured it out but I'm a bit confused as to why it happened.
I'm running the load as user1. The file resides at /home/user1/data/filename
-Original Message-
From: Menard, Inc. Information Systems [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 8:26 AM
To: Jay Blanchard; [EMAIL PROTECTED]
Subject: RE: Newbie--Easy data loading question
yes. I tried all of these methods:
1) //dir1//dir2//file
2) /dir1/dir2/file
-Original Message-
From: Menard, Inc. Information Systems
Sent: Friday, May 24, 2002 3:44 PM
I figured it out but I'm a bit confused as to why it happened.
I'm running the load as user1. The file resides at
/home/user1/data/filename
Permissions:
filename 666
data 777
user1 700
Hello
Forgive me for being a little naive but.
I am trying to load a table with a text file using the load data infile
command in mysql. I can do it if I place the
text file in the db directory, but I want it to reside in a different dir. I
am getting the error 13: Can't get stat on
did you supply the /full/path/to/the/file/ ?
-Original Message-
From: Menard, Inc. Information Systems [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 8:15 AM
To: [EMAIL PROTECTED]
Subject: Newbie--Easy data loading question
Hello
Forgive me for being a little naive but.
I
not to go there.
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 8:22 AM
To: 'Menard, Inc. Information Systems'; [EMAIL PROTECTED]
Subject: RE: Newbie--Easy data loading question
did you supply the /full/path/to/the/file/ ?
-Original Message
have to do that???
Thanks
Jake
-Original Message-
From: Menard, Inc. Information Systems [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 8:26 AM
To: Jay Blanchard; [EMAIL PROTECTED]
Subject: RE: Newbie--Easy data loading question
yes. I tried all of these methods:
1) //dir1//dir2
13 matches
Mail list logo
