xwb1989 / sqlparser

SQL Parser implemented in Go
Apache License 2.0
1.49k stars 240 forks source link

Does it support "SELECT * FROM 11111.table1" ? #78

Open liyinxin opened 5 months ago

liyinxin commented 5 months ago

Does it support "SELECT * FROM 11111.table1" ?

I get this erorr: SQL parsing error:syntax error at position 21 near '11111.'

bramp commented 5 months ago

I don't think that's a valid database/table identifier. Try wrapping it in backticks.

SELECT * FROM `11111`.table1
liyinxin commented 5 months ago

OK, I will try it

liyinxin commented 5 months ago

SELECT * FROM11111.table1

Thanks it works.