How can I insert data into the condition table?

|
Sandip Londhe 2022-06-30 13:09:01
i sent the live ss from my local machine
suricruise1 2022-06-30 13:09:45
In group by clause two columns name mention it showing wrong answer
Sandip Londhe 2022-06-30 13:11:59
mysql_en-22289.jpg
according to this , above query also throw an error for not using group by clause;
Swapnil 2022-06-30 13:12:06
May be then MySQL works differently as compared to other DBs
Sandip Londhe 2022-06-30 13:13:01
may be but , on onecomplier also it throws an error
Swapnil 2022-06-30 13:13:31
https://stackoverflow.com/questions/21679804/why-mysqls-group-by-and-oracles-group-by-behaviours-are-different

Why Mysql’s Group By and Oracle’s Group by behaviours are differentStack Overflow
Why Mysql’s Group By and Oracle’s Group by behaviours are different

I found many times that Mysql’s groupBy functionality and Oracle’s GroupBy funcnality are behaving different

Many times I found

Swapnil 2022-06-30 13:13:44
MySQL has developed group by differently hence
Swapnil 2022-06-30 13:13:51
But this is not as per SQL ANSI Standard
Sandip Londhe 2022-06-30 13:14:05
yes
Sandip Londhe 2022-06-30 13:14:35
Swapnil are you working anywhere?
nosyeaj 2022-06-30 14:06:06
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)

nosyeaj 2022-06-30 14:07:32
everythings fine on localhost, but i wanted to connect remotely. mysql v8
lZ0Rm 2022-06-30 16:03:56
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.

Sandip Londhe 2022-06-30 16:14:13
lZ0Rm 2022-06-30 16:03:56
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

N N 2022-06-30 19:15:43
Hiii
N N 2022-06-30 19:16:15
How to create sample store procedures in my sql
N N 2022-06-30 19:16:20
Please help me
N N 2022-06-30 19:17:10
Hlooo
N N 2022-06-30 19:17:22
Any one help me
Gunnyvenkat 2022-07-01 10:20:39
Swapnil 2022-06-28 13:05:52
https://dba.stackexchange.com/questions/174103/mysql-update-tables-in-batches

Thanks you soo much swapnil

G JithenderReddy 2022-07-01 13:03:09
How do i reject the dots in a column level through the query
Swapnil 2022-07-01 13:48:20
G JithenderReddy 2022-07-01 13:03:09
How do i reject the dots in a column level through the query

Does that column data has dot ?

G JithenderReddy 2022-07-01 13:52:12
If example ram.Suresh in this anywhere if . There it should be rejected
G JithenderReddy 2022-07-01 13:55:19
If we enter the(. ) dot in a column rows it should be reject in column level
G JithenderReddy 2022-07-01 13:55:26
How to do?
G JithenderReddy 2022-07-01 13:55:38
Through qurery
suricruise1 2022-07-01 14:58:03
Any body tell website for learning Store procedure with examples and solutions
suricruise1 2022-07-01 14:59:21
MySQL exception handling small examples
suricruise1 2022-07-01 15:13:31
suricruise1 2022-07-01 14:58:03
Any body tell website for learning Store procedure with examples and solutions

#swapnil#

Swapnil 2022-07-01 16:44:28
G JithenderReddy 2022-07-01 13:52:12
If example ram.Suresh in this anywhere if . There it should be rejected

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

Swapnil 2022-07-01 16:44:52
suricruise1 2022-07-01 15:13:31
#swapnil#

Probably MySQL official documentation should be good

suricruise1 2022-07-01 16:46:26
Swapnil 2022-07-01 16:44:52
Probably MySQL official documentation should be good

Okay bro

G JithenderReddy 2022-07-01 16:54:54
Swapnil 2022-07-01 16:44:28
select trim(replace(columnname, ‘.’, ”))

I will check

G JithenderReddy 2022-07-01 16:54:57
Thank you
emmanuelishadaeM 2022-07-01 19:19:01
Anybody with the MySQL workbench 32bit ??
|