mysqljoingroup-bymysql-error-1064
MYSQL multiple grouping error
please help me to over come from this. why this happen? what is the exact reason? In my first image i am grouping the sql column by using part_no and its working well. but in the second image I tried to group using multiple columns, but its giving me an erro as the image. I tried this after change my db values means adding same part no to the both rows and same gp_code to the same row.but its not working.
please help me ASAP. thank you.
Solution
Remove the braces () from group by clause. That's the problem.
- Error: select command denied to user '<userid>'@'<ip-address>' for table '<table-name>'
- winMySQL query fails on Ubuntu instance but works with Windows instance
- How to connect from VSCode to a mysql docker container?
- SQL syntax error when trying to create a new table using TypeORM
- How do I convert text entered in form to Title Case Using PHP before submitting to MySQL?
- How to declare a variable in MySQL?
- MySQL Paging and Return Total
- How to drop columns in a table, where column names are "index" and " Unnamed: 0" in mysql
- How to deal with enormous line lengths created by mysqldump
- MySQL union - alias not visible
- Join newest price from price-table for all products
- Mysql ERROR: ASCII '\0' while importing sql file on linux server
- User registration with CodeIgniter
- Paging Results: Handling invalid passed data
- I'm stuck with foreign key constraint fails error. .NET 8, EF Core 8.0.2
- find number of rows in returned mysql result (nodejs)
- Get records that have total count of over X amount
- Excluding records between dates AND with an associating value
- Turn cell values into columns in MySQL
- MYSQL Update query, replace part string containing URL
- MySQL Not Equal To Certain Length
- How can I solve "Error: MySQL shutdown unexpectedly"?
- What are the issues when not using @Column(columnDefinition = "TEXT")?
- How do I turn off the mysql password validation?
- How to create table like another table with additional columns in MYSQL
- How import also column name in CSV file
- Export Column Names to CSV
- split characters and numbers in MySQL
- If only CI fails, what kind of trouble could there be for django?
- Perform an INNER JOIN with more than 2 tables in MySQL