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.

Parser LEFT something error

Eliarh's profile image Eliarh posted 4 years ago in General Permalink

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 11 months ago Permalink

up?

ansgar's profile image ansgar posted 11 months ago Permalink

What?

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

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.
Eliarh's profile image Eliarh posted 11 months ago Permalink

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 11 months ago Permalink

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.