Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
5
Newest
 Editor
Impact
~4k people reached

  • 0 posts edited
  • 0 helpful flags
  • 3 votes cast
Mar
11
revised Optimise MySQL SELECT with LEFT JOIN subquery
deleted 14 characters in body
Mar
11
revised Optimise MySQL SELECT with LEFT JOIN subquery
edited body
Mar
11
awarded  Editor
Mar
11
comment Optimise MySQL SELECT with LEFT JOIN subquery
@ypercubeᵀᴹ would the syntax error be caused by list as it is a reserved keyword? I have updated question to fix this and added an explanation of the statement.
Mar
11
revised Optimise MySQL SELECT with LEFT JOIN subquery
added 14 characters in body
Mar
11
asked Optimise MySQL SELECT with LEFT JOIN subquery
Feb
4
awarded  Popular Question
Jul
2
comment Grouping results based on link table
Thanks, it was the UNION ALL query I was looking for.
Jul
2
accepted Grouping results based on link table
Jul
1
asked Grouping results based on link table
Jun
17
accepted MySQL Benchmark on FreeBSD and Ubuntu
Jun
17
comment Using a mysqldump export to create data with a different database name
Thanks. Just for reference. I discovered that using --databases db_name in the mysqldump resulted in the USE db_name in the export. So the following is a guide to working dump with no USE nor CREATE: mysqldump -u root -p db_name --no-create-db > path/export.sql
Jun
17
accepted Using a mysqldump export to create data with a different database name
Jun
17
asked Using a mysqldump export to create data with a different database name
Jan
30
awarded  Scholar
Jan
30
accepted Slow MySQL query with Order and Group by
Jan
30
comment Slow MySQL query with Order and Group by
Thanks, your answer has really helped!
Jan
30
awarded  Supporter
Jan
29
asked Slow MySQL query with Order and Group by
Dec
4
answered MySQL Benchmark on FreeBSD and Ubuntu