Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚmysqlÖеÄint£¨m£©


<!--
/* Font Definitions */
@font-face
{font-family:ËÎÌå;
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-alt:SimSun;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
@font-face
{font-family:"\@ËÎÌå";
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
text-align:justify;
text-justify:inter-ideograph;
mso-pagination:none;
font-size:10.5pt;
mso-bidi-font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:ËÎÌå;
mso-font-kerning:1.0pt;}
/* Page Definitions */
@page
{mso-page-border-surround-header:no;
mso-page-border-surround-footer:no;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;
mso-header-margin:42.55pt;
mso-footer-margin:49.6pt;
mso-paper-source:0;
layout-grid:15.6pt;}
div.Section1
{page:Section1;}
-->
¹ØÓÚ
mysql
ÖеÄ
int
£¨
m
£©£º
mysql
¡¡Êý×ÖÀàÐ͵ġ¡
int(3)
»ò
int(1)
ÆäÖÐÀ¨ºÅÊý×Ö±íʾʲô
.
¹Ù·½ÓÐÒ»¶Î»°£º
 
Another
extension is supported by MySQL for optionally specifying the display width of
integer data types in parentheses following the base keyword for the type (for
example, INT(4)). This optional display width is used to display integer values
having a width less than the width specified for the column by left-padding
them with spaces.
ËùÒÔ˵
m
¿É²»ÊDZíʾ´æÖü´óСµÄ£¬Ëû±íʾµÄµ±Êý¾ÝµÄ¿í¶È£¬ÒªÊÇÊý¾ÝµÄ¿í¶ÈСÓÚ
m
£¬¾ÍÓÿոñ×󲹳䡣
mysql
µÄ
int
ÐÍÊdz¤ÕûÐΣ¬Ò²¾ÍÊÇ
0~232
£¬Ò²¾ÍÊÇ
4
¸ö×Ö½ÚÀ²¡£


Ïà¹ØÎĵµ£º

MYSQL »ù±¾ÃüÁî

½øÈëMySQL:mysql -u root -p password;
Í˳öMySQL:quit/exit;
´´½¨Êý¾Ý¿â£ºcreate database database-name;
ÏÔʾËùÓеÄÊý¾Ý¿â: show databases; ×¢ÒâÓиös;
ɾ³ýÊý¾Ý¿â£ºdrop database databasename;
lÁ¬½ÓÊý¾Ý¿â£ºuse databasename;Ìáʾ£ºdatabase changed;
Ñ¡Ôñµ±Ç°Êý¾Ý¿â£ºselect database();
µ±Ç°Êý¾Ý¿âËù°üº¬µÄ ......

solaris10ÏÂmysql°²×°ÓÚÅäÖà תÔØ


Ç°´ÎдÁ˸ö³ÌÐòÅÜÔÚsolaris10ÉÏ£¬ÒªÓõ½mysqlÊý¾Ý¿â£¬È¥sunÍøÕ¾ÉÏÏÂÒ»¸ö¹ýÀ´£¬
È»ºópkgadd mysql5.* ʲôÌáʾ¶¼Ã»£¬¾Í°²×°Íê³ÉÁË£¬ÓôÃƵÄÊÂÇé¾ÍÕâÑù·¢ÉúÁË©¤©¤
ÎÒ²»ÖªµÀMYSQLµÄĬÈÏÓû§ÃûÃÜÂëÊÇʲô£¬°´ÕÕWINDOWSÖÐʹÓõľ­ÑéÊÔÁËN±é£¬
²»ÐУ¡Ö»ºÃGOOGLEÁË£¬ºÃ²»ÈÝÒ׸㶨¡£Ò»ÏÂΪGOOGLEÖ®ÄÚÈÝ£¬·ÇÔ­´´
Unix&Linux ......

¹ØÓÚMySQLÊý¾Ý¿âµÄ´æ´¢ÒýÇæ

MySQLÖеÄÊý¾ÝÓø÷ÖÖ²»Í¬µÄ¼¼Êõ´æ´¢ÔÚÎļþ(»òÕßÄÚ´æ)ÖС£ÕâЩ¼¼ÊõÖеÄÿһÖÖ¼¼Êõ¶¼Ê¹Óò»Í¬µÄ´æ´¢»úÖÆ¡¢Ë÷Òý¼¼ÇÉ¡¢Ëø¶¨Ë®Æ½²¢ÇÒ×îÖÕÌṩ¹ã·ºµÄ²»Í¬µÄ¹¦ÄܺÍÄÜÁ¦¡£Í¨¹ýÑ¡Ôñ²»Í¬µÄ¼¼Êõ£¬ÄãÄܹ»»ñµÃ¶îÍâµÄËٶȻòÕß¹¦ÄÜ£¬´Ó¶ø¸ÄÉÆÄãµÄÓ¦ÓõÄÕûÌ幦ÄÜ¡£
ÀýÈ磬Èç¹ûÄãÔÚÑо¿´óÁ¿µÄÁÙʱÊý¾Ý£¬ÄãÒ²ÐíÐèҪʹÓÃÄÚ´æ´æ´¢ÒýÇæ¡£ÄÚ´æ´æ´ ......

Solaris10ÏÂmysqlµÄ±àÂëÎÊÌâ

°²×°ºó
/etc/init.d/mysql start (stop) ΪÆô¶¯ºÍÍ£Ö¹·þÎñÆ÷
/etc/mysql/ Ö÷ÒªÅäÖÃÎļþËùÔÚλÖà my.cnf
/var/lib/mysql/ ·ÅÖõÄÊÇÊý¾Ý¿â±íÎļþ¼Ð£¬ÕâÀïµÄmysqlÏ൱ÓÚwindowsÏÂmysqlµÄdateÎļþ¼Ð
Æô¶¯mysqlºó£¬ÒÔrootµÇ¼mysql
isher@isher-ubuntu:~$ mysql -u root
>show variables like 'character%'; #Ö´ÐбàÂëÏ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ