Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

Parser LEFT something error

Eliarh's profile image Eliarh posted 3 years ago in General

before autoformat

SELECT CONCAT(LEFT(u.fio, LOCATE(" ", SUBSTRING_INDEX(u.fio," ",2))+1)) fio

after autoformat

SELECT CONCAT(
LEFT(u.fio, LOCATE(" ", SUBSTRING_INDEX(u.fio," ",2))+1)) fio
Eliarh's profile image Eliarh posted 3 months ago

up?

ansgar's profile image ansgar posted 3 months ago

What?

You should describe your problem more exactly. Noone wants to guess about the issue here.



Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.
Eliarh's profile image Eliarh posted 3 months ago

Why is the string wrapped? "LEFT "is a function, not"LEFT JOIN". In my opinion, the transfer should not be carried out.

ansgar's profile image ansgar posted 3 months ago

Yes, that's an issue in the quite simple pretty-print parser - it expects LEFT to be part of a JOIN.

It's probably worth to look for some external pretty-print library, which I can make use of in HeidiSQL's Delphi code. Do you know of some?

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