Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I'm having a bit of trouble setting up a command for this, any tips? (MySQL) Update table room to set the value of column roomtype
I'm having a bit of trouble setting up a command for this, any tips? (MySQL)
Update table room to set the value of column roomtype equal to the corresponding id value in the table roomtype. This requires a select * from roomtype; to see what the id value is for each roomDesc. For example, in my database
a. 1 | Critical
b. 2 | Private
c. 3 | Semi-Private
I think i need to use a Join but I'm not sure, any tips are appreciated !
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started