posted 11 years ago
Good day,
Assume i have a lookup table School like following:
Table School structure:
and following table SchoolTransferring with following structure ([] - empty/no value):
I need to update both fromSchoolId and toSchoolId at the same time where the id coming from lookup table School, but do i have chance to do it in once from single update query instead of calling another query to do so?
Below is my try in mySQL :