ÆÕͨMySQLÔËÐУ¬Êý¾ÝÁ¿ºÍ·ÃÎÊÁ¿²»´óµÄ»°£¬ÊÇ×ã¹»¿ìµÄ£¬µ«Êǵ±Êý¾ÝÁ¿ºÍ·ÃÎÊÁ¿¾çÔöµÄʱºò£¬ÄÇô¾Í»áÃ÷ÏÔ·¢ÏÖMySQLºÜÂý£¬ÉõÖÁdownµô£¬ÄÇô¾ÍÒª¿¼ÂÇÓÅ»¯ÎÒÃǵÄMySQLÁË¡£ÆäÖÐÓÅ»¯MYSQLµÄÒ»¸öÖØÒª»·½Ú¾ÍÊÇΪÊý¾Ý¿â½¨Á¢ÕýÈ·ºÏÀíµÄË÷Òý¡£
Èç¹ûûÓÐË÷Òý£¬Ö´ÐвéѯʱMySQL±ØÐë´ÓµÚÒ»¸ö¼Ç¼¿ªÊ¼É¨ÃèÕû¸ö±íµÄËùÓмǼ£¬Ö±ÖÁÕÒµ½·ûºÏÒªÇóµÄ¼Ç¼¡£±íÀïÃæµÄ¼Ç¼ÊýÁ¿Ô½¶à£¬Õâ¸ö²Ù×÷µÄ´ú¼Û¾ÍÔ½¸ß¡£Èç¹û×÷ΪËÑË÷Ìõ¼þµÄÁÐÉÏÒѾ´´½¨ÁËË÷Òý£¬MySQLÎÞÐèɨÃèÈκμǼ¼´¿ÉѸËٵõ½Ä¿±ê¼Ç¼ËùÔÚµÄλÖá£Ò²¾ÍÊÇ˵Ë÷Òý¿ÉÒÔ´ó´ó¼õÉÙÊý¾Ý¿â¹ÜÀíϵͳ²éÕÒÊý¾ÝµÄʱ¼ä¡£
Ë÷ÒýÓÐÄÄЩÓŵ㣿
1¡¢ ͨ¹ý´´½¨Î¨Ò»ÐÔË÷Òý£¬¿ÉÒÔ±£Ö¤Êý¾Ý¿â±íÖÐÿһÐÐÊý¾ÝµÄΨһÐÔ¡£
2¡¢ ¿ÉÒÔ´ó´ó¼Ó¿ìÊý¾ÝµÄ¼ìË÷ËÙ¶È£¬ÕâÒ²ÊÇ´´½¨Ë÷ÒýµÄ×îÖ÷ÒªÔÒò¡£
3¡¢ ¿ÉÒÔ¼ÓËÙ±íºÍ±íÖ®¼äµÄÁ¬½Ó£¬ÕâÔÚʵÏÖÊý¾ÝµÄ²Î¿¼ÍêÕûÐÔ·½ÃæÌرðÓÐÒâÒå¡£
4¡¢ ÔÚʹÓ÷Ö×éºÍÅÅÐò×Ӿ佸ÐÐÊý¾Ý¼ìË÷ʱ£¬Í¬Ñù¿ÉÒÔÏÔÖø¼õÉÙ²éѯÖзÖ×éºÍÅÅÐòµÄʱ¼ä¡£
Ë÷ÒýÓÐÄÄЩȱµã£¿
1¡¢ ´´½¨Ë÷ÒýºÍά»¤Ë÷ÒýÒªºÄ·Ñʱ¼ä£¬ÕâÖÖʱ¼äËæ×ÅÊý¾ÝÁ¿µÄÔö¼Ó¶øÔö¼Ó¡£
2¡¢ ³ýÁËÊý¾Ý±íÕ¼Êý¾Ý¿Õ¼äÖ®Í⣬ÿһ¸öË÷Òý»¹ÒªÕ¼Ò»¶¨µÄÎïÀí¿Õ¼ä£¬Èç¹ûÒª½¨Á¢¾Û´ØË÷Òý£¬ÐèÒªµÄ¿Õ¼ä¾Í»á¸ü´ó¡£
3¡¢ µ±¶Ô±í ......
step 1)ÏÂÔØÔ´´úÂë°üµ½±¾µØLinuxÖ÷»ú£¬È»ºó½âѹËõ£¬½øÈë¸ÃĿ¼£¬½øÐÐÅäÖ㬱àÒëºÍ°²×°
ÏÂÔØmysql5Ô´Âëmysql-5.0.18.tar.gzµ½Ä¿Â¼/usr/local
cd /usr/local
tar xzvf mysql-5.0.18.tar.gz
cd mysql-5.0.18
./configure --prefix=/usr/local/mysql
make && make install
make¹ý³Ì»¨µÄʱ¼ä±È½Ï³¤
step 2)ÅäÖÃ
cp support-files/my-medium.cnf /etc/my.cnf
vi /etc/my.cnf ¼ÓÈëÒÔÏÂÁ½Ðв¢±£´æ
log-error=/var/lib/mysql/data/x.err
datadir= /var/lib/mysql/data
cd /usr/local/mysql
bin/mysql(¿ÉÄܻᱧ´íCan't connect to local MySQL server through socket '/tmp/mysql.sock' (2) )
È»ºó
scripts/mysql_install_db --user=mysql
bin/mysqld_safe
ÔÙ
/usr/local/mysql/bin/mysql¾ÍokÁË
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h localhost.localdomain password 'new-password' ......
step 1)ÏÂÔØÔ´´úÂë°üµ½±¾µØLinuxÖ÷»ú£¬È»ºó½âѹËõ£¬½øÈë¸ÃĿ¼£¬½øÐÐÅäÖ㬱àÒëºÍ°²×°
ÏÂÔØmysql5Ô´Âëmysql-5.0.18.tar.gzµ½Ä¿Â¼/usr/local
cd /usr/local
tar xzvf mysql-5.0.18.tar.gz
cd mysql-5.0.18
./configure --prefix=/usr/local/mysql
make && make install
make¹ý³Ì»¨µÄʱ¼ä±È½Ï³¤
step 2)ÅäÖÃ
cp support-files/my-medium.cnf /etc/my.cnf
vi /etc/my.cnf ¼ÓÈëÒÔÏÂÁ½Ðв¢±£´æ
log-error=/var/lib/mysql/data/x.err
datadir= /var/lib/mysql/data
cd /usr/local/mysql
bin/mysql(¿ÉÄܻᱧ´íCan't connect to local MySQL server through socket '/tmp/mysql.sock' (2) )
È»ºó
scripts/mysql_install_db --user=mysql
bin/mysqld_safe
ÔÙ
/usr/local/mysql/bin/mysql¾ÍokÁË
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h localhost.localdomain password 'new-password' ......
±¾Ê¾Àýͨ¹ý while...end while Ñ»·¿ØÖÆÓαêÀ´ÊµÏÖ²åÈë±í¼Ç¼¡£
DROP PROCEDURE IF exists pro_initCategoryForTradingEntity;
create procedure pro_initCategoryForTradingEntity(tradingEntityId int)
begin
declare f_parent,entityId int;
declare b int default 0; /*ÊÇ·ñ´ïµ½¼Ç¼µÄĩβ¿ØÖƱäÁ¿*/
declare f_name varchar(100);
DECLARE cur_1 CURSOR FOR select FName,FParent,tradingEntityId from t_category_tag;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET b = 1;
OPEN cur_1;
FETCH cur_1 INTO f_name, f_parent, entityId; /*»ñÈ¡µÚÒ»Ìõ¼Ç¼*/
while b<>1 do
insert into t_category(FName,FParent,FTradingEntity) values(f_name, f_parent, entityId);
FETCH cur_1 INTO f_name ......
Ô¶³ÌÁ¬½ÓÁíһ̨µçÄÔµÄmysqlµÄÊý¾Ý¿âʱ£¬Èç¹ûÁ¬½Ó²»ÉÏ£¬Õâʱºò¾ÍÒªÔÚ±»Á¬½ÓµÄµçÄÔÉÏÖ´ÐÐÒÔÏÂÃüÁ
ÔÒò£ºÊÇûÓиøµÇ¼Óû§ÃûÉèÖÃÔ¶³ÌÖ÷»úµÇ¼µÄȨÏÞ
1¡£µÇ¼mysql £º
Ö´ÐУºmysql -u root -p
2¡£ÐÞ¸Ä MySQL Êý¾Ý¿âÖÐ user ±íÖÐ ¶ÔÓ¦Óû§ÃûµÄ Host ×ֶΣ¬½« localhost ¸ÄΪ %
Ö´ÐУºuse mysql;
ÔÙÖ´ÐУºupdate user set Host = '%' where User = 'username';
È»ºóÖØÆô£ºsudo /etc/init.d/mysql restart
ÕâÑù¾Í¿ÉÒÔÁË ......
unixODBC°²×°
Õ⼸ÌìÕæÊÇÓôÃÆËÀÁË£¬»ù±¾Ã¿Ìì¶¼ÔÚ±àÒë°²×°QTºÍunixODBC£¬ÎÞÄÎ×Ü»á³öÏÖЩĪÃûÆäÃîµÄ´íÎó¡£Ê×ÏÈ£¬ÎÒ³ÐÈÏÎÒLinuxÍæµØ²»Ê죬µ«ÕâЩ¿ªÔ´Èí¼þ²úÉÌÖ®¼äµÄ¼æÈÝÐÔҲ̫²îÁ˰ɡ£ËùÒÔ»¹ÊÇÖÆ¶¨¸ö±ê×¼±È½ÏºÃ£¬´ó¼Ò¶¼×ñÊØÒ»¸öÔ¼¶¨¡£´ÓÕâ¸öÒâÒåÀ´Ëµ£¬Î¢ÈíµÄ¢¶Ï£¬»¹ÊÇÓÐÒ»¶¨µÄºÃ´¦µÄ¡£
×îÖÕQT»¹ÊÇûÓа²×°³É¹¦£¬´ËǰÓÐÒ»¸ö°æ±¾£¬¾¹ýСµÄ¸Ä¶¯ÒѾÄܱàÒë°²×°³É¹¦ÁË£¬²»ÖªÎªÊ²Ã´£¬ºóÀ´ÔõôҲ°²×°²»ÉÏ£¬Ôΰ¢¡£ºóÀ´·¢ÏÖ£¬°²×°unixODBC¿ÉÒÔ²»ÆôÓÃQT¹¦ÄÜ£¬ËäȻûÓÐͼÐνçÃæ£¬µ«ºËÐŦÄÜÊÇÓеġ£¿öÇÒ£¬Õâ¸öÇý¶¯¹ÜÀíÆ÷×îÖÕ»¹ÒªÒÆÖ²µ½Ò»¸öǶÈëʽ²Ù×÷ϵͳÉÏ£¬Ï໥ÒÀÀµµÄ×é¼þÔ½¶à£¬×é¼þÒ²Ô½ÄÑÒÆÖ²¡£Ï¸öÐÇÆÚ°ÑunixODBCÒÆÖ²µ½VxWorksÉÏ£¬¹À¼ÆÎÊÌâ²»ÉÙ......
½áºÏÍøÂçÉÏÏÂÔØµÄһЩ×ÊÁÏ£¬°Ñ×î½ü¹¤×÷µÄµÄ¶«Î÷×ܽáÏ¡£
1.°²×°unixODBC×é¼þ£º
(1).ÔÚubuntuÏ£¬ÀûÓÃÐÂÁ¢µÂÏÂÔØÃüÁºÜÈÝÒ×¾ÍÄܰ²×°unixODBC
apt-get install unixODBC
(2)ÀûÓÃÔ´Â룬±àÒë°²×°£ ......
MySQLÓï¾äÓÅ»¯µÄÔÔò
1¡¢Ê¹ÓÃË÷ÒýÀ´¸ü¿ìµØ±éÀú±í¡£
¡¡¡¡È±Ê¡Çé¿öϽ¨Á¢µÄË÷ÒýÊÇ·ÇȺ¼¯Ë÷Òý£¬µ«ÓÐʱËü²¢²»ÊÇ×î¼ÑµÄ¡£ÔÚ·ÇȺ¼¯Ë÷ÒýÏ£¬Êý¾ÝÔÚÎïÀíÉÏËæ»ú´æ·ÅÔÚÊý¾ÝÒ³ÉÏ¡£ºÏÀíµÄË÷ÒýÉè¼ÆÒª½¨Á¢ÔÚ¶Ô¸÷ÖÖ²éѯµÄ·ÖÎöºÍÔ¤²âÉÏ¡£Ò»°ãÀ´Ëµ£º
¡¡¡¡a.ÓдóÁ¿Öظ´Öµ¡¢ÇÒ¾³£Óз¶Î§²éѯ£¨ > ,< £¬> =,< =£©ºÍorder by¡¢group by·¢ÉúµÄÁУ¬¿É¿¼Âǽ¨Á¢Èº¼¯Ë÷Òý£»
¡¡¡¡b.¾³£Í¬Ê±´æÈ¡¶àÁУ¬ÇÒÿÁж¼º¬ÓÐÖØ¸´Öµ¿É¿¼Âǽ¨Á¢×éºÏË÷Òý£»
¡¡¡¡c.×éºÏË÷ÒýÒª¾¡Á¿Ê¹¹Ø¼ü²éѯÐγÉË÷Òý¸²¸Ç£¬Æäǰµ¼ÁÐÒ»¶¨ÊÇʹÓÃ×îÆµ·±µÄÁС£Ë÷ÒýËäÓÐÖúÓÚÌá¸ßÐÔÄܵ«²»ÊÇË÷ÒýÔ½¶àÔ½ºÃ£¬Ç¡ºÃÏà·´¹ý¶àµÄË÷Òý»áµ¼ÖÂϵͳµÍЧ¡£Óû§ÔÚ±íÖÐÿ¼Ó½øÒ»¸öË÷Òý£¬Î¬»¤Ë÷Òý¼¯ºÏ¾ÍÒª×öÏàÓ¦µÄ¸üй¤×÷¡£
¡¡¡¡2¡¢ÔÚº£Á¿²éѯʱ¾¡Á¿ÉÙÓøñʽת»»¡£
¡¡¡¡3¡¢ORDER BYºÍGROPU BYʹÓÃORDER BYºÍGROUP BY¶ÌÓÈκÎÒ»ÖÖË÷Òý¶¼ÓÐÖúÓÚSELECTµÄÐÔÄÜÌá¸ß¡£
¡¡¡¡4¡¢ÈκζÔÁеIJÙ×÷¶¼½«µ¼Ö±íɨÃ裬Ëü°üÀ¨Êý¾Ý¿âº¯Êý¡¢¼ÆËã±í´ïʽµÈµÈ£¬²éѯʱҪ¾¡¿ÉÄܽ«²Ù×÷ÒÆÖÁµÈºÅÓұߡ£
¡¡¡¡5¡¢IN¡¢OR×Ӿ䳣»áʹÓù¤×÷±í£¬Ê¹Ë÷ÒýʧЧ¡£Èç¹û²»²úÉú´óÁ¿Öظ´Öµ£¬¿ÉÒÔ¿¼ÂǰÑ×Ó¾ä²ð¿ª¡£²ð¿ªµÄ×Ó¾äÖÐÓ¦¸Ã°üº¬Ë÷Òý ......