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
ͬ×ó
±ä³¤
Ïà¹ØÎĵµ£º
1Â¥
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Á¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -u root -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂë.×¢ÒâÓû§Ãûǰ¿ÉÒÔÓпոñÒ²¿ÉÒÔûÓпոñ£¬µ«ÊÇÃÜÂëǰ±ØÐëÃ»Ó ......
#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)
{
......
·½·¨Ò»£º
ʹÓÃMySQLÍÆ³öµÄMySQL Connector/Net×é¼þ£¬ ¸Ã×é¼þÊÇMySQLΪADO.NET·ÃÎÊMySQLÊý¾Ý¿âÉè¼ÆµÄ.NETרÓ÷ÃÎÊ×é¼þ¡£Íê³É¸Ã×é¼þºó£¬ÐèÒªÔÚÏîÄ¿ÖÐÒýÓÃÕâ¸ö×é¼þ£¬Ò²¿ÉÒÔÖ±½ÓÔÚÅäÖÃÎļþµÄ<assemblies>½ÚµãÄÚÌí¼ÓÏÂÃæµÄ½Úµã£º
<add assembly="MySql.Data, Version=5.1.5.0, Culture=neutral, PublicKeyToken=C5687 ......
.Á¬½Ó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 ......