Skip to content
Advertisement

MySQL query fails on syntax [closed]

I have the following query. It fails I think on the CompanyBranch table_id=1122; varchar , statement, however I am not able to clearly identify the problem, mainly because it is InnoDB, which I lack experience with…

Advertisement

Answer

I’ve modified your code and it’s working. I removed the table_id=1122 and changed varchar to varchar(50) on lines 20, 22, 23 & 24.

db<>fiddle here

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement