generate sql using HeidiSQL

Question

I would like to ask is there any config that allow HeidiSQL to generate INSERT query that look like:

INSERT INTO state SET ST_ID = NULL, ST_NAME = "lol"

instead of:

INSERT INTO state (ST_ID, ST_NAME) VALUES (NULL, 'lol')

Answer 1

Solution:

1. Select a table in heidi
2. In the query tab, select desired column from the right panel.
3. Right click on the selected column and select 'Generate Update..'
4. In the generated query, change the 'UPDATE' command to 'INSERT INTO'.
5. Delete the 'WHERE' command