File size: 765 Bytes
530729e |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 |
// Copyright 2019 GoAdmin Core Team. All rights reserved.
// Use of this source code is governed by a Apache-2.0 style
// license that can be found in the LICENSE file.
package dialect
type mysql struct {
commonDialect
}
func (mysql) GetName() string {
return "mysql"
}
func (mysql) ShowColumnsWithComment(schema, table string) string {
return `SELECT
COLUMN_NAME Field, DATA_TYPE Type, IS_NULLABLE 'Null', COLUMN_KEY 'Key', COLUMN_DEFAULT 'Default', EXTRA Extra, COLUMN_COMMENT Comment
FROM information_schema.COLUMNS
WHERE
table_name = '` + table + `'
AND
table_schema = '` + schema + `'`
}
func (mysql) ShowColumns(table string) string {
return "show columns in " + table
}
func (mysql) ShowTables() string {
return "show tables"
}
|