同样的代码
$emp = new Emp();
$list = $emp->where(['name' => ['like', '%潘%']])->column('emp_id');
dump($list);
$list = $emp->where(['name' => ['like', '%潘%']])->column('name', 'emp_id');
dump($list);
dump(array_keys($list));
dump(['aaa', 'bbb', 'ccc']);当是mysql数据库的时候E:\web\example\tp5\thinkphp\library\think\Debug.php:165:
array (size=3)
0 => string '1011' (length=4)
1 => string '1908' (length=4)
2 => string '1909' (length=4)
E:\web\example\tp5\thinkphp\library\think\Debug.php:165:
array (size=3)
1011 => string '潘学进' (length=9)
1908 => string '潘继红' (length=9)
1909 => string '潘自忠' (length=9)
E:\web\example\tp5\thinkphp\library\think\Debug.php:165:
array (size=3)
0 => int 1011
1 => int 1908
2 => int 1909
E:\web\example\tp5\thinkphp\library\think\Debug.php:165:
array (size=3)
0 => string 'aaa' (length=3)
1 => string 'bbb' (length=3)
2 => string 'ccc' (length=3)注意上面column(name, id),id反而是key值。不知道是不是故意这样设计的当是mssql的时候
E:\web\example\tp5\thinkphp\library\think\Debug.php:165:
array (size=3)
1011 => string '1' (length=1)
1908 => string '2' (length=1)
1909 => string '3' (length=1)
E:\web\example\tp5\thinkphp\library\think\Debug.php:165:
array (size=3)
1011 =>
array (size=3)
'emp_id' => string '1011' (length=4)
'name' => string '潘学进' (length=9)
'ROW_NUMBER' => string '1' (length=1)
1908 =>
array (size=3)
'emp_id' => string '1908' (length=4)
'name' => string '潘继红' (length=9)
'ROW_NUMBER' => string '2' (length=1)
1909 =>
array (size=3)
'emp_id' => string '1909' (length=4)
'name' => string '潘自忠' (length=9)
'ROW_NUMBER' => string '3' (length=1)
E:\web\example\tp5\thinkphp\library\think\Debug.php:165:
array (size=3)
0 => int 1011
1 => int 1908
2 => int 1909
E:\web\example\tp5\thinkphp\library\think\Debug.php:165:
array (size=3)
0 => string 'aaa' (length=3)
1 => string 'bbb' (length=3)
2 => string 'ccc' (length=3)明显多字段查询时column(name, id)，在不同数据库中表现形式完全不一样，怎么兼容？ 最佳答案
