I just bought some web space which has mysql capabilities..... I am using
SSH and have created a database and a table........ now I would like to
populate the table by using a text file which is stored on my home
computer......... could someone please give me the syntax for this because
the mysql book I am using "SQL Queries for Mere Mortals" by M. Hernandez
although very good for demonstrating SQL queries does not seem to indicate
just how to get the data uploaded into your table !

I do have ftp capabilities also which I am using to upload my .html files
to my web space area, but I guess I don't know how to access the database
area with ftp or even if that is the way to do it...... thanks for any
help.... if you know of a good book which explains this , that would be good
too.....

don wrote:
> I just bought some web space which has mysql capabilities..... I am using
> SSH and have created a database and a table........ now I would like to
> populate the table by using a text file which is stored on my home
> computer......... could someone please give me the syntax for this because
> the mysql book I am using "SQL Queries for Mere Mortals" by M. Hernandez
> although very good for demonstrating SQL queries does not seem to indicate
> just how to get the data uploaded into your table !
>
> I do have ftp capabilities also which I am using to upload my .html files
> to my web space area, but I guess I don't know how to access the database
> area with ftp or even if that is the way to do it...... thanks for any
> help.... if you know of a good book which explains this , that would be good
> too.....

Have a look at the documentation for the mysqlimport utility. If you
have an account with remote access to the MySQL server you can use it
to load the contents of a local file to the database.

Bob.