Home > database >  MySQL data after the library employees use orderby why would become like this?
MySQL data after the library employees use orderby why would become like this?

Time:11-18

In the library https://github.com/datacharmer/test_db
Use this statement first_name column value will become Aamer, other Aamod, Abdelaziz one of three values
 select * from employees order by first_name 


Here is no data from Orderby
 select * from employees 

CodePudding user response:

Order by is sorting, so use the first_name sort this field, this field inside a the beginning of the row to the front

CodePudding user response:

reference 1/f, February 16 response:
order by is sorting, so use the first_name sort this field, this field is at the beginning of a line to the front inside

Find the reason, the table data has a line of 300024 then the default display only 500 lines,,,,
  • Related