0x00 记忆方式
limit 0,1 into @,@,@,@,x
0x01 实验
# 可以很明显看得到是3列
mysql> select * from users limit 0,1;
+----+----------+----------+
| id | username | password |
+----+----------+----------+
| 1 | Dumb | Dumb |
+----+----------+----------+
1 row in set (0.00 sec)
# 输入 into @时爆列名不一致了
mysql> select * from users limit 0,1 into @;
1222 - The used SELECT statements have a different number of columns
# 输入 into @,@,@ 时显示ok了,说明 tdb_admin表 列数为 3
mysql> select * from users limit 0,1 into @1,@2,@3;
Query OK, 1 row affected