ÓÃsqlÓï¾äдѡ¿Îϵͳ
ѧÉú 20000¸ö ÓðټÒÐÕËæ»ú×é³É
¿Î³Ì 30ÃÅ
ÀÏʦ 50¸ö
ʲôÒâ˼£¿
ÖØ¸´Á˰ɣ¿
Ôõôд???
²»ºÃÒâ˼···ÕâÊǹØÏµÍ¼··
¿´²»µ½ÄãµÄͼ¡£Ïë°ì·¨ÓÃÎÄ×Ö˵Ã÷°É¡£
gotlove (gotlove)
'½ØÖÁ2010-04-11 16:07:28 Óû§½áÌûÂÊ0.00%
µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
²»ÖªµÀ°¡···ÎÒ¸Õ½áÌùÁ˰¡£¡£¡£¡Ôõô½áÌùÂÊ»¹ÊǰٷÖÖ®ÁãÄØ£¿ÎÒ×òÌìÉêÇë×¢²áµÄ··ÄѵÀÊÇÎÒ»ý·Ö²»¹»Âð£¿
30ÃſγÌÓÉ50¸öÀÏʦ½Ì£¬2Íò¸öѧÉúÑ¡ÀÏʦ£¬ÓÐÖØ¸´¿Î³Ì£¬µ«ÊÇÓɲ»Í¬ÀÏʦ½Ì£¬µ±ÀÏʦËù´øµÄ¿ÎѧÉúÂúÔ±ºó£¬Ê£ÓàµÄѧÉúËæ»ú·ÖÅä
[ÀÏʦ]-[¿Î³Ì]:µÄ¹ØÏµ£¿
[ѧÉú]-[¿Î³Ì]:µÄ¹ØÏµ£¿
°¦·
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±í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 ......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......