Professional Web Applications Themes

upload syntax question - MySQL

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 ...

  1. #1

    Default upload syntax question

    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 Guest

  2. #2

    Default Re: upload syntax question

    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 doentation 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.

    Bob Lanteigne Guest

Similar Threads

  1. Question about E4X syntax.
    By rpierich in forum Macromedia Flex General Discussion
    Replies: 7
    Last Post: May 27th, 06:12 AM
  2. Question on syntax...
    By Jonathan Villa in forum PHP Development
    Replies: 1
    Last Post: August 20th, 03:15 PM
  3. [PHP] Question on class syntax
    By Luis Lebron in forum PHP Development
    Replies: 3
    Last Post: August 7th, 07:07 PM
  4. SQL Syntax Question???
    By Kory in forum Macromedia Dreamweaver
    Replies: 2
    Last Post: July 10th, 10:57 PM
  5. Transact-SQL syntax question
    By Rajan Murthy in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 1st, 03:36 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139