SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'zyd_first.info.id' which is not functionally dependent on columns
A SQL statement takes the general form: SELECT field_1 FROM table_1 WHERE criterion_1 ; Notes: Access ignores line breaks in a SQL statement. However, consider using a line for each clause to help improve the readability of your SQL statements for yourself and others. ...
ALTER TABLE PARTITION modifies table partitioning, including adding, deleting, splitting, merging partitions, and modifying partition attributes.The name of the added par
Avoid SQL statements that cannot be pushed down (indicated by REMOTE_XXX_QUERY in the EXPLAIN output). Refrain from frequent COUNT queries on large row-store tables (over 10 million rows). Limit the number of UNION/UNION ALL branches in a single SQL statement to 50, and associate no more...
参考:https://stackoverflow.com/questions/37951742/1055-expression-of-select-list-is-not-in-group-by-clause-and-contains-nonaggr 这个语句没试过,先记录:(标识:能用->重启服务器之后,失败) set@@sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CRE...
Instead, it “resets” the ordering for subsequent shift rules to cause them to be taken in relation to a given character. Either of the following rules resets subsequent shift rules to be taken in relation to the letter 'A': <reset>A</reset> <reset>\u0041</reset> The , , and <...
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP,SQLSTATE[42000]:Syntaxerrororaccessviolation:1055Expression#1ofSELECTlistisnotinGROUP
SET DEFAULTis not supported. (Also not supported byInnoDB.) TheNO ACTIONkeywords are accepted but treated asRESTRICT. (Also the same as withInnoDB.) In earlier versions of NDB Cluster, when creating a table with foreign key referencing an index in another table, it sometimes appeared possible...
Another T-SQL enhancement in Yukon allows you to return output from Data Manipulation Language (DML) statements other than SELECT (INSERT, UPDATE, DELETE). A new OUTPUT clause allows you to request that the old/new images of the columns be returned by referring to the INSERTED and DELETED ta...
SQLSTATE[42000]:Syntax error or access violation:1055'd0170cbc.card_value.date'isn'tin GROUP BY (SQL:select`date`,AVG(value)asvaluefrom`card_value`where`card_value`.`cardid`in(7987)groupbyWEEK(FROM_UNIXTIME(date))orderby`date`asc)SQLSTATE[42000]:Syntax error or access violation:1055'd0...