Check if you are getting any output while describing the table?

DESC prueba.customer_answers;

Check if you are getting any output while describing the table ?

If your table is present on that db then it should not give error..I guess you are missing something..check properly

yes, same error

That means your table doesn’t exist bro.. check the table name properly

mmm, i think the migration process run the tcreate trigger before create it, then stops

thanks for your help jejjee

Yes that’s the reason may be

yea!! works!!!!!

Great

Is there any other option to backup all databases other than dump?

There are two solutions now,
MySQL dump
MySQL backup

There’s also xtra backup by percona

is there something like pg_basebackup of postgres?

Asking like this, you are kinda obliged to tell people what this pg_xxxx is…

it makes a binary copy of the database cluster files,

Did you check under the requirement section if anything is missing

Make sure that you installed latest version of visual c++ redistributable package

You can refer this

How to install MySQL database server 8.0.19 on Windows 10

Hello .. i am a beginner.. i have been able to create an employee database with all the relations .. they ER diagrams shows that the relations have been used correctly.. but i would like to know some codes that i can use to access information from across all tables .. E.g if i need access to data on a specific staff .. i want to enter the staff number and access all infor regarding this staff ..

Here is my ER diagram..

you need to create an SQL query with JOINs

It has worked perfectly.. thank you Sir!

I tried this but not getting required ans

http://sqlfiddle.com/#!9/af1a24e/8

What’s your exact requirement can you explain in short.. sorry didn’t understand the question properly

Try this if this is what you are expecting

Select customerid,
Case when dt between “2021-01-31” and date_add(“2021-01-31”, interval 28 day) then “1” else “0” end flag
from retention

Hi guys and girls. I have this table:

How can i query the row with the max value in column “peso”

i need both data, customer_id and estacion_id

can you helpme?

if i try: select
customer_id,estacion_id ,max(peso)
from vw_customer_peso
group by customer_id

i have this error:

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