mysqlÓï¾äÖ´ÐÐʱ¼äµÄ»ñÈ¡
ÎÒÓõÄNavicat´øµÄcosoleÖ´ÐÐsqlÓï¾ä£¬Ã»ÓÐÓï¾äÖ´ÐÐʱ¼ä£¬µ«ÎÒ¿´µ½ACMAIN_CHMµÄ»ØÌû¶¼´øÓÐÖ´ÐÐʱ¼ä£¬ÈçϵÄ0.00 sec.
ÇëÎÊÊÇʹÓõŤ¾ß²»Ò»Ñù£¬»¹ÊÇÓиöÅäÖÃû¿ª£¬»òÕßÊǰ汾µÄÎÊÌ⣿
mysql> select * from t_advancejar;
+------+------+----------+
| name | num | order_id |
+------+------+----------+
| ÕÅÈý | 10 | 0 |
| ÕÅÈý | 10 | 1 |
| ÕÅÈý | 11 | 0 |
| ÕÅÈý | 11 | 1 |
| ÕÅÈý | 12 | 0 |
| ÕÅÈý | 13 | 1 |
| ÀîËÄ | 12 | 1 |
+------+------+----------+
7 rows in set (0.00 sec)
ÊÇÔÚMYSQLÃüÁîÐÐÏÂÏÔʾ³öÀ´µÄʱ¼ä
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
ÎÒ¿ª·¢ASP.netʱ
²åÈëÍâÎÄÂÒÂë
SHOW VARIABLES LIKE 'character%';
Õâ¸öʱºò
character_set_client utf8
character_set_connection utf8
character_set_database utf8
ch ......