📄 mysql-实用技巧-30.htm
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#000000" text="#FFFFFF">
<DIV class=Section1 style="LAYOUT-GRID: 15.6pt none">
<TABLE width="100%" border=1 cellPadding=0 >
<TBODY>
<TR style="mso-yfti-irow: 0">
<TD> <P><font color="#FFFFFF"><SPAN
style="COLOR: whtle FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-bidi-font-weight: bold">类型值
</font></P></TD>
<TD> <P><font color="#FFFFFF"><SPAN
style="COLOR: whtle FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-bidi-font-weight: bold">类型含义</font></P></TD>
</TR>
<TR style="mso-yfti-irow: 1">
<TD> <P><font color="#FFFFFF">FIELD_TYPE_TINY </font></P></TD>
<TD> <P><font color="#FFFFFF">TINYINT字段</font></P></TD>
</TR>
<TR style="mso-yfti-irow: 2">
<TD> <P><font color="#FFFFFF">FIELD_TYPE_SHORT </font></P></TD>
<TD> <P><font color="#FFFFFF">SMALLINT字段</font></P></TD>
</TR>
<TR style="mso-yfti-irow: 3">
<TD> <P><font color="#FFFFFF">FIELD_TYPE_LONG </font></P></TD>
<TD> <P><font color="#FFFFFF">INTEGER字段</font></P></TD>
</TR>
<TR style="mso-yfti-irow: 4">
<TD> <P><font color="#FFFFFF">FIELD_TYPE_INT24 </font></P></TD>
<TD> <P><font color="#FFFFFF">MEDIUMINT字段</font></P></TD>
</TR>
<TR style="mso-yfti-irow: 5">
<TD> <P><font color="#FFFFFF">FIELD_TYPE_LONGLONG </font></P></TD>
<TD> <P><font color="#FFFFFF">BIGINT字段</font></P></TD>
</TR>
<TR style="mso-yfti-irow: 6">
<TD> <P><font color="#FFFFFF">FIELD_TYPE_DECIMAL </font></P></TD>
<TD> <P><font color="#FFFFFF">DECIMAL或NUMERIC字段</font></P></TD>
</TR>
<TR style="mso-yfti-irow: 7">
<TD> <P><font color="#FFFFFF">FIELD_TYPE_FLOAT </font></P></TD>
<TD> <P><font color="#FFFFFF">FLOAT字段</font></P></TD>
</TR>
<TR style="mso-yfti-irow: 8">
<TD> <P><font color="#FFFFFF">FIELD_TYPE_DOUBLE </font></P></TD>
<TD> <P><font color="#FFFFFF">DOUBLE或REAL字段</font></P></TD>
</TR>
<TR style="mso-yfti-irow: 9">
<TD> <P><font color="#FFFFFF">FIELD_TYPE_TIMESTAMP </font></P></TD>
<TD> <P><font color="#FFFFFF">TIMESTAMP字段</font></P></TD>
</TR>
<TR style="mso-yfti-irow: 10">
<TD> <P><font color="#FFFFFF">FIELD_TYPE_DATE </font></P></TD>
<TD> <P><font color="#FFFFFF">DATE字段</font></P></TD>
</TR>
<TR style="mso-yfti-irow: 11">
<TD> <P><font color="#FFFFFF">FIELD_TYPE_TIME </font></P></TD>
<TD> <P><font color="#FFFFFF">TIME字段</font></P></TD>
</TR>
<TR style="mso-yfti-irow: 12">
<TD> <P><font color="#FFFFFF">FIELD_TYPE_DATETIME </font></P></TD>
<TD> <P><font color="#FFFFFF">DATETIME字段</font></P></TD>
</TR>
<TR style="mso-yfti-irow: 13">
<TD> <P><font color="#FFFFFF">FIELD_TYPE_YEAR </font></P></TD>
<TD> <P><font color="#FFFFFF">YEAR字段</font></P></TD>
</TR>
<TR style="mso-yfti-irow: 14">
<TD> <P><font color="#FFFFFF">FIELD_TYPE_STRING </font></P></TD>
<TD> <P><font color="#FFFFFF">字符串(CHAR或VARCHAR)字段</font></P></TD>
</TR>
<TR style="mso-yfti-irow: 15">
<TD> <P><font color="#FFFFFF">FIELD_TYPE_BLOB </font></P></TD>
<TD> <P><font color="#FFFFFF">BLOB或TEXT字段(使用<SPAN
class=SpellE>max_length决定最大长度）</font></P></TD>
</TR>
<TR style="mso-yfti-irow: 16">
<TD> <P><font color="#FFFFFF">FIELD_TYPE_SET </font></P></TD>
<TD> <P><font color="#FFFFFF">SET字段</font></P></TD>
</TR>
<TR style="mso-yfti-irow: 17">
<TD> <P><font color="#FFFFFF">FIELD_TYPE_ENUM </font></P></TD>
<TD> <P><font color="#FFFFFF">ENUM字段</font></P></TD>
</TR>
<TR style="mso-yfti-irow: 18">
<TD> <P><font color="#FFFFFF">FIELD_TYPE_NULL </font></P></TD>
<TD> <P><font color="#FFFFFF">NULL- 类型字段</font></P></TD>
</TR>
<TR>
<TD> <P><font color="#FFFFFF">FIELD_TYPE_CHAR </font></P></TD>
<TD> <P><font color="#FFFFFF">不推荐；使用FIELD_TYPE_TINY代替</font></P></TD>
</TR>
</TBODY>
</TABLE>
IS_NUM()宏来测试字段是否有一种数字类型。将type值传给IS_NUM()并且如果字段是数字的，它将计算为TRUE：
<p></P>
<P> (IS_NUM(field->type))</P>
<P> printf("Field is numeric\n");</P>
<P> </P>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -