--"Composition of SQL statements"--DML data manipulation language (inserting, modifying, and deleting data in a database) insert UPDATE Delete--DQL Data Query Language (used to query data in the database) SELECT--DCL Data Control language (used to
Description: This article summarizes from: "MySQL 5.5 Start from scratch" chapter sixthThe functions in MySQL include:Mathematical functions, String functions, date and time functions, conditional judgment functions, System information functions and
Chapter III MySQL advanced query (i) I. Four classifications for SQL language
1. DML(data manipulation Language): Used to insert, modify, and delete data in a table, such as insert,update,delect
.
2. DDL(data definitionLanguage):
First, mathematical functionsMathematical functions are mainly used for processing numbers, including integers, floating-point numbers, and so on.ABS (x)Returns the absolute value of XSELECT ABS (-1)--return 1Ceil (x), CEILING (x)Returns the
One: Mathematical functionsSELECT Greatest (2,3,4), Greatest (1.1,3.2);SELECT LEAST (2,3,4), LEAST (1.1,3.2);Floor (X)Returns the maximum integer value that is not greater than X.Mysql> SELECT Floor (1.23);1Mysql> SELECT Floor (-1.23);-2LOG10
One. String functionsSelect concat (Name, "Age was", age) from users; Insert (Str,x,y,insert)//Replace y position of string x position with insert Select Lower (str) upper (str)//conversion caseSELECT * from user where upper (name) = ' AAA ';
All Weibo users have uploaded images. After uploading images, users can drag images and adjust the order of images. How can this function be implemented, the following small series will explain how to sort the image of imitation Weibo Based on
Data_null _; all content in this blog is original. If you reprint it, please indicate the source blog. csdn. netmyhaspl
Data _ null _; all the content of this blog is original, if reproduced please indicate the source http://blog.csdn.net/myhaspl/
Overview mysql provides many built-in functions. Common functions include: string functions, date functions, numeric functions. I generally recommend that you use backend languages (php, java, c #, etc) similar functions are used in the background
SQL single-row functions in Oracle databases-numeric Functions1. trigonometric FunctionsSIN ASIN SINHCOS ACOS COSHTAN ATAN TANHFor the above trigonometric functions, see the name. Do a continuous exercise [SQL] select sin (2), asin (1), SINH (1)
Js object-oriented is an important part of js. It is helpful for saving code, encapsulating it for ease of use, and performance. I hope you will learn it carefully. JavaScript uses "Object-Oriented Programming" or "Object-Oriented Programming. The
Mathematical functions in Javascript are classified into the following mathematical methods:
Constans (constant), power functions (multiplication function), trigonometic functions (trigonometric function), rounding functions (rounding function),
MATLAB Learning Notes (a) unit array1.floor (x): Take the smallest integer floor (3.18) =3,floor (3.98) =3Ceil (x): Take the largest integer ceil (3.18) =4,ceil (3.18) =42. The element array and the structure are similar in function,The same point:
The Helper House (www.bkjia.com) is too busy to write articles for a long time. There is no time to write complicated things, and you can write the color gradient effect again. The color effect is generally two, the color gradient change and the
I. mathematical functionsABS (x) returns the absolute value of x.BIN (x) returns the binary value of x (OCT returns octal, HEX returns hexadecimal)CEILING (x) returns the smallest integer greater than x.EXP (x) returns the x power of e (the base of
1.Date: Date functionProperties (1):constructor function Reference of the object being repairedPrototype properties and methods that can be added to an objectMethod (43):GetDay () returns the day ordinal of a week (0-6)GetYear () returns the year.
Mysql-related things (9) commonly used function links: Mysql-related things (1) mysql Installation http://www.bkjia.com/database/201210/162314.html Mysql (2) Database Operations http://www.bkjia.com/database/201210/162315.html Mysql (3) operations
The string function CONCAT (str1, str2,...) returns the string generated by the connection parameter. If any parameter is NULL, the return value is NULL.[SQL]View plaincopyMysql> select concat ('My, s', 'ql ');-> 'mysql'Mysql> select concat ('My,
The complete path and FILE name of the common PHP system constant _ FILE. If it is used in a file to be included, the file name to be included is returned. Since PHP4.0.2, it always contains an absolute path (if it is a symbolic connection, it is
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.