Posts by Filipe Martins • 146 points

• 2

  votes

  3

  answers

  2114

  views

  A: Insert if it does not exist or Update if it already exists in Mysql?

  You can try using the REPLACE INTO. He is similar to INSERT, but if the record to be inserted has the same value as a primary key or a unique index, the existing record is deleted and the new record…

  mysql

  answered 7 years, 6 months ago Filipe Martins 146

• 1

  votes

  1

  answer

  40

  views

  A: Query where result equals any of the values in the list

  You can try to use the claúsula IN in his SELECT. Ex: select dup_mes from duplicatas dup_mes IN ('01/2017', '02/2017', '03/2017')

  mysql sql select

  answered 7 years, 6 months ago Filipe Martins 146