ControlGrant -- Grant the user access permissionDeny-Deny User AccessRevoke -- revoke User Access Permissions-- Transaction controlCommit -- end the current transactionRollback -- abort the current transactionSET transaction -- define the data access features of the current transaction-- Program SQLDeclare -- set the cursor for the queryExplain -- describe the data access plan for queryOpen -- open a cursor for retrieving query resultsFetch -- retrieve a row of query resultsClose -- close the c
-- Data Control
GRANT -- GRANT the user access permissionDENY-DENY User AccessREVOKE -- REVOKE User Access Permissions
-- Transaction controlCOMMIT -- end the current transactionROLLBACK -- abort the current transactionSet transaction -- define the data access features of the current TRANSACTION-- Programmatic SQL
DECLARE -- set the cursor for the queryExplain -- describe the data access plan for queryOPEN -- OPEN a cursor for retrieving query resultsFETCH -- retrieve a row of query resul
-- Data Control
GRANT -- GRANT the user access permission
DENY-DENY User Access
REVOKE -- REVOKE User Access Permissions
-- Transaction control
COMMIT -- end the current transaction
ROLLBACK -- abort the current transaction
Set transaction -- define the data access features of the current TRANSACTION
-- Programmatic SQL
DECLARE -- set the cursor for the query
Explain -- describe the data access plan for query
OPEN -- OPEN a cursor for retrieving query results
FETCH -- retrieve a row of query re
start @-- If elseDeclare @ x int @ Y int @ Z intSelect @ x = 1 @ Y = 2 @ z = 3If @ x> @ YPrint 'x> y' -- print the string 'x> y'Else if @ Y> @ ZPrint 'y> Z'Else print 'z> y'-- CaseUse panguUpdate employeeSet e_wage =CaseWhen job_level = '1' then e_wage * 1.08When job_level = '2' then e_wage * 1.07When job_level = '3' then e_wage * 1.06Else e_wage * 1.05End-- While continue breakDeclare @ x int @ Y int @ C intSelect @ x = 1 @ Y = 1While @ x BeginPrint
statementsDescribe -- describe the prepared Query
--- Local variablesDeclare @ ID char (10)-- Set @ ID = '20140901'Select @ ID = '000000'
--- Global variables--- It must start @
-- If elseDeclare @ x int @ Y int @ Z intSelect @ x = 1 @ Y = 2 @ z = 3If @ x> @ YPrint 'x> y' -- print the string 'x> y'Else if @ Y> @ ZPrint 'y> Z'Else print 'z> y'
-- CaseUse panguUpdate employeeSet e_wage =CaseWhen job_level = '1' then e_wage * 1.08When job_level = '2' th
the user access permissionDeny-Deny User AccessRevoke -- revoke User Access Permissions-- Transaction controlCommit -- end the current transactionRollback -- abort the current transactionSET transaction -- define the data access features of the current transaction-- Program SQLDeclare -- set the cursor for the queryExplain -- describe the data access plan for queryOpen -- open a cursor for retrieving query resultsFetch -- retrieve a row of query resultsClose -- close the cursorPrepare -- prepar
access permissionDeny-Deny User AccessRevoke -- revoke User Access Permissions-- Transaction controlCommit -- end the current transactionRollback -- abort the current transactionSET transaction -- define the data access features of the current transaction-- Program SQLDeclare -- set the cursor for the queryExplain -- describe the data access plan for queryOpen -- open a cursor for retrieving query resultsFetch -- retrieve a row of query resultsClose -- close the cursorPrepare -- prepare SQL sta
.
-----------------------------------------------------------------------------Standard SQL syntax
Local variables and local variables--- Local variable (starting)Format: declare @ variable name Type-- Set @ ID = '20140901'Select @ ID = '000000'
--- Global variable (must start)Format: declare @ variable name TypeCode: Select @ ID = '20140901'
-- If elseDeclare @ x int @ Y int @ Z intSelect @ x = 1 @ Y = 2 @ z = 3If @ x> @ YPrint 'x> y' -- print the string 'x> y'Else if @ Y> @
, if the given value is in ISO format, the date constructor will try to parse the date and then process other input accepted by it.
VaR date = new date ("2009-05-21t16: 06: 05.000z"); // prints 2009-05-21t16: 06: 05.000 zprint (date. toisostring ());
In addition, the date object now has a new toisostring () method to output the date in ISO format. . Trim ()
A native, built-in trim () method is supported by string objects. It features the same as t
domain drop Domain -- delete a domain from the database alter Domain -- change the domain definition -- Grant Data Control -- Grant the user access permission deny -- deny the user access revoke -- revoke the user access permission -- programmatic sqldeclare -- set the cursor for the query to explain -- open for the query description access plan -- search query results open a cursor fetch -- search a row of query results close -- close the cursor prepare -- prepare SQL statement for dynamic exe
ControlGrant -- Grant the user access permissionDeny-Deny User AccessRevoke -- revoke User Access Permissions-- Transaction controlCommit -- end the current transactionRollback -- abort the current transactionSET transaction -- define the data access features of the current transaction-- Programmatic SQLDeclare -- set the cursor for the queryExplain -- describe the data access plan for queryOpen -- open a cursor for retrieving query resultsFetch -- retrieve a row of query resultsClose -- close
you use python lambda in python list parsing, it doesn't make much sense, because python lambda creates a function object, but it is discarded immediately, because you didn't use its return value, that is, the function object. Lambda is just an expression that can be directly used as a member of the python list or python dictionary, for example:
info = [lamba a: a**3, lambda b: b**3]
There is no way to directly replace it with the def statement. Because def is a statement, not an expression tha
): return X+y+zprint (Reduce (leijia,[ 1,2,3,4,5]) #结果: 23--filterSame as two functions, accept two parameters, the first argument is the function name, the second argument is a sequence. However, the function returns the result (True/false) to determine whether the element is persisted, depending on the elements in the sequence that are acting on the function.Consider a simple example of how to filter even numbers:def select (num): if num%2==0:
the user access permissionDeny-Deny User AccessRevoke -- revoke User Access Permissions-- Transaction controlCommit -- end the current transactionRollback -- abort the current transactionSET transaction -- define the data access features of the current transaction-- Programmatic SQLDeclare -- set the cursor for the queryExplain -- describe the data access plan for queryOpen -- open a cursor for retrieving query resultsFetch -- retrieve a row of query resultsClose -- close the cursorPrepare -- p
expression that cannot be nested in it, lambda expressions can only have one expression after. That is to say, in def, return can be returned or placed behind lambda. return cannot be used or defined behind Python lambda. Therefore, statements such as if, for, or print cannot be used in Lambda. Lambda is generally only used to define simple functions.
Here are some examples of Python lambda.1. For a single parameter:G = Lambda X: x * 2Print G (3)The result is 6.
For more than 2 parameters:M
/bin/env python#Coding:utf-8defReadLines (): Seek=0" "Start Position" " whileTrue:with Open ('E:/temp.txt','R') as F:f.seek (seek) data=F.readline ()ifData:seek=F.tell ()" "finish reading the last position as the next first position" " yieldDataElse: return forIteminchreadlines ():PrintItemTernary operation Judgment (simplified code)temp=Noneif 1>3: Temp='gt'else: Temp='lt' restult='gt' if Else ' LT ' Print RestultLambda expressions do operations (simp
() function:
The eval () function differs from the EXEC () function:
The eval () function evaluates only the values of a single expression, and the Exec () function can run code snippets on the fly.
The eval () function can have a return value, and the EXEC () function return value is always none.
Example 1:Let's replace the Eval function in Example 1 with the EXEC function:x =10Deffunc (): y = 20 a = EXEC ( ' x + y ') print ( ' A: ', a) b = exec ( ' x + y ', { ' x ': 1,
One of the first Python programs1 cmd input python under Enter the interaction (interpreter), exit (exit) or CTRL + ZPrint ("Hello World")2 cmd under input python helloworld.py3 Set the first line of each Python file in Pycharm
#!/usr/bin/env python find python directory in Environment settings to prevent users from not loading Python in the default usr/bin path
#!usr/bin/python means that when executing a script, call Usr/bin under the Pytho
', ' g ', ' o ', ' n ' ', ' 1 ', ' 2 ', ' 3 ']print (Re.findall (' \w ', ' Hello Egon 123 ')) #[', ']#\s with \sprint (Re.findall (' \s ', ' Hello Egon 123 ')) #[' ', ', ', ', ']print (Re.findall (' \s ', ' Hello Egon 123 ')) #[' h ', ' e ', ' l ', ' l ', ' o ', ' e ', ' g ', ' o ', ' n ', ' 1 ', ' 2 ', ' 3 ']# \ t is all empty, can be \s match print (Re.findall (' \s ', ' hello \ n egon \ T 123 ')) #[', ' \ n ', ' ', ', ' \ t ', ']#\n and \tprint (Re.findall (R ') \ n ', ' Hello Egon \n123 '))
1. The upper function cannot directly use the variables of its nested function;def func1 (x, y): = x + y def Func2 (): = 3 + = mreturn Zprint (Func1 (1, 2))# error: Name ' m ' is not defined2. Variables in the upper function can be used directly within their nested functions:def func1 (x, y): = x + y def Func2 (): = 3 + z return m return func2 ()print(func1 (1, 2))# output: 63. In nested functions,
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.