How to update a field using alias in mysql?

Question

I am having a table in mysql, and in that i am having two fields that is id and desc, now as desc is a mysql keyword, i am unable to update that field because mysql is giving syntax error, so i thought why not update that field by using alias, i used it but not working, is there any way to update that field using alias. Please help! I need it very badly. Thanks Ravinder

Tudor Constantin · Accepted Answer · 2011-10-15 05:19:09Z

1

Try with:

UPDATE t1 SET `desc`='NEW VAL'

Notice the single backquotes ( ` ) around the desc field name

answered Oct 15, 2011 at 5:19

Tudor Constantin

26.9k7 gold badges54 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to update a field using alias in mysql?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related