뚱2's Story

링크: http://stackoverflow.com/questions/21519997/how-to-do-mysqladmin-flush-hosts-on-server

링크: http://dev.mysql.com/doc/refman/5.6/en/mysqladmin.html

링크: http://dev.mysql.com/doc/refman/5.5/en/cursors.html

CREATE PROCEDURE curdemo()

BEGIN

  DECLARE done INT DEFAULT FALSE;

  DECLARE a CHAR(16);

  DECLARE b, c INT;

  DECLARE cur1 CURSOR FOR SELECT id,data FROM test.t1;

  DECLARE cur2 CURSOR FOR SELECT i FROM test.t2;

  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

  OPEN cur1;

  OPEN cur2;

  read_loop: LOOP

    FETCH cur1 INTO a, b;

    FETCH cur2 INTO c;

    IF done THEN

      LEAVE read_loop;

    END IF;

    IF b < c THEN

      INSERT INTO test.t3 VALUES (a,b);

    ELSE

      INSERT INTO test.t3 VALUES (a,c);

    END IF;

  END LOOP;

  CLOSE cur1;

  CLOSE cur2;

END;

링크: http://dev.mysql.com/doc/refman/5.1/en/sql-syntax-prepared-statements.html

mysql> SET @s = 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse';

mysql> PREPARE stmt2 FROM @s;

mysql> SET @a = 6;

mysql> SET @b = 8;

mysql> EXECUTE stmt2 USING @a, @b;

+------------+

| hypotenuse |

+------------+

|         10 |

+------------+

mysql> DEALLOCATE PREPARE stmt2;

링크: http://www.ducea.com/2007/07/25/dumping-mysql-stored-procedures-functions-and-triggers/

function, Procedure Backup

mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt <database> > outputfile.sql

trigger 제외시키기

mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt --skip-triggers <database> > outputfile.sql

UPDATE 

       TB_EXAMPLEBOOK_HISTORY AS this

       INNER JOIN (

            SELECT i.dic_sub_id

                 , Min(i.example_id) AS work_id

              FROM TB_EXAMPLEBOOK_HISTORY i

             GROUP BY i.dic_sub_id

       ) b

       ON a.DIC_SUB_ID = b.dic_sub_id

   SET a.WORK_ID = b.work_id;

링크: http://mysqlblog.fivefarmers.com/2010/09/01/workbench-called-me-a-dummy/

Go to Edit -> Preferences

Select the SQL Editor tab

Uncheck “Forbid UPDATE and DELETE statements without a WHERE clause (safe updates)”

맥용 워크벤치는 경로가 조금 다르다.

Preferences -> SQL Queries -> "Safe Updates".Forbid UPDATEs and DELETEs with no key in WHERE clause or no LIMIT clause. Requires a reconnection.

이왕하는것 그림 같이 수정해서 Limit Rows Count도 Disable하자

그리고 재시작 해야지 적용된다.

링크: http://naleejang.tistory.com/59

#mysqladmin이 있는 폴더로 이동

./mysqladmin -u root -p password [변경할 비밀번호]

Enter password: [기존비밀번호]

링크 : http://dev.kthcorp.com/2011/06/10/mysql-innodb-engine-3-tips-you-must-know/

링크 : http://www.sequelpro.com/download