blocks|key|777043|text|您可以从information_schema数据库中获得以下内容：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|777044|select+data_type+
from+information_schema.columns+
where+table_schema+=+'myschema'
and+table_name+=+'mytable'+
and+column_name+=+'mycol'|code-block|syntax|javascript|777045|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can get this from the information_schema database:

<pre><code>select data_type 
from information_schema.columns 
where table_schema = 'myschema'
and table_name = 'mytable' 
and column_name = 'mycol'
</code></pre>

blocks|key|777068|text|您可以使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|777069|SHOW+FIELDS
FROM+tableName+where+Field+='nameOfField'|code-block|syntax|javascript|777070|这将以以下格式返回结果|777071|Field+++Type++++Null++++Key+++++Default+++++Extra+|777072|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

You can use 

<pre><code>SHOW FIELDS
FROM tableName where Field ='nameOfField'
</code></pre>

This will return you result in format of

<pre><code>Field Type Null Key Default Extra 
</code></pre>

blocks|key|777141|text|我知道我来派对有点晚了。您可能希望使用COLUMN_TYPE而不是DATA_TYPE。它提供了有关类型的更多信息(如精度)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|777142|SELECT+COLUMN_TYPE
FROM+information_schema.COLUMNS
WHERE+TABLE_NAME+=+'parts'
AND+COLUMN_NAME+=+'price'|code-block|syntax|javascript|777143|...yields...|777144|decimal(11,2)|777145|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I know I'm a little late to the party. You may want to use COLUMN_TYPE rather than DATA_TYPE. It gives more info (such as precision) about the type.

<pre><code>SELECT COLUMN_TYPE
FROM information_schema.COLUMNS
WHERE TABLE_NAME = 'parts'
AND COLUMN_NAME = 'price'
</code></pre>

...yields...

<pre><code>decimal(11,2)
</code></pre>

blocks|key|777214|text|以下语法也适用，使用describe在tableName后输入columnName：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|777215|describe+tbleName+columnName;|code-block|syntax|javascript|777216|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

The following syntax also works, using describe, enter the columnName after the tableName:

<pre><code>describe tbleName columnName;
</code></pre>

blocks|key|777232|text|ResultSet+rs+=+Sstatement.executeQuery("SELECT+*+FROM+Table+Name");

ResultSetMetaData+rsMetaData+=+rs.getMetaData();

int+numberOfColumns+=+rsMetaData.getColumnCount();
System.out.println("resultSet+MetaData+column+Count="+%2B+numberOfColumns);

for+(int+i+=+1;+i+<=+numberOfColumns;+i%2B%2B)+{
+System.out.println("column+number+"+%2B+i);

++System.out.println(rsMetaData.getColumnTypeName(i));
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|777233|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>ResultSet rs = Sstatement.executeQuery("SELECT * FROM Table Name");

ResultSetMetaData rsMetaData = rs.getMetaData();

int numberOfColumns = rsMetaData.getColumnCount();
System.out.println("resultSet MetaData column Count=" + numberOfColumns);

for (int i = 1; i &lt;= numberOfColumns; i++) {
 System.out.println("column number " + i);

 System.out.println(rsMetaData.getColumnTypeName(i));
}
</code></pre>

Simple question: How can I return the field type of a MySQL table. I know about <code>describe</code> or <code>show column</code> but I just want to return that single parameter. e.g.:

<pre><code>SELECT fieldtype(mycol) FROM mytable
# should return INT or integer for example
</code></pre>

How to return field type from MySQL query?

数据库

MySQL

简单的问题:如何返回MySQL表的字段类型。我知道describe或show column，但我只想返回那个参数。例如：SELECT fieldtype(mycol) FROM mytable# should return INT or integer for example

问如何从MySQL查询返回字段类型？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何从MySQL查询返回字段类型？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何从MySQL查询返回字段类型？
EN