MySqlSelectLimit Class

In This Topic

Represents MySQL LIMIT clause. Represents MySQL LIMIT clause.

Syntax

Visual Basic
C#

'Declaration
 
Public NotInheritable Class MySqlSelectLimit 
   Inherits Devart.Common.SelectStatementNode

public sealed class MySqlSelectLimit : Devart.Common.SelectStatementNode

Example

The following example shows how the LIMIT clause may be parsed in a MySqlSelectStatement.

csharp

static void ParseLimit(string sql) {

  MySqlSelectStatement stmt = MySqlSelectStatement.Parse(sql, ParserBehavior.All);

  if (stmt.Limit != null)
  if (stmt.Limit.Offset != null)
    Console.WriteLine("Offset: {0}, Count: {1}", stmt.Limit.Offset.ToString(), stmt.Limit.Count.ToString());
  else
    Console.WriteLine("Count: {0}", stmt.Limit.Count.ToString());
  else
  Console.WriteLine("No limit found");
}

....

ParseLimit("select * from dept limit 3"); // Count: 3
ParseLimit("select * from dept limit 2, 3"); // Offset: 2, Count: 3
ParseLimit("select * from dept limit 3 offset 2"); // Offset: 2, Count: 3

ParseLimit("select * from dept limit :pCount"); // Count: :pCount
ParseLimit("select * from dept limit :pOffset, :pCount"); // Offset: :pOffset, Count: :pCount
ParseLimit("select * from dept limit :pCount offset :pOffset"); // Offset: :pOffset, Count: :pCount

ParseLimit("select * from dept limit @pCount"); // Count: @pCount
ParseLimit("select * from dept limit @pOffset, @pCount"); // Offset: @pOffset, Count: @pCount
ParseLimit("select * from dept limit @pCount offset @pOffset"); // Offset: @pOffset, Count: @pCount

ParseLimit("select * from dept limit ?"); // Count: ?
ParseLimit("select * from dept limit ?, ?"); // Offset: ?, Count: ?
ParseLimit("select * from dept limit ? offset ?"); // Offset: ?, Count: ?

Visual Basic

Private Shared Sub ParseLimit(ByVal sql As String)
  Dim stmt As MySqlSelectStatement = MySqlSelectStatement.Parse(sql, 63)
  If (Not stmt.Limit Is Nothing) Then
    If (Not stmt.Limit.Offset Is Nothing) Then
      Console.WriteLine("Offset: {0}, Count: {1}", stmt.Limit.Offset.ToString, stmt.Limit.Count.ToString)
    Else
      Console.WriteLine("Count: {0}", stmt.Limit.Count.ToString)
    End If
  Else
    Console.WriteLine("No limit found")
  End If
End Sub

...................

Module1.ParseLimit("select * from dept limit 3")
Module1.ParseLimit("select * from dept limit 2, 3")
Module1.ParseLimit("select * from dept limit 3 offset 2")

Module1.ParseLimit("select * from dept limit :pCount")
Module1.ParseLimit("select * from dept limit :pOffset, :pCount")
Module1.ParseLimit("select * from dept limit :pCount offset :pOffset")

Module1.ParseLimit("select * from dept limit @pCount")
Module1.ParseLimit("select * from dept limit @pOffset, @pCount")
Module1.ParseLimit("select * from dept limit @pCount offset @pOffset")

Module1.ParseLimit("select * from dept limit ?")
Module1.ParseLimit("select * from dept limit ?, ?")
Module1.ParseLimit("select * from dept limit ? offset ?")

Inheritance Hierarchy

System.Object
Devart.Common.SelectStatementNode
Devart.Data.MySql.MySqlSelectLimit

Reference

MySqlSelectLimit Members
Devart.Data.MySql Namespace
Limit Property

Send Feedback