select 'id', 'name' from `stu_score`;
结果显示
+----+------+
| id | name |
+----+------+
| id | name |
| id | name |
| id | name |
| id | name |
| id | name |
| id | name |
+----+------+
请问这是为什么?
select 'id', 'name' from `stu_score`;
结果显示
+----+------+
| id | name |
+----+------+
| id | name |
| id | name |
| id | name |
| id | name |
| id | name |
| id | name |
+----+------+
请问这是为什么?
单引号' 用于字符串的引用
数据库、表、索引、列和别名用`
改成
select `id`, `name` from `stu_score`;