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

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

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    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 | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jun 2009
    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