How do I create a script that assigns a value to a new column in MySQL?
I have opportunities that are listed more than once and I need to create a column that ensures its only counted once. Here's a visual example of what I am trying to accomplish Example data: And what I mean to do is assign a value in a new column the first time its encountered and 0 for every time after. So the opportunity…
