Post

Alias-Parenthesis Error

Posted
By Jin Lee
1 min read

alias

  • alias 에 () 괄호 사용 불가
1
2
3
4
5
6

select
min(fare),
max(fare),
round(avg(fare),2) as avg(fare)
from titanic;

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘(fare) from titanic’ at line 4 0.000 sec

Database, db-error
sql error database
This post is licensed under CC BY 4.0 by the author.