MYSQL °üº¬ÊÂÎï,²ÎÊý,ÓαêµÈµÄ×ÛºÏʹÓÃÀý×Ó,ǰÕÂ(1)
1.Ê×ÏȵöÔmysql ÀïÃæµÄ²ÎÊý½øÐнéÉÜÏÂ:
procedure--in:ÊäÈë²ÎÊý,outÊä³ö²ÎÊý,inoutÕâ¸ö¾Í²»ÓÃ˵ÁË,´ó¸ÅÒ²²Âµ½ÁË
declare:ÉùÃ÷±äÁ¿.¼ÇÖ÷,ËùÓÐÉùÃ÷±ØÐëÔÚ·ÇÉùÃ÷Óï¾äǰÍê³É,·ñÔò»á±¨´í
2.mysql ³£Óú¯Êý½éÉÜ:
*.concat('s','a',5) ¿ÉÒÔÄÇÊýֵת»»³É×Ö·û´®,Ò²¿ÉÒÔ½øÐÐ×Ö·û´®µÄºÏ²¢
Èç:set str=concat('asd','ad',56) ----> str='asdad56'
declare num in;set num=156;set @ste=concat('',num)|(num);-->@str='156'
mysql> select CONCAT('My', NULL, 'QL');
¡¡¡¡ -> NULL
*.ASCII(str),·µ»Ø×Ö·û´®strµÄµÚÒ»¸ö×Ö·ûµÄASCIIÖµ(strÊǿմ®Ê±·µ»Ø0)
Èç:mysql> select ASCII('2');-> 50
*.CONV(N,from_base,to_base),¶ÔÊý×ÖN½øÖÆ×ª»»,²¢×ª»»Îª×Ö´®·µ»Ø(ÈκβÎÊýΪNULLʱ·µ»ØNULL,½øÖÆ·¶Î§Îª2-36ÖÆ, µ±to_baseÊǸºÊýʱN×÷ΪÓзûºÅÊý·ñÔò×÷ÎÞ·ûºÅÊý,CONVÒÔ64λµã¾«¶È¹¤×÷)
Èç:mysql> select CONV("a",16,2);
¡¡¡¡ -> '1010'
mysql> select CONV(-17,10,-18);
¡¡¡¡ -> '-H'
mysql> select CONV(10+"10"+'1
Ïà¹ØÎĵµ£º
Unix&Linux£º
1.ÓÃroot»òÕßÔËÐÐmysqldµÄÓû§µÇ¼ϵͳ£»
2£®ÀûÓÃkillÃüÁî½áÊøµômysqldµÄ½ø³Ì£»
3£®Ê¹ÓÃ--skip-grant-tables²ÎÊýÆô¶¯MySQL Server
shell>mysqld_safe --skip-grant-tables &
4.Ϊroot@localhostÉèÖÃÐÂÃÜÂë
shell>mysqladmin -u root flush-privileges password "newpassword" ......
×î½üÔÚѧϰSSH£¬ÓÉÓÚΪÁ˽ÚÔ¼Äڴ棬ËùÒÔ¾Í×¼±¸Ê¹ÓÃMYSQL´úÌæOracle£¬ÎªÁ˸üÉîÒ»²½µØÁ˽âMySQL£¬ÓÚÊǾͼƻ®°²×°noinstall°æ±¾£¬Õâ°æ±¾±È°²×°°æ¿ÉÂ鷳һЩ£¬ÌرðÊÇÅäÖ÷½Ã棬Èç¹ûÅäÖúõϰ¾Í¿ÉÒÔÔÚһ̨»úÆ÷ÉÏÔËÐжà¸ö°æ±¾µÄMYSQL£¬ÔÚÍøÉÏÕÒÁËǰ±²ÃǵıʼǺóѧϰÍê±ÏºóÔټǼһ±Ê£¬¾ÍÎÒÕâ¼ÇÐÔ£¬¹À¼ÆÃ ......
ÓкܶàÅóÓÑËäÈ»°²×°ºÃÁËmysqlµ«È´²»ÖªÈçºÎʹÓÃËü¡£ÔÚÕâÆªÎÄÕÂÖÐÎÒÃǾʹÓÁ¬½ÓMYSQL¡¢ÐÞ¸ÄÃÜÂë¡¢Ôö¼ÓÓû§µÈ·½ÃæÀ´Ñ§Ï°Ò»Ð©MYSQLµÄ³£ÓÃÃüÁî¡£
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µ ......
Èý²½×ߣº
1.ÔÚwindows-->perspective-->DB browser
2.Create a database connection profile
Çý¶¯ÏÂÔØ£º http://dev.mysql.com/downloads/
ÎļþÃû£ºmysql-connector-java-5.0.4-bin
3.Open a database connection
Á´½Óʱ¿ÉÄܳöÏÖ´íÎó£¬ÄÇôÇë³¢ÊÔÈçÏ·½·¨£º
Err ......