html data

Discussion in 'MySQL' started by arunsuriindia, Mar 3, 2007.

0
  1. #1
    can we upload a table in html to mysql

    if yes

    kindly give an example in which we ignore few lines also
     
    arunsuriindia, Mar 3, 2007 IP
  2. ArtInt

    ArtInt Active Member

    Messages:
    26
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    86
    #2
    I'm don't understand what you want. Express your thought clearly please.
     
    ArtInt, Mar 3, 2007 IP
  3. bidder

    bidder Active Member

    Messages:
    431
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    60
    #3
    You can upload (insert) html table into mysql
    nothing to ignored. must complete table tag
     
    bidder, Mar 5, 2007 IP
  4. ecom-solution.net

    ecom-solution.net Banned

    Messages:
    100
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #4
    yes you can. just use the sql script ;)
     
    ecom-solution.net, Mar 5, 2007 IP
  5. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,606
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #5
    you can import multiple types of data, just make sure your data is escaped correctly prior to insertion.
     
    ccoonen, Mar 5, 2007 IP
  6. arunsuriindia

    arunsuriindia Peon

    Messages:
    61
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    thanx
    bidder
    ecom-solution.net
     
    arunsuriindia, Mar 7, 2007 IP
  7. arunsuriindia

    arunsuriindia Peon

    Messages:
    61
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    cocoonen u seem to be very confident of it.well i am not .

    can u show me a simple example
     
    arunsuriindia, Mar 12, 2007 IP
  8. arunsuriindia

    arunsuriindia Peon

    Messages:
    61
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    load data infile 'c:/a.html' into table mcx lines starting by '<tr>' terminated by '</tr>' ignore 3 lines

    this doesn`t seem to help me
     
    arunsuriindia, Mar 12, 2007 IP