Mysql¶à±í²éѯ£¬¶à±í²åÈëºÍ¶à±í¸üÐÂ
/*************************************by
garcon1986*****************************************************/
¶à±í²éѯ£º
CREATE TABLE IF NOT EXISTS contact(
contact_id int(11) NOT NULL AUTO_INCREMENT,
user_name varchar(255),
nom varchar(255),
prenom varchar(255),
mail varchar(64),
passcode char(64),
PRIMARY KEY(contact_id)
);
CREATE TABLE IF NOT EXISTS droit(
droit_id int( 11 ) NOT NULL AUTO_INCREMENT ,
droit varchar(255),
PRIMARY KEY(droit_id)
);
CREATE TABLE IF NOT EXISTS contactdroit(
contactdroit_id int(11) NOT NULL AUTO_INCREMENT,
contact_id int( 11 ),
droit_id int( 11 ),
PRIMARY KEY( contactdroit_id )
);
Insert into contact(contact_id, user_name) values(1,'user1');
Insert into contact(contact_id, user_name) values(2,'user2');
Insert into contact(contact_id, user_name) values(3,'user3');
Insert into droit(droit_id, droit) values(1,'admin');
Insert into droit(droit_id, droit) values(2,'superuser');
Insert into contactdroit(contact_id, droit_id) values(1, 1);
Insert into contactdroit(contact_id, droit_id) values(2, 1);
Insert into contactdroit(contact_id, droit_id) values(3, 2);
SELECT c.contact_id, d.droit_id, d.droit from contact c, contactdroit
cd, droit d
where c.contact_id = cd.contact_id
and cd.droit_id = d.droit_id;
½á¹û£º
contact_id droit_id droit
1 1 admin
2 1 admin
3 2 superuser
¶à±íÁª²éÀý×Ó£º
Á½¸ö·½·¨¶¼¿ÉÒÔ£¬inner join on ¸üºÃµã¡£
±í½á¹¹Ã»Ìù³öÀ´£¬µ«±È½ÏºÃ¶®ÁË¡£
¼òµ¥·½·¨£º
select c.nom, e.nom
from consul
Ïà¹ØÎĵµ£º
DOS¡¡´°¿Ú
¿ªÊ¼££¾ÔËÐУ£¾¡¡cmd
µ¼³öΪ£º¡¡mysqldump -u Óû§Ãû -p --opt Êý¾Ý¿âÓû§Ãû >
Êý¾Ý¿âÃû.sql
ÊäÈëÄãµÄÊý¾Ý¿âÃÜÂë!phpma.com
µ¼ÈëΪ£ºmysql -u Óû§Ãû -p Êý¾Ý¿âÓû§Ãû < Êý¾Ý¿âÃû.sql
£¨Òª
ÔÚµ±Ç°Ä¿Â¼Ï²Ù×÷£©
ÒªÏ뽫Îı¾Îļþ
“
pet.txt
”
×°ÔØµ½
pet
±íÖУ¬Ê¹Ó ......
http://www.xiaojb.com/archives/it/mysqlroot.shtml
Method 1:
ÔÚ/usr/local/mysql/bin/Ï£º
./mysqladmin -u root password ‘new_password’
Ò»°ã°²×°Ê±Óô˷½·¨ÉèÖá£
Method 2:
ÔÚmysql״̬Ï£º
mysql>UPDATE user SET password=PASSWORD(’new_password’) WHERE user=’root&rsq ......
ÔÚÉú²úÓ¦ÓÃÖУ¬Ä³Ì¨“Nginx+PHP+MySQL”½Ó¿ÚÊý¾Ý·þÎñÆ÷£¬°çÑݵĽÇɫʮ·ÖÖØÒª£¬Èç¹û·þÎñÆ÷Ó²¼þ»òNginx¡¢MySQL·¢Éú¹ÊÕÏ£¬¶ø¶Ìʱ¼äÄÚÎÞ·¨»Ö¸´£¬ºó¹û½«·Ç³£ÑÏÖØ¡£ÎªÁ˱ÜÃâµ¥µã¹ÊÕÏ£¬ÎÒÉè¼ÆÁË´ËÌ×·½°¸£¬±àдÁËfailover.sh½Å±¾£¬ÊµÏÖÁËË«»ú»¥±¸¡¢È«×Ô¶¯Çл»£¬¹ÊÕÏ×ªÒÆÊ±¼äÖ»Ð輸ʮÃë¡£
¡¡¡¡Ò»¡¢Ë«»ú»¥±¸¡¢È«×Ô¶¯Çл»·½ ......
apacheµÄÔ´Âë°²×°
½«Ñ¹Ëõ°ü½âѹ֮ºó½øÈëÏàÓ¦µÄĿ¼
./configure \ #--------------------Ô¤±àÒëÃüÁî
"--prefix=/usr/local/apache" \ #--------------------°²×°Â·¾¶Îª“/usr/local/apache”
"--with-included-apr" \
"--enable-so" \ #--------------------¿ªÆôÏàÓ¦µÄÀ©Õ¹Ä£¿é ......
ѧjava,ÓÐ×ÅÌ«¶àµÄÒÉÎʺͲ»½â,¾ÀúÁËÎÞÊýËÆºõ¼òµ¥µ½ÎÊÌâ½â¾öºóͻȻ·¢ÏÖ×Ô¼ºÄÇôsxµÄµØ²½,È»¶ø¾ÍÎҵĸоõ,¶Ôÿ¸ö³õѧÕßÀ´Ëµ¶¼ÎÞ·¨±ÜÃâµÄÒª¾¹ýÕâ¸öÈÃÈËÍ´¿àµ½¶ñÐÄŻ͵½µ½»èØÊµÄµØ²½;ÕâÒ²ÐíÕýÊÇjava½ø½×֮ǰËùν×òÒ¹Î÷·çµò±ÖÊ÷°ãµÄ±Ø¾Ö®Í¾°É!
·Ï»°²»¶à˵ÁË,ÏÂÃæ ......