Feature Request: Avoid Column Names In Sql File

[Graycode]

Currently the package produces the table column names on every INSERT statement.

---

insert into `mytbl`(`columna`,`columnb`,`columnc`,`columnd`) values ('a1', 'b1', 'c1', 'd1');

insert into `mytbl`(`columna`,`columnb`,`columnc`,`columnd`) values ('ax', 'bx', 'cx', 'dx');

---

That is fine for many uses, but the repetition of column names adds quite a bit of size to the SQL file. It would be helpful if there was an option to avoid the reproduction of column names.

---

insert into `mytbl` values ('a1', 'b1', 'c1', 'd1');

insert into `mytbl` values ('ax', 'bx', 'cx', 'dx');

---

Without the column names on the INSERT, the database assumes the same column order as the table definition. This makes having the column names irrelevant in backup / recovery scenarios, especially when the schema is exported along with the data in the SQL file.

Thank you for any consideration.

[peterlaursen]

Actually we changed that about 1 year ago to create FULL insert statements.

That was a repeated user request actually .. and I think you can't make everybody happy!

Two comments:

1) If you use BULK inserts like 

Code:

insert into `mytbl`(`columna`,`columnb`,`columnc`,`columnd`) values ('a1', 'b1', 'c1', 'd1'),('a2', 'b2', 'c2', 'd2')…('an', 'bn', 'cn', 'dn'); 

.. the 'overhead' won't be much

Read about BULKs and CHUNKs here: http://www.webyog.com/faq/24_101_en.html

2) The (scheduled) backup powertool of the ENTERPRISE version has the option to use FULL inserts or not.  See image.

[Graycode]

The Bulk and Chunk options don't do what I want, and I don't always know an advanced schedule of when I'll want a dump. It would be a useful option to either have or not have the columns listed.

I suppose you're correct in not being able to make everyone happy (at least not all the time).

Thanks anyway!!

PS – The (*.cpp) are missing from the Community version 5.22a zip.

[peterlaursen]

Still the backup 'powertool' of ENTERPRISE version has the option.

the .zip.  

Strange!  we just downloaded and unzipped, and everything is there!

[Graycode]

peterlaursen wrote on Jan 17 2007, 11:17 PM:

Strange!  we just downloaded and unzipped, and everything is there!

Strange indeed. I downloaded again, still got the same. Used 3 different ZIP packages, none shows any *.cpp files. It has build, include, and lib but has no src subdirectory. Used raw editor to look at the zip binary, no *.cpp filenames seen. The zip file size is 5,828,270 bytes :huh:

[peterlaursen]

My mistake.  I checked the wrong file.

You are right!

[adarsh]

Its seems to be a mistake when we replace the source from 5.22 to 5.22a. Now we uploaded correct source.

here is the link to download.

http://www.webyog.com/en/downloads.php

Adarsh

webyog

[Author]

Posts