I have never used MySQL but am guessing it is not like SQL for Oracle. My query says this:
set row_num=(select max(row_num)+1 from work_order)
and I am getting an error. Anyone know why?
Or maybe someone has an idea of how I can make a rownum in my table?