Any mysql expert can tell me how to solve these error?

|
Paynalton 2021-03-10 04:45:18
and with: select
customer_id,estacion_id ,max(peso)
from vw_customer_peso
group by customer_id,estacion_id
Paynalton 2021-03-10 04:46:19
the output is not that i want
Paynalton 2021-03-10 05:57:57
dole un whats
Paynalton 2021-03-10 05:58:25
doles
Ashwin_Bruno 2021-03-10 08:19:44
Paynalton 2021-03-10 04:44:05
SQL Error [1055] [42000]: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘prueba.vw_customer_peso.estacion_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SET SESSION sql_mode = ”;

Ashwin_Bruno 2021-03-10 08:20:08
Paynalton 2021-03-10 04:43:42
if i try: select
customer_id,estacion_id ,max(peso)
from vw_customer_peso
group by customer_id

Then try this query..it will work

MasterZiv 2021-03-10 09:34:27
Paynalton 2021-03-10 04:36:30
How can i query the row with the max value in column “peso”

Select the maximum value with a subquery.
Use the subquery in WHERE section as a value for the field.

darshitjiyani 2021-03-10 13:55:34
mysql_en-8530.jpg
hey guys, any mysql expert can tell me how to solve these error?😃
MasterZiv 2021-03-10 14:06:19
darshitjiyani 2021-03-10 13:55:34
hey guys, any mysql expert can tell me how to solve these error?😃

Just use (another) user and password which are valid.

darshitjiyani 2021-03-10 14:07:36
i tried with change password
darshitjiyani 2021-03-10 14:07:49
and restart
darshitjiyani 2021-03-10 14:07:53
not working
MasterZiv 2021-03-10 14:13:13
darshitjiyani 2021-03-10 14:07:36
i tried with change password

create another user and give it permissions to log in and do approp. actions, then use it to log in.

darshitjiyani 2021-03-10 14:21:33
okay
Kev In 2021-03-12 13:04:55
Hey guys.. how do you upload a scanned document to my database?
MasterZiv 2021-03-12 14:04:30
Kev In 2021-03-12 13:04:55
Hey guys.. how do you upload a scanned document to my database?

you need to write some program to do this.

Kev In 2021-03-12 14:29:20
Thanks .. let me do some research and find the best way forward..
MasterZiv 2021-03-12 21:38:15
Kev In 2021-03-12 14:29:20
Thanks .. let me do some research and find the best way forward..

We don’t restrict you in this activity

mocpixz 2021-03-13 15:54:11
hi all
2021-03-13 16:25:02
hi all
davidraja james 2021-03-15 07:58:04
Sorry inconvenience… I’m looking for MySQL related jobs…. I’m fresher so i don’t know how to find job… if any one know MySQL related job interview then please let me know as… Thanks….
2021-03-15 15:41:31
I would recommend you practice SQL in leetcode.com. There are around 180 problems from easy to difficult level. You can also compare your performance with other users and learn a lot from them.
2021-03-15 19:07:32
how to recover a deleted mysql. ibd file if u Dont have any backup? any link?
2021-03-15 22:14:30
https://twindb.com/recovery-after-drop-table-with-innodb_file_per_table-off/
MasterZiv 2021-03-15 22:17:49
2021-03-15 19:07:32
how to recover a deleted mysql. ibd file if u Dont have any backup? any link?

No way…

2021-03-15 22:18:17
How about the link I share …
2021-03-15 22:19:04
This question was asked from me today in an interview .. I didn’t knew the answer that’s why I posted it..
2021-03-15 22:20:00
another link with file per table on https://twindb.com/recovery-after-drop-table-with-innodb_file_per_table-on/
Baron 2021-03-16 07:17:25
hello guys, i have task update schema mysql replication version 5.5.59 on product running with database 150G. Is there a quick and secure way to keep all the data in the upgrade process? please help me
piterden 2021-03-16 07:30:22
Baron 2021-03-16 07:17:25
hello guys, i have task update schema mysql replication version 5.5.59 on product running with database 150G. Is there a quick and secure way to keep all the data in the upgrade process? please help me

How long downtime is acceptable for your case?

Baron 2021-03-16 07:30:50
about 3 hours
Kev In 2021-03-16 12:35:04
Hey guys .. the above is an ER diagram for an employee db am working on .. the owner of the company feels like there is a lot of duplication in the tables with deptemployees , departments, deptmanagers, titlestable, and contract .. any advice will be highly appreciated
Kev In 2021-03-16 14:24:35
I was actually thinking of adding employee Level and maybe try fix the titles to one of the tables there
piterden 2021-03-16 15:50:27
Kev In 2021-03-16 12:35:04
Hey guys .. the above is an ER diagram for an employee db am working on .. the owner of the company feels like there is a lot of duplication in the tables with deptemployees , departments, deptmanagers, titlestable, and contract .. any advice will be highly appreciated

What do you mean “employee db”? What business you are serving?

piterden 2021-03-16 15:51:58
Employee DB of chicken farm will be different from the same DB of webagency
|