mysql - 从 mysql 表中获取 Data_type

Question

我使用这段代码:

select data_type from information_schema.columns where table_name = '$tableName' and column_name = '$column_name'

但是在 echo 之后，它返回 1。但是当我在 phpmyadmin sql 中运行它时，它返回列的 data_type。

我想要 Mysql 表列的 data_type(我正在使用 Wordpress)。

Answer 1

you can simply get the datatype as below. where ever you like . you can change different data_type by changing the value of "$tableName" and "$column_name" below

<?php
global $wpdb;$prefix=$wpdb->prefix;
$tableName=$prefix.'posts';
$column_name='post_title';
echo $sql="SELECT data_type FROM information_schema.columns WHERE table_name = '$tableName' AND column_name = '$column_name' ";
  $dataType = $wpdb->get_var($sql);        
echo $dataType;?>