Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009
    Posts
    33

    Unanswered: Huge MYSQL Insert

    hi, I'm having trouble figuring out what's wrong with this mysql insert statement.

    It was actually exported from another database via phpmyadmin, then placed within an xml file (so that it executes during a Joomla component installation).

    Unfortunately, Joomla is returning an error message regarding the syntax.

    Here's a link -> http://www.bobscottsinsights.com/syntax.sql

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    there's nothing wrong with it, other than the fact that it contains two INSERT statements

    (i ran it via HeidiSQL, which has no problem handling multiple SQL statements in a single file)

    use a text editor, split the two INSERT statements into separate .sql files, and try running them separately
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jun 2009
    Posts
    33
    perfect! Thanks a lot man, I didn't see that second Insert.


Posting Permissions

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