parse error

[xinlushi]

func main() {
sql := "SELECT * FROM table WHERE a = 'abc'"
stmt, err := sqlparser.Parse(sql)
if err != nil {
fmt.Printf("%s",err.Error())
}

// Otherwise do something with stmt
switch stmt := stmt.(type) {
case *sqlparser.Select:
	_ = stmt
case *sqlparser.Insert:
}

fmt.Printf("stmt :%v", stmt)

}

result err: syntax error at position 20 near 'table'

[bramp]

Table is a reserved word. Either wrap it in backtics or use a different name for your table.

…

On Fri, 10 Sep 2021, 12:58 am xinlushi, ***@***.***> wrote: func main() { sql := "SELECT * FROM table WHERE a = 'abc'" stmt, err := sqlparser.Parse(sql) if err != nil { fmt.Printf("%s",err.Error()) } // Otherwise do something with stmt switch stmt := stmt.(type) { case *sqlparser.Select: _ = stmt case *sqlparser.Insert: } fmt.Printf("stmt :%v", stmt) } result err: syntax error at position 20 near 'table'stmt : — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#68>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AABHG4YUIQS3UPWCFL6U2B3UBG3A3ANCNFSM5DYZCVUA> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

[xinlushi]

Please replace the example, this is the code of the example

[Mrsandman327]

There is a table in the database ‘information_schema’ as ‘tables’, this problem causes this table to be accessed abnormally