xampp Óë mysql - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
ÎÒÊDzËÄñ£¬ÎÊÎʸ÷λ¸ßÊÖ¡£
ÎÒµÄmysql rootÃÜÂëÊÇ root
×Ô´Ó°²×°ÁËxamppÖ®ºó£¬Ö±½ÓÔËÐÐMySQL Command Line Client ÊäÈëroot¾Í²»ÄܽøÈëmysql£¬¶ø¿ªÆôxamppÖ®ºó¾Í¿ÉÒÔ¡£²¢ÇҹرÕÁËxamppÖ®ºóÒ²¿ÉÒÔ½øÈëmysqlÁË¡£
Ò²¾ÍÊÇ˵£¬Ã¿´Î¿ª»úÎÒÔÚÔËÐÐmysql֮ǰ±ØÐëÏÈÔËÐÐÒ»´Îxampp¡£ÕâÊÇʲôµÀÀíÄØ£¿
ÄãµÄmysqlÓ¦¸ÃÊÇÓÉxamppÁ¬´øÆô¶¯µÄ.
¿ÉÄÜÊÇ£¬µ«ÊÇÎÒµÄmysql°²×°ÔÚxampp֮ǰ¡£
ÄÇôxampp¸Ä±äÁËmysqlµÄÉèÖá£Æñ²»ÊÇmysql¾Í²»°²È«¡£ÈκÎÈ˶¼¿ÉÒÔͨ¹ý°²×°xampp½øÈëÊý¾Ý¿â¡£
ÕâÑù×Ó£¿ÄÇ¿ÉÄÜÊÇxampp¸Ä¶¯ÁËmysqlµÄÆô¶¯²ÎÊý¡£
Äã´Ó·þÎñÁбíÀï¿´¿´mysql·þÎñµÄÆô¶¯²ÎÊý¡£¿´Ëü¶ÔÓ¦µÄÊÇÄĸöÅäÖÃÎļþ£¿
ÁíÍ⣬ÄãÍêÈ«¿ÉÒÔÊÖ¶¯Æô¶¯mysqlµÄ¡£Ö»ÒªÖªµÀmysqlµÄÅäÖÃÎļþµÄλÖ㨲»ÒªÅª´íÁË)
¶÷£¬Ð»Ð»¡£
{{
Ïà¹ØÎÊ´ð£º
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿
ÒýÓÃ
ÇëÎÊ
......
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿
2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......
ÎÒÓõÄÊÇmysql6.0Ϊʲôһ´´½¨Á½¸ö±íÕâ¼äÓÃÍâ¼üÀ´Á¬½Óʱ¾Í˵´´½¨²»ÁË£ºcan"nt create table ...
ÄãµÄÓï¾äÊÇʲô£¿ÄãµÄ±íÊÇʲô´æ´¢ÒýÇæ£¿ Èç¹ûÊÇmyisam Ôò²»Ö§³ÖÍâ¼ü£¬ÄãÐèÒª°Ñ±í¸ÄΪinndb
貼³öSQL ......
ÎÒÒѾ°²×°mysqlÁË£¬ÉèÖõĿª»ú²»Æô¶¯£¬µ«ÔÚÎҵĵçÄÔ'->'¹ÜÀí'->'·þÎñºÍÓ¦ÓóÌÐò'->·þÎñÖÐÕÒ²»µ½mysql£¬ÕâÑù¾Íû·¨Æô¶¯ÁË£¬ÎÒÏëѯÎÊÒ»ÏÂÕâµ½µ×ÊÇÔõô»ØÊ£¬ÏÈллÁË
ÓÐºÃ¶àµØ·½ÄØ
×¢²á±í
Æô¶¯Îļþ¼ÐµÈ
......
id name datetime
1 a 2010-05-13 10:15:00
2 b 2010-05-14 09:10:00
3 d 2010-05-14 10:10:00
ÈçºÎ½«¾àÀëĿǰ×î½üµÄÄǸö¼Ç¼µÄname ¸üÐÂΪ¡°x¡±ÄØ
лл¿© °¡ ºÇºÇ
update table_n ......