Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MySQL¿Í»§¶ËÔ¶³ÌÁ¬½Ó1045µÄ´íÎó

×î½üÐèҪʹÓÃMySQL£¬Ö»ºÃ¸Ï½ôѧϰһÏ¡£ÄÄÀïÖªµÀµÚÒ»²½¾Í¿¨×¡ÁË¡£×°ÁËÒ»¸ö¿Í»§¶Ë£¬Á¬²»ÉÏ£¬±¨1045µÄ´íÎó¡£
´ÓÍøÉÏÕÒÁËһϣ¬Èý²½¾ÍºÃ¡£
INSERT INTO `user` VALUES ('%','root','*196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0);
GRANT ALL PRIVILEGES ON *.* TO root@"%";
FLUSH PRIVILEGES;
µÚÒ»²½ÎҸijÉinsertÁË¡£
»¹ÓоÍÊǶÔMySQL²»ÊìϤ£¬²»ÖªµÀÕâ¸öUSER±íµÄ¾ßÌåÓ÷¨£¬¾ÍÏȵ¼³öÀ´£¬¸´ÖÆÁËÒ»Ìõ¡£
µ¼³öµ¹ÊǺܷ½±ã£º
# mysqldump -uroot -ppass mysql > mysql.sql


Ïà¹ØÎĵµ£º

mysqlËæ»úÊý¾ÝÉú³É²¢²åÈë

      dblpÊý¾Ý¿âÖÐÒýÓÃÐÅÏ¢ºÜÉÙ£¬Æ½¾ùһƪÂÛÎÄÒýÓÃ0.2ƪ¡£Ê¹ÓÃdblp×öʵÑéÊý¾Ý¼¯µÄijƪÂÛÎÄÌáµ½£¬¿ÉÒÔËæ»úÌí¼ÓÒýÓÃÐÅÏ¢¡£ÊÜ´ËÆô·¢£¬ÎÒ´òËãΪÿһƪÂÛÎĶ¼Ìí¼Ó20ƪËæ»úÒýÓã¬ÓÚÊǾÍд³öÁËÈçϵÄsqlÓï¾ä£º
     String sql = "insert into citation(pId1,pId2) values( (selec ......

LVS & MySQL NDB Cluster

×é³ÉLVS×îÖØÒªµÄ²¿·ÖÓÐÈý¸ö£ºÇëÇó·Ö·¢·þÎñÆ÷¡¢´¦Àí·þÎñÆ÷¡¢¹²Ïí´æ´¢¡£
µäÐ͵ÄWeb¼¯Èº²¢²»ÐèÒª¹²Ïí´æ´¢£¬Ö»ÓÐÇëÇó·Ö·¢·þÎñÆ÷ºÍ´¦Àí·þÎñÆ÷£¬ÈçÏÂͼËùʾ£º
Èç¹ûÍê³ÉÇëÇóÐèÒª»ùÓÚÊý¾Ý£¬ÄÇô¹²Ïí´æ´¢¾ÍÊÇLVS±ØÐëµÄ×é¼þÁË¡£LVSÓʼþ·þÎñÆ÷¼¯ÈºÈçÏÂËùʾ£º
Ä¿Ç°ÄÜÓ¦ÓÃÓÚLVSµÄMySQL¼¯ÈºÖ»ÄÜÊÇNDB Cluster£¬ÒòΪMySQLÖÚ¶àµÄ´æ´¢ÒýÇæ ......

windows7Ï°²×°apache+php+mysqlÎÊÌâ¼Ç¼

×î½üÐÂÂòÁ˸öµçÄÔ£¬ÏµÍ³ÊÇwindows7£¬window7ÔÚ½çÃ棬¹¦ÄÜ·½Ã涼ͦÈÃÈËÂúÒâµÄ£¬¸Ð¾õºÜˬ£¬²»Ë¬µÄÊÇÓÖÒªÖØа²×°»·¾³ÁË¡£
ËùÓÐÈí¼þ¾ù°²×°ÔÚF:\server\ÏÂ
apacheĿ¼£ºF:\server\apache2.2
phpĿ¼£ºF:\server\php
msyqlĿ¼£ºF:\server\mysql
Ò»¡¢°²×°apache
°²×°apacheµÄ°æ±¾ÊÇ£ºhttpd-2.2.15-win32-x86-no_ssl.msi
° ......

£Ûת£ÝmysqlÐ޸ıí½á¹¹alter


 
£Ûת×Ô£Ýhttp://waryist.javaeye.com/blog/104739
ALTER [IGNORE] TABLE tbl_name alter_spec [, alter_spec ...]
alter_specification:
        ADD [COLUMN] create_definition [FIRST | AFTER column_name ]
  or    ADD ......

ÍüÁËOracleµÄsysÓû§ºÍMySQLµÄrootÓû§ÃÜÂ룬½â¾ö·½·¨

ÍüÁËOracleµÄsysÓû§ºÍMySQLµÄrootÓû§ÃÜÂ룬½â¾ö·½·¨
2007Äê03ÔÂ16ÈÕ ÐÇÆÚÎå 09:44
×÷Õߣºhexiong¡¡
°æȨÉùÃ÷£º¿ÉÒÔÈÎÒâתÔØ£¬×ªÔØʱÇëÎñ±ØÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕÂԭʼ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷¡£
http://hi.baidu.com/hexiong/blog/item/b4acd72a85272d2cd42af1b1.html
¾­³£Åöµ½ÓÐÈËÔÚÂÛ̳ÉÏÎÊÕâ¸öÎÊÌ⣬¸É´àÔÚÕâÀï×ܽáÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ