Python MySQL Limit







googletag.cmd.push(function() { googletag.display('div-gpt-ad-1422003450156-2'); });



Python MySQL Limit



❮ Previous
Next ❯


Limit the Result


You can limit the number of records returned from the query, by using the "LIMIT" statement:




Example


Select the 5 first records in the "customers" table:



import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
 
user="yourusername",
  passwd="yourpassword",
  database="mydatabase"
)

mycursor =
mydb.cursor()

mycursor.execute("SELECT * FROM customers LIMIT 5")

myresult = mycursor.fetchall()

for x in
myresult:
  print(x)

Run example »



Start From Another Position


If you want to return five records, starting from the third record, you
can use the "OFFSET" keyword:



Example


Start from position 3, and return 5 records:



import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
 
user="yourusername",
  passwd="yourpassword",
  database="mydatabase"
)

mycursor =
mydb.cursor()

mycursor.execute("SELECT * FROM customers LIMIT 5
OFFSET 2")

myresult = mycursor.fetchall()

for x in
myresult:
  print(x)

Run example »




❮ Previous
Next ❯

-

Popular posts from this blog

Python Lists

<!-- main_leaderboard, all: [728,90][970,90][320,50][468,60] --> Python Lists ❮ Previous Next ❯ Python Collections (Arrays) There are four collection data types in the Python programming language: List is a collection which is ordered and changeable. Allows duplicate members. Tuple is a collection which is ordered and unchangeable. Allows duplicate members. Set is a collection which is unordered and unindexed. No duplicate members. Dictionary is a collection which is unordered, changeable and indexed. No duplicate members. When choosing a collection type, it is useful to understand the properties of that type. Choosing the right type for a particular data set could mean retention of meaning, and, it could mean an increase in efficiency or security. List A list is a collection which is ordered and changeable. In Python lists are written with square brackets. Example Create a List: thislist = ["apple", "banana", ...
Read more

Aion

Image
Aion - 6+ , 5417 Aion - . MMORPG, World of Warcraft, World of Tanks My Lineage II . CryEngine. , . : Aion https://ru.4game.com/aion/ Aion , . , , . , , . , , , . . , , , . . : . , . , , . , , . 12 , 2 : ( ). ( ). ( ). ( ) ( ). ( ). , . , : . . , . , , . . , , . Aion, , . , . , . : . . . . , : , , , , , . , , , . : Aion https://ru.4game.com/aion/install/ : . , . , . , Aion . , . . , . , . , , . . : . . . , ( !), MMORPG Aion . , . ...
Read more

JavaScript Array Iteration Methods

<!-- main_leaderboard, all: [728,90][970,90][320,50][468,60] --> JavaScript Array Iteration Methods ❮ Previous Next ❯ Array iteration methods operate on every array item. Array.forEach() The forEach() method Calls a function once for each array element. Example var txt = ""; var numbers = [4, 9, 16, 25]; numbers.forEach(myFunction); function myFunction(value, index, array) {     txt = txt + item + "<br>"; } Try it Yourself » Note that the function takes 3 arguments: The item value The item index The array itself Array.forEach() is not supported in Internet Explorer 8 or earlier: Method forEach() Yes 9.0 Yes Yes Yes Array.map() The map() method creates a new array by performing a function on each array element. This example multiplies each array value by 2: Example var numbers1 = [4, 9, 16, 25]; var numbers2 = numbers1.map(myFunction); function m...
Read more