使用适当的引号从MySQL 5.7 information_schema.columns获取默认列值的方法是通过执行SQL查询语句,结合使用引号来获取默认列值。具体步骤如下:
SELECT column_name, table_name, column_default
FROM information_schema.columns
WHERE table_schema = 'your_database_name'
AND table_name = 'your_table_name';
+--------------+------------+----------------+
| column_name | table_name | column_default |
+--------------+------------+----------------+
| id | my_table | NULL |
| name | my_table | 'John' |
| age | my_table | 18 |
+--------------+------------+----------------+
默认列值:'John'
腾讯云相关产品和产品介绍链接地址:
领取专属 10元无门槛券
手把手带您无忧上云