On Mon, 22 Nov 2004 11:50:38 -0300, Daniel da Veiga wrote:
>John Fitzsimons wrote:
>>On Sun, 21 Nov 2004 06:32:40 -0500, Patrick Questembert wrote:
Hi Daniel,
< snip >
>Sincerely, MySQL is the best open source database ever, it has
>everything a newbie would need to create/populate a database, if you
>know the basic about databases and SQL its possible to create a table
>azap, if you don't, even Access would be difficult to deal with. If you
>want your database to be stable and reliable, than you'll have to type
>and understand the commands, else you'll get even more errors, mouse
>clicks do what a programmer told the program to do, not always the best
>choice.
Well, I HAVE spent time learning a computer language before and it
was NOT one of my fun experiences. Interesting, yes. Something I
would want to repeat, no. At my age it gets increasingly difficult to
remember dozens/hundreds of different command syntax's.
Going through hundreds of pages of instructions/manuals is not easy
IMO. The key to good searching is in knowing what one should be
searching for. Not an easy thing for a newbie. I have however come
across a GUI approach so fortunately this issue is less of a problem
for me now.
>>>if
>>>you do a search on "load data infile MySQL" the first match you get is what
>>>you need: http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
Knowing what one should be searching for is a great help. Many thanks
for your guidance/patience.
< snip >
>All MySQL executables are in your /bin directory,
Okay. Thanks.
>where they can be reached by command prompt,
Not so easy if it is on one's hosting server. I have had minimal
experience with Telnet clients.
>they'll give you their syntax, and the manual
>will tell you exactly what each command will do. The mysqlimport client
>is the "mysqlimport" binary, that was designed to load data into MySQL
>from a number of different sources.
Okay.
< snip >
>If you already have a table, you can export its definition and data in
>form of a .sql file, that when imported, will create and populate the
>table,
That's what I had thought.
< snip >
Thanks again for taking the time to explain things. It certainly helps
and is appreciated.
Regards, John.
