MySQL non-trivial statements

1 Specifying data rows in front

。。。 GROUP by    Nutr_scheme.idorder bynutr_scheme.id not in (SELECT scheme_id from nutr_user_default_scheme where user_id = 1 0036 and is_delete = 0),    drink_count DESC,    nutr_scheme.id ASC

More than 2 rows of query results merge one row (for one-to-many)

SELECT    Group_concat (name) as All_name,    ' NAME ' from    base_basedatagroup by    PID

3 distinct used to remove count duplicate values

COUNT (DISTINCT ID) as ' count '

4 query data within two minutes

Create_time >= Unix_timestamp (now ()-interval-second)

5 time stamp (10 bit) turn time

From_unixtime (Time_stamp, '%y-%m-%d%h:%i:%s ')

　　

MySQL non-trivial statements