用DLL包while((field = mysql_fetch_field(m_Result))) //获取该表字段名称保存在CStrligList中
{
str = field->name; //能获取字段名称
str1 = field->type; //获取的字段类型是乱码?????
}5.5.21 已经不支持mysql_field_type()获取字段函数了。。如何获取mysql 字段类型?
{
str = field->name; //能获取字段名称
str1 = field->type; //获取的字段类型是乱码?????
}5.5.21 已经不支持mysql_field_type()获取字段函数了。。如何获取mysql 字段类型?
解决方案 »
- Mysql大数据库查询问题
- java连接MySQL问题
- GROUP BY的一个问题
- MYSQL 设计数据库的时候,需要注意的事项及原则 有哪些
- mysql同步问题
- 如何计算和限制一个表中某些记录的占用数据库空间
- ERROR 1044: Access denied for user: ''@'localhost' to database 'testdb'
- navicat连得上,程序连接报错10061
- 使用三和一(php+apache+mysql)配置老出问题?
- 在线急求MYsql中sum函数的问题
- Mysql默认编码是latin1,插入中文乱码
- 如何查询某字段包含某内容mysql 有类似数组包含的东西吗
enum enum_field_types type The type of the field. The type value may be one of the MYSQL_TYPE_ symbols shown in the following table. Type Value Type Description
MYSQL_TYPE_TINY TINYINT field
MYSQL_TYPE_SHORT SMALLINT field
MYSQL_TYPE_LONG INTEGER field
MYSQL_TYPE_INT24 MEDIUMINT field
MYSQL_TYPE_LONGLONG BIGINT field
MYSQL_TYPE_DECIMAL DECIMAL or NUMERIC field
MYSQL_TYPE_NEWDECIMAL Precision math DECIMAL or NUMERIC
MYSQL_TYPE_FLOAT FLOAT field
MYSQL_TYPE_DOUBLE DOUBLE or REAL field
MYSQL_TYPE_BIT BIT field
MYSQL_TYPE_TIMESTAMP TIMESTAMP field
MYSQL_TYPE_DATE DATE field
MYSQL_TYPE_TIME TIME field
MYSQL_TYPE_DATETIME DATETIME field
MYSQL_TYPE_YEAR YEAR field
MYSQL_TYPE_STRING CHAR or BINARY field
MYSQL_TYPE_VAR_STRING VARCHAR or VARBINARY field
MYSQL_TYPE_BLOB BLOB or TEXT field (use max_length to determine the maximum length)
MYSQL_TYPE_SET SET field
MYSQL_TYPE_ENUM ENUM field
MYSQL_TYPE_GEOMETRY Spatial field
MYSQL_TYPE_NULL NULL-type field You can use the IS_NUM() macro to test whether a field has a numeric type. Pass the type value to IS_NUM() and it evaluates to TRUE if the field is numeric: if (IS_NUM(field->type))
printf("Field is numeric\n");
$quy1 = mysql_query($sql1);
while($val1 = mysql_fetch_array($quy1))
{
$type = $val1[type];
}
2)show full columns from (table_name) 比较方便快捷,
3)SELECT * FROM `information_schema`.`COLUMNS` where `TABLE_NAME`='db_account' and `TABLE_SCHEMA`='bus' 更方便,因为已经将Varch(13) 分成 varchar 13两个字段,信息更多更细