Best answer

mySQL - row vs ID

  • 22 February 2022
  • 4 replies
  • 230 views

Hi, I’m trying to use the mySQL action ‘update row’. When mapping fields there are two required fields: row and id. I have the ID from a previous step but don’t know what is being asked for with the ‘row’ field. 

What am I needing to provide beyond the ID of the row?

Thanks!

 

icon

Best answer by NormC 22 February 2022, 20:06

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Userlevel 7
Badge +14

Hi @NormC 

Row is for the Row ID

ID Column is for indicating the column that has the primary key.

Check out this help article: https://zapier.com/help/doc/database-service-de-duplication#i-dont-have-a-unique-id-column

Thanks @Troy Tessalone , appreciate the help.

Here is a portion of my table:

 

So for this would the row be the number and Id be ‘Id’? Like so?

 

Userlevel 7
Badge +14

@NormC 

Give that configuration a try.

Close. The column name is case-sensitive. id worked, Id did not. Thanks for the help getting this working!