256 Kilobytes

Answers in Databases | By Some Guy

Published

510 views, 0 RAMs, and 1 comment

Tags: MySQL, Database, Errors, Join, Programming, Query

Profile Photo - Some GuySome GuyBasic Subscriber

I am working on my new website, but when creating a table in mySQL I get "Every derived table must have it's own alias".Is there something I have to do before creating it?

Download more RAM. 🐏 ⨉ 0Posted by Some Guy 2 years ago 🕓 Posted at 16 December, 2018 09:40 AM PST

This is a debug account.

Profile Photo - UnivaUnivaAuthor

Imagine a table called purchases that records purchases made by customers at stores, i.e., it's a many to many, and the software needs to know which customers have made purchases at more than one store:

SELECT DISTINCT customer_id, SUM(1)
  FROM ( SELECT DISTINCT customer_id, store_id FROM purchases)
  GROUP BY customer_id HAVING 1 < SUM(1);
..will break with the error Every derived table must have its alias. To fix:
SELECT DISTINCT customer_id, SUM(1)
  FROM ( SELECT DISTINCT customer_id, store_id FROM purchases) AS custom
  GROUP BY customer_id HAVING 1 < SUM(1);

Download more RAM. 🐏 ⨉ 0Posted by Univa 2 years ago 🕓 Posted at 05 May, 2019 03:27 AM PDT

Hello.

Post a New Comment

Do you like having a good time?

Register an Account

You can also login to an existing account or reset your password. All use of this site is subject to the terms of service and privacy policy.

Read Quality Articles

Read some quality articles. If you can manage to not get banned for like five minutes, you can even post your own articles.

View Articles →

Argue with People on the Internet

Use your account to explain why people are wrong on the Internet forum.

View Forum →

Vandalize the Wiki

Or don't. I'm not your dad.

View Wiki →

Ask and/or Answer Questions

If someone asks a terrible question, post a LMGTFY link.

View Answers →

Make Some Money

Hire freelancers and/or advertise your goods and/or services. Hire people directly. We're not a middleman or your dad. Manage your own business transactions.

Register an Account

Answers— Read More

Find more related content below!