MySQL code mistaken for MSSQL and results in Intellisense syntax errors

Question

An .sql file in my VS Code workspace contains MySQL code. Even though I have installed two plugins (MySQL and MySQL Syntax), my IDE still recognizes this file with MSSQL and generates syntax errors.

Of course, this does not prevent me from running my program and I can always set the syntax highlighting to None. But I'd rather have VS Code recognize the language for all of my files.

Answer 1

I had this problem. Solved it by uninstalling the mssql extension. Didn't even realise I'd installed it, but it seems I accidentally did through that 'recommended extension' popup that vscode sends up frequently. You may have installed it as well, and because mssql is Microsoft, it's overriding any other sql types.