UseExtSyntax Property

In This Topic

Determines whether to use extended syntax of INSERT on data insertion.

Syntax

Visual Basic
C#

'Declaration
 
Public Property UseExtSyntax As Boolean

public bool UseExtSyntax {get; set;}

Property Value

true, if extended syntax of INSERT on data insertion is used; otherwise, false. The default value is false.

Remarks

When set to true, all data in the table will be inserted within a single SQL statement. This form of INSERT statement requires less amount of data to transfer and may execute faster.

Example

This sample demonstrates dumping of two tables (Dept and Emp). The script is written to a file after the operation is complete.

csharp

public void DumpIt(MySqlConnection myConnection)
{
  myConnection.Open();
  MySqlDump mySqlDump = new MySqlDump();
  mySqlDump.Connection = myConnection;
  myConnection.Database = "Test";
  mySqlDump.UseExtSyntax = true;
  mySqlDump.Tables = "Emp;Dept";
  mySqlDump.Backup();
  StreamWriter stream = new StreamWriter("d:\\tmp\\mysqldump.dmp");
  stream.WriteLine(mySqlDump.DumpText);
  stream.Close();
  Console.WriteLine("Dumped.");
  myConnection.Close();
}

Visual Basic

Public Sub DumpIt(ByVal myConnection As MySqlConnection)
  myConnection.Open()
  Dim mySqlDump As MySqlDump = New MySqlDump
  mySqlDump.Connection = myConnection
  mySqlDump.UseExtSyntax = True
  mySqlDump.Tables = "Emp;Dept"
  mySqlDump.Backup()
  Dim stream As StreamWriter = New StreamWriter("d:\tmp\mysqldump.dmp")
  stream.WriteLine(mySqlDump.DumpText)
  stream.Close()
  Console.WriteLine("Dumped.")
  myConnection.Close()
End Sub

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

MySqlDump Class
MySqlDump Members

Send Feedback