Label:There is a connection operation between the SQL statements, which must be used in some complex data operations. Simply put, the result of an SQL statement can be part of a connected SQL operation. SQL Structured query statements, subqueries refer to all SQL operations, not a single SELECT statement. 1. Generated by comparison operators: SELECT user_name,user_idfromWHERE>=(SELECTROUND( AVG (age),0 from users); You can use Any,some,all to make queries. SELECT user_name,user_idfromWHERE>= any
Also used for recording for future contact! It basically contains the advanced usage of general SQL!drop table if exists stu;create table stu (name varchar (), age int,stuid int not null PRIMARY key Auto_increment,idnum int , sex varchar (+), check (Sex in (' Male ', ' female ')) Charset=utf8;insert into Stu (name,age,idnum,sex) VALUES (' Damon ', 789,4678945 , ' Male '), insert into Stu (Name,age,idnum,sex) VALUES (' Coco ', 13,345, ' female '), insert into Stu (Name,age,idnum,sex) VALUES (' Ki
case-L,--limit,-N Limit limit output (or counting) to limit entries-m,--mmap Ignored, for backward compatibility-p,--nofollow,-H don ' t follow trailing symbolic links when checking file Exis tence-0,--null separate entries with NUL on output-s,--statistics don ' t search for entries, print Statistics about eachused database-q,--quiet quiet mode, will not display any error messages-R,--regexp regexp use basic regular Expressions--regex Use
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.