Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Reformat SQL issue

roger-u's profile image roger-u posted 2 years ago in General Permalink

I had this as part of a longer SQL statement: LEFT JOIN ww_paynotes y ON p.semail = y.semail

but after using the Reformat SQL it becomes: LEFT JOIN ww_paynotes Y ON p.semail = y.semail

the alias letter y becomes uppercase - which can cause an error on Databasesdepending on their case sensitivity

it only seems to happen with the alias letter y e.g. LEFT JOIN ww_paynotes w ON p.semail = w.semail if not altered

HeidiSQL 8.0.0.4396

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.