ÇóÒ»¸ösqlÓï¾äÔõôд
±í1£¬language
Id IsDefault Code IsUse
1 true cn true
2 false en true
3 false jp true
±í2£¬Catalog
Id CatalogName language CatalogGuid
1 Àà±ð1 cn 3A41058F
2 Àà±ð1 en 3A41058F
3 Àà±ð1 jp 3A41058F
4 Àà±ð2 cn 8A5C7D4B
5 Àà±ð2 en 8A5C7D4B
6 Àà±ð2 jp 8A5C7D4B
񡜪products
Id name language CatalogGuid
1 ²úÆ·1 cn 3A41058F
2 ²úÆ·1 en 3A41058F
3 ²úÆ·1 jp 3A41058F
4 ²úÆ·2 cn 3A41058F
5 ²úÆ
Ïà¹ØÎÊ´ð£º
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
ÄÄλÈÊÐÖÓй¦ÄÜÍêÕû¿ÉÓõÄSQLÏÂÔØµØÖ·ÄØ£¬ÎÒÓÐÒ»¸öµØÖ·£¬µ«Êǰ²×°ºó¹¦Äܲ»ÍêÕûÎÞ·¨Ê¹Óã¨Ã»ÓзþÎñÆ÷£©ÎÒÖªµÀµÄµØÖ·ÊÇ
http://down.xlylw.com/downlist/s_66_1.html
¿´À´£¬ÄãÖ»Äܵ½ÍøÉÏ×Ô¼ºËÑË÷ÁË!
×Ô¼º¶¯ÊÖ¾Í¿É ......