#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2010
    Posts
    17
    Rep Power
    0

    How to get data from email attachment into MySQL


    I'm a total beginner at MySQL.
    Got an email attachment that I need to put into MySQL.
    Don't know what format it's in.

    How do you import something like that into MySQL ?
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,178
    Rep Power
    4274
    Originally Posted by lwfg
    Got an email attachment that I need to put into MySQL.
    why?


    Originally Posted by lwfg
    Don't know what format it's in.
    why not?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2010
    Posts
    17
    Rep Power
    0
    Hello.
    It was forwarded to me that way. I don't know why.
    Will try to find out the format.
  6. #4
  7. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,178
    Rep Power
    4274
    Originally Posted by lwfg
    It was forwarded to me that way. I don't know why.
    what i meant was, why do you feel you have to put it into mysql?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2010
    Posts
    17
    Rep Power
    0
    It's for work and I have to.
    Can't find format yet, told it might be a script so looking for way in MySQLWorkbench.
    Would be happy for advice.
  10. #6
  11. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,178
    Rep Power
    4274
    if it's a script, you should be able to open it in any text editor (e.g. notepad)

    to get it into mysql, you need to execute it (not sure what this is called in workbench)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo