Posts

Showing posts from October, 2019

Select multiple tables (normal approach)

example SELECT name , price , photo FROM drinks , drinks_photos WHERE drinks . id = drink_photos.drinks_id https://stackoverflow.com/questions/12890071/select-from-multiple-tables-mysql

Mysql having clause

The SQL HAVING Clause The HAVING clause was added to SQL because the WHERE keyword could not be used with aggregate functions. HAVING Syntax SELECT column_name(s) FROM table_name WHERE condition GROUP BY column_name(s) HAVING condition ORDER BY column_name(s); Resource: https://www.w3schools.com/sql/sql_having.asp