EPUB | CHM | PDF

TMySQLDump.Properties.CompleteInsert

Top Previous Next

note Since v2.6.1

An option to include the field names in INSERT command.

Syntax:

CompleteInsert : Boolean;

Description:

CompleteInsert set in True generates INSERT SQL Statement with field names.

For example, CompleteInsert = False generates the following SQL statements:

INSERT INTO TableName VALUES (value1, value2, ...);

And CompleteInsert = True generates the following SQL statements:

INSERT INTO TableName(fieldname1, fieldname2, ...) VALUES (value1, value2, ...);

See also: ExtInsert property