Autocomplete enum / set fields

When i have 

`type` enum('air','sea','euro') NOT NULL DEFAULT 'air',

And write a query 

orders.type="sea"

it will be fine to autocomplete variables

1
3 comments

Hello Denis,

What database and sql dialect are you working with? Can you please provide complete code with DDL?

0
Avatar
Permanently deleted user

I'm working on MySQL and there is a DDL you can test with.

CREATE TABLE enum_autocomplete (
value ENUM('book', 'paper', 'essay') NOT NULL PRIMARY KEY
)
;


INSERT INTO enum_autocomplete VALUE ('book');
INSERT INTO enum_autocomplete VALUE ('paper');
INSERT INTO enum_autocomplete VALUE ('essay');

 


Really looking forward to this feature.

0

Please sign in to leave a comment.