Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (20.3k points)

I keep getting MySQL error #1054 when trying to perform this update query:

UPDATE MASTER_USER_PROFILE, TRAN_USER_BRANCH

SET MASTER_USER_PROFILE.fellow=`y`

WHERE MASTER_USER_PROFILE.USER_ID = TRAN_USER_BRANCH.USER_ID

AND TRAN_USER_BRANCH.BRANCH_ID = 17

It's probably some syntax error, but I've tried using an inner join instead and other alterations, but I keep getting the same message:

Unknown column 'y' in 'field list' 

1 Answer

0 votes
by (40.7k points)

Use different quotes for "y" as the identifier quote character is the backtick (“`”). Or else,  MySQL "thinks" that you point to a column named "y".

For more information, you can refer to MySQL 5 Documentation

You can learn in-depth about SQL statements, queries and become proficient in SQL queries by enrolling in our industry-recognized Microsoft SQL server certification.

Related questions

0 votes
1 answer
asked Jul 18, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
0 votes
1 answer

31k questions

32.9k answers

500 comments

693 users

Browse Categories

...