0

I am trying to alter a table to change one of my column values to datediff() but I keep getting an error and I don't see where my issue is. Here is my code

alter table bids
modify column 'timeLeft' datediff(curdate(),'dueDate');
Brian Tompsett - 汤莱恩
  • 5,753
  • 72
  • 57
  • 129
user2635024
  • 37
  • 4

1 Answers1

-1

if you are trying to change values you should not be using alter table you should be using UPDATE

skv
  • 1,793
  • 3
  • 19
  • 27