Gets or sets the command delimiter that is used in the script by default, i.e., before the DELIMITER statement is explicitly called.
public string Delimiter {get; set;}
'Declaration
Public Property Delimiter As String
Property Value
The command delimiter that is used in the script by default.
In the following sample, the script creates a stored procedure and then inserts a row into the Dept table. The delimiter is set to '&&' via the Delimiter property for creating the procedure, and then changed back to default semicolon via the DELIMITER statement.
MySqlScript script = new MySqlScript();
script.Connection = mySqlConnection1;
script.Delimiter = "&&";
script.ScriptText = @"
CREATE PROCEDURE procedure1 (OUT c INT)
BEGIN
select count(*) from Dept into c;
END&&
DELIMITER ;
INSERT INTO Dept VALUES (100, 'New dept', 'New York');
";
script.Execute();
Dim script As New MySqlScript()
script.Connection = mySqlConnection1
script.Delimiter = "&&"
script.ScriptText = _
"CREATE PROCEDURE procedure1 (OUT c INT) " & vbCrLf & _
" BEGIN" & vbCrLf & _
" select count(*) from Dept into c;" & vbCrLf & _
" END&& & _" & vbCrLf & _
"DELIMITER ; & _" & vbCrLf & _
"INSERT INTO Dept VALUES (100, 'New dept', 'New York'); "
script.Execute()
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