mysqlのいくつかの記録を勉強します

SHOW VARIABLES;/**            **/
/*             。       */
DROP PROCEDURE IF EXISTS helloword
/*      */
DELIMITER //
CREATE PROCEDURE helloword()
BEGIN
	SELECT 'hellor word';
END
/*      */
CALL helloword

DROP PROCEDURE IF EXISTS pr_add
/*            */
DELIMITER //
CREATE PROCEDURE pr_add(
a INT,
b INT)
BEGIN 
IF a IS NULL THEN
SET a=0;
END IF;
SELECT a+b;
END 
/*  */
CALL pr_add(NULL,1);
/*      */
DROP PROCEDURE pr_add;
/*    */
CREATE VIEW teabc AS SELECT * FROM abcd WHERE abc='aa'
SELECT * FROM teabc
/*       */
SHOW GRANTS FOR root@localhost
/*               insert update delete*/
/*   ：  abcd            begin    SetUserHome       */
DELIMITER //
CREATE TRIGGER SetUserHome BEFORE INSERT ON abcd
FOR EACH ROW   
BEGIN   
INSERT INTO stime VALUE(NOW(),'hello word');
END 

/*      */
/*  ：select,insert,update,delete,create,drop,index,alter,grant,references,reload,shutdown,process,file
        ，   all  all privileges      。*/
/*alter       create        delete          drop   （  ）     index        
insert        reference   select        update        file           
process                   reload           、        。shutdown      
all   ；all privileges   usage    “   ”  */
/*             */
UPDATE USER SET PASSWORD=PASSWORD('zhouhui') WHERE USER='root';
/*        ：     test         mfkwfc   127.0.0.1       123*/
GRANT ALL PRIVILEGES ON test.* TO [email protected] IDENTIFIED BY '123';
/*       */
REVOKE INSERT ON test.* FROM [email protected];
/*       */
GRANT INSERT ON test.* TO [email protected]
/*      USAGE      */
GRANT USAGE ON test.* TO [email protected] IDENTIFIED BY 'mfkwfc';
/*    */
FLUSH PRIVILEGES;