0x00 记忆方式

limit 0,1 into @,@,@,@,x

0x01 实验

# 可以很明显看得到是3列
mysql> select * from tdb_admin limit 0,1;
+----+----------+----------------------------------+
| id | username | password                         |
+----+----------+----------------------------------+
|  1 | admin    | 7fef6171469e80d32c0559f88b377245 |
+----+----------+----------------------------------+
1 row in set

# 输入 into @时爆列名不一致了
mysql> select * from tdb_admin limit 0,1 into  @;
1222 - The used SELECT statements have a different number of columns

# 输入 into @,@,@ 时显示ok了,说明 tdb_admin表 列数为 3
mysql> select * from tdb_admin limit 0,1 into  @,@,@;
Query OK, 1 row affected