Re: Data loading and foreign key constraints - help please

2004-08-30 Thread Todd Cranston-Cuebas
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 won'

Re: Data loading

2004-08-02 Thread Egor Egorov
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 is

Re: Data loading

2004-07-30 Thread Matthew McNicol
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 wh