mysql update statement
I added a new column to my table,
what I want to do is to update this empty column ( totalamount) with piece x price ( piece multiple by price )
I wrote this update sentence like this but it didn't work
UPDATE order SET totalamount= (piece*price)
what's wrong with it?
what I want to do is to update this empty column ( totalamount) with piece x price ( piece multiple by price )
I wrote this update sentence like this but it didn't work
UPDATE order SET totalamount= (piece*price)
what's wrong with it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You are welcome.
ASKER
as you said, I check the database and I found my mistake.
Thank you Julian Hansen