Posts by Matheus Piano • 1 point

• 0

  votes

  1

  answer

  802

  views

  A: SQL Error (1093): You can’t specify target table 'import2016' for update in FROM clause

  I managed to solve using the concept that @Rovann Linhalis said: in subquerie, you put the alias of the import2016 table as the [import2016 as a], but the select column was only column4, without the…

  mysql stored-procedures

  answered 6 years, 8 months ago Matheus Piano 1

• 0

  votes

  1

  answer

  802

  views

  Q: SQL Error (1093): You can’t specify target table 'import2016' for update in FROM clause

  I am running this PROCEDURE, and it returns this error! BEGIN SET @cont = 0; REPEAT SET @sqlstring = "UPDATE import2016 SET coluna4 = (SELECT coluna4 FROM import2016 AS a WHERE a.coluna2 ='' and…

  mysql stored-procedures

  asked 6 years, 8 months ago Matheus Piano 1