How do I paginate query results using database/sql with MySQL?

To paginate query results using the database/sql package with MySQL in Go, you typically use the SQL LIMIT and OFFSET clauses. This approach allows you to fetch a specific subset of results from your database, facilitating the pagination process.

Below is an example of how to implement pagination in Go using database/sql:


        package main

        import (
            "database/sql"
            "fmt"
            "log"

            _ "github.com/go-sql-driver/mysql"
        )

        func main() {
            // Open a database connection
            db, err := sql.Open("mysql", "user:password@/dbname")
            if err != nil {
                log.Fatal(err)
            }
            defer db.Close()

            // Define pagination parameters
            page := 1      // current page number
            itemsPerPage := 10 // number of items per page
            offset := (page - 1) * itemsPerPage

            // Prepare the SQL query with LIMIT and OFFSET
            query := fmt.Sprintf("SELECT * FROM items LIMIT %d OFFSET %d", itemsPerPage, offset)

            // Execute the query
            rows, err := db.Query(query)
            if err != nil {
                log.Fatal(err)
            }
            defer rows.Close()

            // Iterate through the rows
            for rows.Next() {
                var id int
                var name string
                if err := rows.Scan(&id, &name); err != nil {
                    log.Fatal(err)
                }
                fmt.Printf("%d: %s\n", id, name)
            }

            // Check for errors from iterating over rows
            if err := rows.Err(); err != nil {
                log.Fatal(err)
            }
        }

Go MySQL pagination database/sql LIMIT OFFSET example code

How do I paginate query results using database/sql with MySQL?

Popular Topics

Recent Languages

How do I paginate query results using database/sql with MySQL?

Related Questions

Popular Topics

Recent Languages