generate sql using HeidiSQL

mysql sql heidisql
Syafiq Azwan picture Syafiq Azwan · Sep 14, 2015 · Viewed 12.7k times · Source

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

Syafiq Azwan picture Syafiq Azwan · Sep 21, 2015

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

Related questions

mysql Foreign key constraint is incorrectly formed error

I have two tables, table1 is the parent table with a column ID and table2 with a column IDFromTable1 (not the actual name) when I put a FK on IDFromTable1 to ID in table1 I get the error Foreign key …

Read More
How to create table in MariaDB?

When I try to create simple table via HeidiSQL I'm getting an error like this CREATE TABLE `prg_config` ( `id` INT NULL AUTO_INCREMENT, `name` VARCHAR(50) NULL DEFAULT '', `value` VARCHAR NULL DEFAULT '' ) COLLATE='utf8_bin';

Read More
sql if exists update else insert not working

i have a table with 3 generic keys which are also foreign keys. This is my query -- IF (EXISTS(SELECT * FROM table1 WHERE col_1 =4)) BEGIN UPDATE table1 SET col_2 = 3, col_3 = 100 WHERE col_1 = 4 END ELSE BEGIN INSERT INTO table1 (col_1, col_2, …

Read More