Parameters
- condition
- A new condition to add.
MySqlSelectStatement stmt = new MySqlSelectStatement(); stmt.Columns.Add(new SelectColumn("EMP")); stmt.Columns.Add(new SelectColumn("SAL")); stmt.Tables.Add(new SelectTable("emp")); stmt.AddHavingCondition("SAL > 1000"); //select JOB,SAL from emp having SAL > 1000 MySqlCommand command = new MySqlCommand(stmt.ToString());
Dim stmt As New MySqlSelectStatement stmt.Columns.Add(New SelectColumn("EMP")) stmt.Columns.Add(New SelectColumn("SAL")) stmt.Tables.Add(New SelectTable("emp")) stmt.AddHavingCondition("SAL > 1000") 'select JOB,SAL from emp having SAL > 1000 Dim command As New MySqlCommand(stmt.ToString)