Why is it recommended to use "order by id DESC limit 1" instead of max('Id') in a MySQL query?

When using max('Id') in a MySQL query, it can be less efficient as it requires scanning the entire table to find the maximum value. On the other hand, using "order by id DESC limit 1" is more efficient as it directly retrieves the last row without the need to scan the entire table. This can lead to better performance, especially with large datasets. 

// Using "order by id DESC limit 1" to efficiently retrieve the last row in a MySQL table

$query = "SELECT * FROM your_table ORDER BY id DESC LIMIT 1";
$result = mysqli_query($connection, $query);

// Fetch the data from the result
$row = mysqli_fetch_assoc($result);

// Access the values using $row['column_name']

Keywords

PHP MySQL order by DESC limit

Related Questions