shane18 Posted June 25, 2010 Share Posted June 25, 2010 What is the best way to write the SELECT query to count rows in a table? SELECT NULL FROM `movies` ???? If it is the best way, what is it doing exactly? Link to comment https://forums.phpfreaks.com/topic/205811-count-query/ Share on other sites More sharing options...
ChemicalBliss Posted June 25, 2010 Share Posted June 25, 2010 Sorry to be blunt: http://lmgtfy.com/?q=mysql+count -cb- Link to comment https://forums.phpfreaks.com/topic/205811-count-query/#findComment-1076970 Share on other sites More sharing options...
pengu Posted June 25, 2010 Share Posted June 25, 2010 Sorry to be blunt: http://lmgtfy.com/?q=mysql+count -cb- Had no idea of that website. Will be using that in the future. SELECT count(column) AS ColumnCount FROM movies Link to comment https://forums.phpfreaks.com/topic/205811-count-query/#findComment-1076974 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.