Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Need Help

forums › forums › SQLyog › Using SQLyog › Need Help

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • July 3, 2009 at 5:40 pm #29305
      peterlaursen
      Participant

      REPLACE .. SELECT .. explained here: http://dev.mysql.com/doc/refman/5.1/en/replace.html

      REPLACE [LOW_PRIORITY | DELAYED]

      [INTO] tbl_name [(col_name,…)]

      SELECT …

      .. but the problem is that the SELECT part of your statement is not a valid SQ-statement.

      Try

      1) using *full syntax* like tablename.columnname for every column in the SELECT-part

      2) what is the silly paranthesis before 'combat_reach' supposed to do?

      3) the table-list must be seperated by commas

      like

      REPLACE table_1 (col_1, col_2, col_3)

      SELECT table_x.col_m, table_y.col_n, table_z.col_o

      FROM table_x. table_y. table_x

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.