Automatically prompt for field names

Hiphonejohn's profile image Hiphonejohn posted 4 weeks ago in General Permalink

I hope that While I typing field name , HeidiSQL can prompt the correct fieldname of the current table.

ansgar's profile image ansgar posted 4 weeks ago Permalink

Yes it can. You need to use Ctrl Space to show the completion proposal, then it shows the columns, and below of them the databases and functions.

grafik.png

Hiphonejohn's profile image Hiphonejohn posted 4 weeks ago Permalink

Bro, I mean While I writing a query SQL In query page ! I have tried to use Ctrl and Space in query page

Hiphonejohn's profile image Hiphonejohn posted 4 weeks ago Permalink

I hope like this as the attachment

1 attachment(s):
  • 20260115-162000
ansgar's profile image ansgar posted 4 weeks ago Permalink

That's working in HeidiSQL:

grafik.png

Hiphonejohn's profile image Hiphonejohn posted 4 weeks ago Permalink

I have tried Using Ctrl + Space key, but it's Not working, you can check my attachment. My HeidiSQL Version is 12.14.0.7169

1 attachment(s):
  • 20260115-191548
ansgar's profile image ansgar posted 4 weeks ago Permalink

Try to use a table alias:

grafik.png

ansgar's profile image ansgar posted 4 weeks ago Permalink

And check whether you have enabled the completion proposal:

grafik.png

Hiphonejohn's profile image Hiphonejohn posted 4 weeks ago Permalink

Thank you, Bro ,It's ok now

Hiphonejohn's profile image Hiphonejohn posted 3 weeks ago Permalink

Bro, Can we make some changes for the field automatic prompting, We can query the fields of table in advance while user have typed a table name instead of typing the alias (PS:it will take some time to waite for query fiels)

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