Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysql ×ÔÔöÁеĴ´½¨

1.½¨±íʱ¾Í´´½¨×ÔÔöÁУº
create table test
(
 id int auto_increment primary key,
 name varchar(20) not null,
 password varchar(20) not null
);
insert into test values(null,'aa','aa');
insert into test values(null,'bb','bb');
×¢Ò⣺
      ²åÈëÓï¾äʱ£¬×ÔÔöÁеÄֵΪNULL¡£
2¡¢´´½¨±í¸ñºóÌí¼Ó£º alter table table1 add id int auto_increment primary key ×ÔÔö×ֶΣ¬Ò»¶¨ÒªÉèÖÃΪprimary key.


Ïà¹ØÎĵµ£º

windows2003+iis6+php+mysql ·þÎñÆ÷ÅäÖÃ

ÔÚÍøÉÏ¿´ÁËºÜ¶à¹ØÓÚwindows2003+iis6+php+mysql ·þÎñÆ÷ÅäÖõÄÎÄÕ£¬´óÌåÉ϶¼ÊÇ»¥Ïà³­Ï®£¬²»¹ýһЩ¹«¹²µÄÐÅÏ¢»¹ÊǺÜÕýÈ·µÄ£¬µ«ÊÇÕë¶ÔÒ»Ð©ÌØ±ðµÄ»úÆ÷»òÕßÒòΪ¸öÈ˲»Í¬µÄÅäÖÃ×ܲ»Äܰ´ÕÕÎÄÕµÄÄÚÈݲÙ×÷³É¹¦£¬ÏÂÃæËµÒ»ÖÖ½ÏΪ¼òµ¥µÄ²Ù×÷·½·¨£¬²½ÖèÈçÏ£º
1.iis°²×°£¨ÂÔ£©
2.ÏÂÔØAppServ²¢°²×°
3.ÔÚc:\½¨php5Îļþ¼Ð£¬È»ºóÔÙphp5 ......

mysql+phpÎÞ·¨Á¬½Ósql£¨Òѽâ¾ö£©

¸ãÁ˺ܾᣡ£ÖÕÓÚ·¢ÏÖÔ­À´ÊÇȨÏÞÎÊÌâ¡£¡£
2ÐÐÃüÁî¸ã¶¨
grant all privileges on rogue.* to admin@localhost identified by 'admin' with grant option
grant all privileges on rogue.* to admin@'%' identified by 'admin' with grant option
¾­µäÁË¡£¡£¡£
ħÁ¦Ë½·þÍøÒ³¶Ë¸ã¶¨¿©~~ ......

Ôõô°Ñpowerdesignerµ¼³öµÄsqlÓÃPHPµ¼ÈëMysQLÊý¾Ý¿â

ÎÒÃÇÖªµÀÓÃpowerdesignerµ¼³öµÄsqlÎļþºó׺Ϊ'.sql'£»ÓÃphpmyadminºÜÈÝÒ×µ¼ÈëMysQLÊý¾Ý¿â£¬µ«ÊÇÓÃPHPÔõôµ¼ÈëÊý¾Ý¿âÄØ?
ÎÒÓÃpowerdesignerÉè¼ÆÒ»¸öÊý¾Ý¿âºóµ¼³ösqlÎļþ£¨Ò»¸öͶƱϵͳ£©Îª'vote.sql'£»
ÎļþÄÚÈÝΪ£¨Ò»Ð©sqlÓï¾äºÍ×¢ÊÍ£©£º
        
/*======================= ......

UbuntuÏÂÅäÖÃLAMP£¨Linux+Apache+Mysql+PHP)»·¾³

ÖÕÓڷżÙÁË£¬ÕýÏëÔÚÕâ¸ö¼ÙÆÚÀïѧѧPHP£¬ÓÉÓÚ×Ô¼ºÓõÄÊÇ×ÀÃæ°æµÄUbuntu8.04,ÓÚÊǾÍÏë¼ÜÉèÒ»¸öLAMP»·¾³À´Ñ§PHP£¬Ò²³Ã´Ë»ú»áѧһÏÂPHP·þÎñÆ÷µÄ¼ÜÉè¡£
Ò»¡¢°²×°Ubuntu8.04
ËäȻ˵ÊÇÅäÖÃLAMP»·¾³£¬µ«ÔÚÎÄÕÂÀï²¢²»»á½²ÊöÈçºÎ°²×°Ubuntu8.04,ÒòΪ¹ØÓÚÈçºÎUbuntu8.04ÔÚÍøÉÏÒѾ­ÓкܶàµÄ½Ì³ÌÁË£¬¾ÍËãÊÇÓ²Å̰²×°Ò²ÊÇÒ»¼þºÜ¼òµ¥µÄÊÂÁ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ