메모/에러 메모

[ MYSQL ] * is not valid at this position for this server version

surimi🍥 2021. 4. 4. 23:36
반응형

# 에러 예시

 

"SELECT" is not valid at this position for this server version, expecting ~~~~

"DROP" is not valid at this position for this server version, expecting ~~~~

"CREATE" is not valid at this position for this server version, expecting ~~~~

 

# 해결

 

주로 문법이 맞지않는 query를 입력했을때 나오는 에러.

 

# 관련 문서

 

stackoverflow.com/questions/53471882/mysql-workbench-reports-is-not-valid-at-this-position-for-this-server-version

 

MySQL Workbench reports "is not valid at this position for this server version" error

For the following SQL query: SELECT COUNT (distinct first_name) from actor; I receive the following error message: "SELECT" is not valid at this position for this server version, expecting: '(',...

stackoverflow.com

urakasumi.tistory.com/220

 

[ MYSQL ] No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar.

# 에러 전문 Error Code: 1046. No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar. 0.000 sec # 해결법 Query 창에서 CREATE DATABASE [..

urakasumi.tistory.com

 

반응형