[Level 2] MySQL Stored Procedure Characteristics

MySQL Stored Procedure has two major characters, "SQL SECURITY" and "Data Use".
"SQL SECURITY" defines what's the effect user while procedure is called, and "Data Use" indicates the procedure R/W. The detail information as the following:
1. SQL SECURITY:
  a. DEFINER-The routine will have the privileges of the user who created it.
  b. INVOKER-The routine will have the privileges of ther user who run it.
  If you want to change the character, use the command as below:
  mysql> ALTER PROCEDURE procedure_name SQL SECURITY [DEFINER/INVOKER];
2. Data Use:
  a. CONTAONS SQL-The option indicates that the routine has the SQL statement but it does not have read or write data.
  b. NO SQL-The option indicates that the routine does not have SQL statement.
  c. READS SQL DATA-The option indicates that the routine has the SQL statement with read data only.
  d. MODIFIES SQL DATA-The option indicates that the routine has the SQL statement with modify data.
  If you want to change the character, use the command as below:
  mysql> ALTER PROCEDURE procedure_name [CONTAINS SQL/NO SQL/READS SQL DATA/MODIFIES SQL DATA];

Wish this helps.

regards,
Stanley Huang

Comments

Post a Comment

Popular posts from this blog

[Level 1] Rar tool for Solaris.

Sometimes we will got a rar compressed file from our friends, but there is no default tool in OpenSolaris to decompress the rar filess. We can got a Solaris Intel version from rarlab . The steps as the following: 1. down load the rar tools from rarlab. http://www.rarlab.com/rar_add.htm 2. uncompressed the source. # gunzip ./unrar-sol-intel.gz 3. move it to the location you used to. # mv /unrar-sol-intel.gz /usr/bin/unrar 4. try to decomprss # unrar x ./test.rar Wish this helps. regards, Stanley Huang
Read more

[Level 2] iif in Python

If you want to implement iif in Python, please refer to the following sample code: #!/bin/env python def iif(b): return 'It\'s True' if b else 'It\'s False' print iif(True) print iif(False) And the following sample, guess what will you get! #!/bin/env python b = True print 'b: %s' % 'Ture' if b else 'False' b = False print 'b: %s' % 'Ture' if b else 'False' Result: $ ./iif.py b: Ture False The second result is "False", not "b: False". Why??? Because the prededence of string concatenation is higher than if. Therefore you need to use () to make it correct. #!/bin/env python b = True print 'b: %s' % 'Ture' if b else 'False' b = False print 'b: %s' % ('Ture' if b else 'False') Wish this helps. regards, Stanley Huang
Read more