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

Mysql ³£ÓÃÊýÖµÀàÐÍÕûÀí

Ò»¡¢ÊýÖµ(number)
Ãû³Æ
ÃèÊö
·¶Î§(´ø·ûºÅ)
·¶Î§(²»´ø·ûºÅ)
¿Õ¼äÐèÇó(×Ö½Ú)
TINYINT
ºÜСµÄÕûÊý
-128µ½127
0µ½255
 1
SMALLINT
СµÄÕûÊý
-32768µ½32767
0µ½65535
 2
MEDIUMINT
ÖеȴóСµÄÕûÊý
-8388608µ½8388607
0µ½16777215
 3
INT,INTEGER
ÆÕͨ´óСµÄÕûÊý
-2147483648µ½2147483647
0µ½4294967295
 4
BIGINT
´óÕûÊý
-9223372036854775808µ½9223372036854775807
0µ½18446744073709551615
 8
DOUBLE
ÆÕͨ´óС(Ë«¾«¶È)¸¡µãÊý
-1.7976931348623157E+308µ½-2.2250738585072014E-308
0ºÍ2.2250738585072014E-308µ½ 1.7976931348623157E+308
ͬ×ó
 8
DECIMAL
ѹËõµÄ“Ñϸñ”¶¨µãÊý(Ò²ÊÇ´øÐ¡ÊýµÄÊý×Ö)
×ÜλÊý×î´óΪ65(°üÀ¨Ð¡Êý²¿·Ö)£¬Ð¡Êý²¿·Ö×î´óλÊýΪ30
ͬ×ó
 ±ä³¤


Ïà¹ØÎĵµ£º

Mysql ѧϰ ³£ÓÃÃüÁî


1Â¥



Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £­pÓû§ÃÜÂë
1¡¢Á¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -u root -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂë.×¢ÒâÓû§Ãûǰ¿ÉÒÔÓпոñÒ²¿ÉÒÔûÓпոñ£¬µ«ÊÇÃÜÂëǰ±ØÐëÃ»Ó ......

VCÓÃMYSQLÌṩµÄLIB²éѯÊý¾Ý¿â

#include "winsock.h"
#include "mysql.h"
void query_example(void)
{
MYSQL *pDbCon = NULL;
char *pszHost = "localhost";
char *pszUser = "guest";
char *pszPsw = "";
char *pszDbName = "mysql_db_name";
int iPort = 3306;
pDbCon = mysql_init((MYSQL*) 0);
if (NULL != pDbCon)
{ ......

.NETÁ¬½ÓMySqlÊý¾Ý¿âµÄ·½·¨¼°Ê¾Àý

·½·¨Ò»£º
ʹÓÃMySQLÍÆ³öµÄMySQL Connector/Net×é¼þ£¬ ¸Ã×é¼þÊÇMySQLΪADO.NET·ÃÎÊMySQLÊý¾Ý¿âÉè¼ÆµÄ.NETרÓ÷ÃÎÊ×é¼þ¡£Íê³É¸Ã×é¼þºó£¬ÐèÒªÔÚÏîÄ¿ÖÐÒýÓÃÕâ¸ö×é¼þ£¬Ò²¿ÉÒÔÖ±½ÓÔÚÅäÖÃÎļþµÄ<assemblies>½ÚµãÄÚÌí¼ÓÏÂÃæµÄ½Úµã£º
<add assembly="MySql.Data, Version=5.1.5.0, Culture=neutral, PublicKeyToken=C5687 ......

Mysql_ÃüÁî¹éÀà 91KGE

.Á¬½Ómysql    mysql -uroot -padmin -hlocalhost
.Á¬½ÓmysqladminÃüÁîÐпͻ§¶Ë³ÌÐò mysqladmin -uroot -padmin -hlocalhost
.Æô¶¯mysql   mysqld
.¹Ø±Õ  mysqladmin -uroot -padmin -hlocalhost shutdown
.ÐÞ¸ÄÃÜÂë
set password for 'root'@'localhost' = password('admin')
update ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ