mysqlº¯ÊýÄÜ·ñʵÏÖÕâÑùµÄ¹¦ÄÜ£¿
ÕâÊÇcÓïÑÔÏÂʵÏÖµÄÒ»¸ö×Ö·û´®µÄ¹þÏ£º¯Êý£¬Àï±ßÓõ½ÁËλÔËË㣬
ÏÖÔÚÏ£Íû°ÑÕâ¶Î´úÂëÒÆÖ²³ÉÒ»¸ömysqlµÄº¯Êý£¬ÈçºÎʵÏÖ£¿
C/C++ code:
static unsigned long
hash_string (const void *key)
{
const char *p = (const char *)key;
unsigned int h = *p;
if (h)
for (p += 1; *p != '\0'; p++)
h = (h << 5) - h + *p;
return h;
}
MySQLÖÐÓ¦¸Ã¿ÉÒÔʵÏÖ¡£¼òµ¥ÃèÊöÒ»ÏÂÄãµÄËã·¨¹¦ÄÜ
MySQLÖÐÖ§³ÖλÔËË㣬ºÍ < <
ÓÃmysqlµÄudf×Ô¶¨Ò庯Êý°É
Õâ¸ö²»Ì«Çå³þ£¬Ñ§Ï°
ºÃµÄ°ßÖñ£º
º¯ÊýµÄ²ÎÊýÊÇÒ»¸ö×Ö·û´®£¬Èç:str="acmain",
Ê×ÏÈÉ趨һ¸öÎÞ·ûºÅÕûÐ͵Ļù×¼Êýh,
hµÄ³õʼֵÊÇ'a'µÄasciiÖµ£¬¼´97.
´ËºóµÄÑ»·¾ùÊÇ »ù×¼Êý×óÒÆ5λºó¼õÈ¥»ù×¼Êý±¾Éí£¬½Ó×ÅÔÙ¼ÓÉϵ±Ç°×Ö·ûµÄasciiÖµ¡£
Èç´Ë¿´À´£¬µÚÒ»´ÎÑ»·¹ý³ÌÔòΪ£º
(97 < <5)-97+99,µÃµ½3106£¬ÆäÖÐ99Ϊ'c'µÄasciiÖµ£»
µÚ¶þ´ÎÔòΪ£º
(3106 < <5)-3106+109,µÃµ½96395£¬109Ϊ'm'µÄasciiÖµ£»
ÒÀ´ÎÀàÍÆ£¬Ö±µ½×Ö·û´®½áÊø£¡
ºÃ£¬ÎÒ²é²éÏà¹Ø×ÊÁÏ£¡
SQL code
Code highlighting produced by Ac
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......