mysql²Ù×÷ Left join , Right Join, Inner Join
Ò».ÏÈ¿´Ò»Ð©×î¼òµ¥µÄÀý×Ó
Àý×Ó
Table A
aid adate
1 a1
2 a2
3 a3
TableB
bid bdate
1 b1
2 b2
4 b4
Á½¸ö±ía,bÏàÁ¬½Ó,Ҫȡ³öidÏàͬµÄ×Ö¶Î
select * from a inner join
b on a.aid = b.bidÕâÊǽöÈ¡³öÆ¥ÅäµÄÊý¾Ý.
´ËʱµÄÈ¡³öµÄÊÇ:
1 a1 b1
2 a2 b2
ÄÇôleft join Ö¸:
select * from a left join
b on
a.aid = b.bid
È¡³öa±íËùÓÐÊý¾Ý,ÄÃbµÄÊý¾ÝÓëa±È½Ï,ÏàͬµÄÈ¡³ö,²»Í¬µÄbÈ¡¿Õֵȡ³ö
´ËʱµÄÈ¡³öµÄÊÇ:
1 a1 b1
2 a2 b2
3 a3 ¿Õ×Ö·û
ͬÑùµÄÒ²ÓÐright join
select * from a right join
b on
a.aid = b.bid
È¡³öb±íËùÓÐÊý¾Ý,ÄÃaµÄÊý¾ÝÓëb±È½Ï,ÏàͬµÄÈ¡³ö,²»Í¬µÄaÈ¡¿Õֵȡ³ö
´ËʱµÄÈ¡³öµÄÊÇ:
1 a1 b1
2 a2 b2
4 ¿Õ×Ö·û b4
×¢:
¶¼ÊÇÔÚonµÄÌõ¼þÏÂ
¶þ. left join/right join/inner join²Ù×÷ÑÝʾ
±íA¼Ç¼ÈçÏ£º
aID aNum
1 a20050111
2 a20050112
3 a20050113
4 a20050114
5 a20050115
±íB¼Ç¼ÈçÏÂ:
bID bName
1 2006032401
2 2006032402
3 2006032403
4 2006032404
8 2006032408
ʵÑéÈçÏÂ:
1. left join
sqlÓï¾äÈçÏÂ:
SELECT
*
from
A
LEFT
JOIN
B
ON
A.aID
=
B.bID
½á¹ûÈçÏÂ:
aID aNum &
Ïà¹ØÎĵµ£º
LinuxÏÂmysqlµÄ°²×°²½Ö裨·Çrpm°²×°£©
1 ÏÂÔØmysql-standard-5.0.27-linux-i686-glibc23.tar.gz °ü
2 ½âѹµ½°²×°Ä¿Â¼£º tar -zxvf /edass/db/mysql-standard-5.0.27-linux-i686-glibc23.tar.gz
3 ½« mysql-standard-5.0.27-linux-i686-glibc23Á´½Óµ½mysql : ln –s mysql-standard-5.0.27-linux-i686 ......
·µ»ØÒ»¸ö½á¹ûÈ«ÊÀ½ç¶¼ÖªµÀÔõô´¦Àí£¬¹Ø¼üÊÇ·µ»Ø¶à¸ö½á¹û¼¯¾Í²»ºÃ°ìÁË£¬ÏÂÃæÓÐÒ»½â¾ö°ì·¨
´æ´¢¹ý³Ì´úÂë
DELIMITER $$;
DROP PROCEDURE IF EXISTS `test`.`sp_test`$$
CREATE PROCEDURE `test`.`sp_test` ()
BEGIN
select * from `user`.`user` limit 0, 50;
select coun ......
Ò»°ãÈË×ÜÊÇÒòΪĿ¹â¶Ìdz¶ø´íʧ׬Ǯ»ú»á£¬larry ÔÚÑÛ¹â·½Ãæ×ÜÄÜ¿´µÄ³¤Ô¶£¬ÒÔǰһϵÁеÄÊÕ¹º×ãÒÔÖ¤Ã÷¡£²»¹ýÕâ´Î¾Ü¾øÅ·ÃË»á¸øOracle´øÀ´ºÜ´óµÄÂé·³£¬Å·ÖÞÊг¡²»ÒªÁË£¿ ÎÒ²ÂÒ²Ðí»á´ò¹Ù˾¡£ Oracle¶ÔSAPÏòÀ´³ðÊÓ£¬Õâ´ÎSAPÀûÓÃÅ·ÃË´òÁËÒ»¸öƯÁÁµÄ·ü»÷Õ½£¬½ÓÏÂÀ´¾Í¿´OracleÔõô·´»÷ÁË£¬ÊÃÄ¿ÒÔ´ý¡£
......
1¡¢ÏÔʾÊý¾Ý¿âÁÐ±í¡£
show databases;
¸Õ¿ªÊ¼Ê±²ÅÁ½¸öÊý¾Ý¿â£ºmysqlºÍtest¡£mysql¿âºÜÖØÒªËüÀïÃæÓÐMYSQLµÄϵͳÐÅÏ¢£¬ÎÒÃǸÄÃÜÂëºÍÐÂÔöÓû§£¬Êµ¼ÊÉϾÍÊÇÓÃÕâ¸ö¿â½øÐкÃ×÷¡£
2¡¢ÏÔʾ¿âÖеÄÊý¾Ý±í£º
use mysql£» £¯£¯´ò¿ª¿â£¬Ñ§¹ýFOXBASEµÄÒ»¶¨²»»áİÉú°É
show tables;
3¡¢ÏÔʾÊý¾Ý±íµÄ½á¹¹£º
describe ±í ......
MySQL ÃüÁîÐÐ
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈ ......