mysql 查询表内ini类型的栏位或列 生成数组
function get_init_field($table){
//$table=$this->request->param('model');
$dbname = Config::get('database.database');
$prefix = Config::get('database.prefix');
$sql="select COLUMN_NAME ,DATA_TYPE from information_schema.COLUMNS where TABLE_SCHEMA = ? and table_name = ? and DATA_TYPE = 'int'";
$columnList = Db::query($sql, [$dbname, $table]);
$fieldlist = [];
foreach ($columnList as $index => $item) {
$fieldlist[] = $item['COLUMN_NAME'];
}
return json($fieldlist);
}
名词解释
$table 即为表名
$dbname 数据库名
$prefix 数据库前缀
命令
select COLUMN_NAME ,DATA_TYPE from information_schema.COLUMNS where TABLE_SCHEMA ='washbox' and table_name = 'fa_user' and DATA_TYPE = 'int';