The previous period of work because there is not much to play with MongoDB, learn its basic grammar, and now do a simple summary here.1. I am in win platform above, start words more trouble, so I simply put the boot process to do a batch fileStartup
The Sentry permission control is configured by entering the GRANT and REVOKE statements via the Beeline (Hiveserver2 SQL Command line interface). The syntax is similar to some of the mainstream relational databases today. It is important to note
UPDATE ' Warningsendmail ' as Alias_1 INNER JOIN (SELECT * from ' Warningsendmail ' WHERE flag=1 and topic_id like "%2267%") A S alias_2 SET alias_1.topic_id = REPLACE (alias_1.topic_id, ' |2267 ', ') WHERE alias_1.id = Alias_2.idupdate
Other data Operationsthe operation of the data is also known as crud:C:CreateR:ReadU:updateD:DeleteInserting Dataworm Replicationis based on the existing data, the original data is copied, inserted into the corresponding table!Syntax rules:INSERT
The SQL statements are divided into:Use test: Represents a switch to the test database when executing SQL statements1. InsertSyntax: INSERT into table name (Field 1, Field 2,.......) VALUES (Value of field 1, Value of field 2,.....)Example:
1. Slow SQL consumes 70%~90% database CPU resources;2.SQL statement is independent of the program design logic, relative to the program source code optimization, the optimization of SQL statements in the cost of time and risk is very low;3.SQL
1. Basic StructureCREATE OR REPLACE PROCEDURE Stored procedure name(Parameter 1 in number,Parameter 2 in number) isVariable 1 INTEGER: = 0;Variable 2 DATE;BEGINEND Stored Procedure Name2.SELECT into STATEMENTStoring the results of a select query in
The ㈠ command line uses sqlplus syntax to explore.
Serial number
Command line
Examples of usage
①
Sqlplus
> Sqlplus
Ii
sqlplus [option]
> sqlplus-l
③
Sqlplus [
before specific actions are added ! symbols, okay, what is this weird grammar?! Let digit = sender. Currenttitle !Here's ! said, "I'm sure the strvalue here must be non-nil, call it", for exampleIf Userisinthemiddleoftypinganumber { //== true
1, usingFinalkeyword retouchingA variable, is the reference immutable, or does the referenced object not change?When you use the final keyword to decorate a variable, it means that the reference variable cannot be changed, and the contents of the
Java language is strictly case sensitiveMultiple classes can be defined in a Java source file, but only one of the classes is defined as the public classIf the source file contains the public class, the name of the source file must be the same as
1. Key wordsConcept: Words that are given special meaning by Java.Example: Declaring a class keyword: classAccess Rights keyword: publicstatic modifier keyword: staticNo return value type keyword: void2. IdentifiersConcept: A name used to
Production environment encountered a single NIC multi-IP, we can add a virtual sub-network card to add IP, such as ifcfg-eth0:1 this format, but if we add the IP is continuous, you can use a concise method to achieveThe reference configuration file
"The basic syntax of JavaScript"1.javascript Outputa command issued by a JavaScript statement to the browser. The purpose of the statement is to tell the browser what to do. Insert, output. document.getElementById ("pid"). Innerhtml=
All code block statements must contain the same number of indentation blanksThe Terminator of a new line as a statement is generally used in Python statementsYou can use a slash (\) to divide a line of statements into multiple lines of displayPython
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.