Row number mysql

Mysql num rows

//number of rows retrieved from a query
<?php

$link = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("database", $link);

$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);

echo "$num_rows Rows\n";

?>

Source: php.net

Row number mysql

SELECT row_number() over ( order by firstName) RowNumberSqeuence,FirstName from rowNumberDemo
 order by FirstName;

Source: tutorialspoint.com

Mysql row_number() example

SET @row_number = 0; 
SELECT 
    (@row_number:=@row_number + 1) AS num, 
    firstName, 
    lastName
FROM
    employees
ORDER BY firstName, lastName    
LIMIT 5;

Source: mysqltutorial.org

Similar codes

0 vote175 views1 answer
Add alternate add column sql
SQL
0 vote234 views1 answer
Sql server remove primary key without dropping table
SQL
4 votes184 views2 answers
How to insert ip address in mysql using php
SQL
13 votes202 views2 answers
Oracle inner join
SQL
6 votes181 views2 answers
Drop foreign key
SQL
0 vote169 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote187 views1 answer
Foreign key multiple columns
SQL
16 votes204 views1 answer
Mysql smallint range
SQL
4 votes187 views1 answer
T-sql get duplicate rows
SQL
5 votes245 views2 answers
Add days in oracle sql
SQL