MySQL Part 4 - English

Play
Current Time 0:00
/
Duration Time 0:00
Remaining Time -0:00
Loaded: 0%
Progress: 0%
0:00
Fullscreen
00:00
Mute
Captions
  • captions off
  • English

10065 visits



Outline:

MySQL (Part 4) Getting data from the database table and displaying it. SELECT QUERY - SELECT * FROM table_name WHERE att1='abc' // Query returns the value from the database where att1 = abc mysql_num_rows() - Gives us the number of rows there are in the query we have just given out. ORDER BY - Helps to order the output result as when selecting the values form the database. Use of DESC for Descending ordering / ASC for Ascending ordering