How can I insert data into the condition table?

i sent the live ss from my local machine

In group by clause two columns name mention it showing wrong answer

according to this , above query also throw an error for not using group by clause;

May be then MySQL works differently as compared to other DBs

may be but , on onecomplier also it throws an error

https://stackoverflow.com/questions/21679804/why-mysqls-group-by-and-oracles-group-by-behaviours-are-different

MySQL has developed group by differently hence

But this is not as per SQL ANSI Standard

yes

Swapnil are you working anywhere?

Hi!, i’ve added bind-address=0.0.0.0 but still cant connect remotely.
– mysql’s service is up and running.
– restarted the service.
– created a user@% with grants.
– flush priv
what did i miss?

$ mysql -uadmin -h123.123.123.123 -p
> ERROR 2002 (HY000): Can’t connect to server on ‘123.123.123.123’ (115)

everythings fine on localhost, but i wanted to connect remotely. mysql v8

Hello, how can I insert data into the condition table?

Add column sum1 to zarpl table and find data in it
rule: if the field value is tnom>240 to sum1=1750, otherwise
sum1=1500.

Try using triggers

Hiii

How to create sample store procedures in my sql

Please help me

Hlooo

Any one help me

Thanks you soo much swapnil

How do i reject the dots in a column level through the query

Does that column data has dot ?

If example ram.Suresh in this anywhere if . There it should be rejected

If we enter the(. ) dot in a column rows it should be reject in column level

How to do?

Through qurery

Any body tell website for learning Store procedure with examples and solutions

MySQL exception handling small examples

#swapnil#

select trim(replace(columnname, ‘.’, ”))

Probably MySQL official documentation should be good

Okay bro

I will check

Thank you

Anybody with the MySQL workbench 32bit ??