1¡¢MySQLÈ¡µÃµ±Ç°Ê±¼äµÄº¯ÊýÊÇ £¬¸ñʽ»¯ÈÕÆڵĺ¯ÊýÊÇ
2¡¢Ð´³ö SQLÓï¾äµÄ¸ñʽ : ²åÈë £¬¸üР£¬É¾³ý
±íÃûUser
Name Tel Content Date
ÕÅÈý 13333663366 ´óר±ÏÒµ 2006-10-11
ÕÅÈý 13612312331 ±¾¿Æ±ÏÒµ 2006-10-15
ÕÅËÄ 021-55665566 ÖÐר±ÏÒµ 2006-10-15
(a) ÓÐһмǼ(СÍõ 13254748547 ¸ßÖбÏÒµ 2007-05-06)ÇëÓÃSQLÓï¾äÐÂÔöÖÁ±íÖÐ
(b) ÇëÓÃsqlÓï¾ä°ÑÕÅÈýµÄʱ¼ä¸üгÉΪµ±Ç°ÏµÍ³Ê±¼ä
(c) Çëд³öɾ³ýÃûΪÕÅËĵÄÈ«²¿¼Ç¼
3¡¢Çëд³öÊý¾ÝÀàÐÍ(int char varchar datetime text)µÄÒâ˼; ÇëÎÊvarcharºÍcharÓÐʲôÇø±ð
4¡¢MySQL×ÔÔöÀàÐÍ(ͨ³£Îª±íID×Ö¶Î)±ØÐ轫ÆäÉèΪ( )×Ö¶Î
5¡¢ÒÔÏÂÇëÓÃPHPMYADMINÍê³É
(Ò»)´´½¨ÐÂÎÅ·¢²¼ÏµÍ³£¬±íÃûΪmessageÓÐÈçÏÂ×Ö¶Î
id ÎÄÕÂid
title ÎÄÕ±êÌâ
content ÎÄÕÂÄÚÈÝ
category_id ÎÄÕ·ÖÀàid
hits µã»÷Á¿
(¶þ)ͬÑùÉÏÊöÐÂÎÅ·¢²¼ÏµÍ³£º±ícomment¼Ç¼Óû§»Ø¸´ÄÚÈÝ£¬×Ö¶ÎÈçÏÂ
comment_id »Ø¸´id
id ÎÄÕÂid£¬¹ØÁªmessage±íÖеÄid
comment_content »Ø¸´ÄÚÈÝ
ÏÖͨ¹ý²éѯÊý¾Ý¿âÐèÒªµÃµ½ÒÔϸñʽµÄÎÄÕ±êÌâÁбí,²¢°´Õջظ´ÊýÁ¿ÅÅÐò£¬»Ø¸´×î¸ßµÄÅÅÔÚ×îÇ°Ãæ
ÎÄÕÂid ÎÄÕ±êÌâ µã»÷Á¿ »Ø¸´ÊýÁ¿
ÓÃÒ»¸öSQLÓï¾äÍê³ÉÉÏÊö²éѯ£¬Èç¹ûÎÄÕÂûÓлظ´Ôò»Ø¸´ÊýÁ¿ÏÔʾΪ0
(Èý)ÉÏÊöÄÚÈݹÜÀíϵͳ£¬±ícategory±£´æ·ÖÀàÐÅÏ¢£¬×Ö¶ÎÈçÏÂ
category_id int(4) not null auto_increment;
categroy_name varchar(40) not null;
Óû§ÊäÈëÎÄÕÂʱ£¬Í¨¹ýÑ¡ÔñÏÂÀ²Ëµ¥Ñ¡¶¨ÎÄÕ·ÖÀà
д³öÈçºÎʵÏÖÕâ¸öÏÂÀ²Ëµ¥