tour icon indicating copy to clipboard operation
tour copied to clipboard

query建议使用 ` ` 引用

Open LaChimere opened this issue 4 years ago • 0 comments

https://github.com/go-programming-tour-book/tour/blob/7a9f824862e3950418f112b846ee8e49d05f1572/internal/sql2struct/mysql.go#L85 建议改为

query := `SELECT COLUMN_NAME, DATA_TYPE, COLUMN_KEY,
		IS_NULLABLE, COLUMN_TYPE, COLUMN_COMMENT 
		FROM COLUMNS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ?`

如果使用 " " 引号,可能出现 dbModel: GetColumns err: Error 1054: Unknown column '...' in 'field list'的 error

LaChimere avatar Feb 25 '21 12:02 LaChimere