MySqlSelectStatement Constructor

In This Topic

Creates a new instance of the MySqlSelectStatement class.

Syntax

Visual Basic
C#


'Declaration Public Function New()


public MySqlSelectStatement()

Example

The following example demonstrates how to use the MySqlSelectStatement constructor.

csharp


MySqlSelectStatement stmt = new MySqlSelectStatement(); stmt.Columns.Add(new SelectColumn("JOB")); stmt.Tables.Add(new SelectTable("emp")); stmt.Distinct = true; //select distinct JOB from emp string queryText = stmt.ToString();

MySqlSelectStatement stmt = new MySqlSelectStatement();
stmt.Columns.Add(new SelectColumn("JOB"));
stmt.Tables.Add(new SelectTable("emp"));

stmt.Distinct = true;

//select distinct JOB from emp
string queryText = stmt.ToString();

Visual Basic


Dim stmt As New MySqlSelectStatement stmt.Columns.Add(New SelectColumn("JOB")) stmt.Tables.Add(New SelectTable("emp")) stmt.Distinct = True 'select distinct JOB from emp Dim queryText As String = stmt.ToString

Dim stmt As New MySqlSelectStatement
stmt.Columns.Add(New SelectColumn("JOB"))
stmt.Tables.Add(New SelectTable("emp"))
stmt.Distinct = True

'select distinct JOB from emp
Dim queryText As String = stmt.ToString

Reference

MySqlSelectStatement Class
MySqlSelectStatement Members

Send Feedback