mysql Ƶ·±²åÈë»á²»»á±ÀÀ£
ºǫ́³ÌÐòÐèҪÿ¸ôÒ»Ã뽫´óÔ¼200¸öÓû§µÄÁ÷Á¿²åÈëÊý¾Ý¿â£¬²ÉÓÃwhileÑ»·¡£ÕâÑù»á²»»áµ¼ÖÂÊý¾Ý¿âµ±µô¡£³ÌÐò²âÊÔ¹ý³ÌÖлá³öÏÖ³ÌÐò¿¨ËÀ£¬³õ²½ÅжÏÔÒòΪƵ·±²åÈëÊý¾Ý¿âµ¼Ö£¬µ«»¹²»È·¶¨¡£
mysql²»»á±ÀÀ££¬Ö»ÊÇÏìÓ¦¿ÉÄÜÓеãÂý¡£
max_connections ²ÎÊýΪ100.
Ó¦¸Ã²»»áµ¼ÖÂMYSQL±ÀÀ££¬²»¹ýµ¹ÊÇÓпÉÄÜÓÐЩÓû§Á¬²»ÉÏÀ´¡£
»áµ¼ÖÂMYSQL±ÀÀ£
²»»áµ¼ÖÂMYSQL±ÀÀ££¬ÉÏÃæÐ´´íÁË£¡
¡°MySQL±ÀÀ£¡±Ó¦¸ÃÊDz»»á£¬µ«Èç¹û´¦ÀíËÙ¶ÈÂýµÄ»°£¬ÈÎÎñÔ½»ýÀÛÔ½¶à£¬¾ÍÓÀÎÞÄþÈÕÁË£¬×îÖÕ¿ÉÄÜ»áÊÇÓ¦Óö˱ÀÀ£¡£
ÕâÔõô¿ÉÄܻᵼÖÂMySQL±ÀÀ£ÄØ£¬ÕâÑù¾Í±ÀÀ£ÁË£¬ÄǰïÑо¿´óʦ£¬»¹»ìʲô°¡¡£Ö»ÊÇÁ¬½ÓÏìÓ¦¿ÉÄÜÓеãÂý¡£
ѧϰ¡£¡£¡£
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒ¿ª·¢ASP.netʱ
²åÈëÍâÎÄÂÒÂë
SHOW VARIABLES LIKE 'character%';
Õâ¸öʱºò
character_set_client utf8
character_set_connection utf8
character_set_database utf8
ch ......
echo %~dp0
CD %~dp0
mysqld.exe --defaults-file=..\my.ini --console
pause
´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£
ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£
echo %~dp0
ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû
CD %~dp0
......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
1.ÒÔϵͳ¹ ......