Hey all, anyone know how I can disable openssl AND galera function at cmake configure option?

|
hack1313a 2022-03-05 06:54:13
mysql_en-18368.jpg

hack1313a 2022-03-05 06:54:13
mysql_en-18367.jpg

hack1313a 2022-03-05 06:54:19
My problem
hack1313a 2022-03-05 06:55:53
mysql_en-18370.jpg

Akshay Kumar 2022-03-05 09:02:06
mysql_en-18374.jpg
Does anyone have idea about it. Can you please tell me what is the issue. It’s urgent
hack1313a 2022-03-05 14:19:24
Bro kya karna hai
hack1313a 2022-03-05 14:20:36
mysql_en-18378.jpg

hack1313a 2022-03-05 14:21:03
Not login port 8080

Please solve…

Yohajdg627299 2022-03-06 00:27:00
Hey all,anyone know how I can disable openssl AND galera function at cmake configure option?

-DWITHOUT_SSL=1 or
-DWITHOUT_OPENSSL=1

NOT working.

Im running mysql in local network ,so no internet connection needed with openssl nor galera functionality.

Maybe wsrep disable galera function?

ChehinJ 2022-03-06 01:03:09
mysql_en-18388.jpg
Hello, does anyone know if it is bad practice to have tables with different engines?
piterden 2022-03-06 05:45:50
ChehinJ 2022-03-06 01:03:09
Hello, does anyone know if it is bad practice to have tables with different engines?

Use InnoDB

Siddharth 2022-03-06 08:45:35
mysql_en-18397.jpg
Need Help
Siddharth 2022-03-06 09:04:48
It seems like You Don’t know Answer….
piterden 2022-03-06 09:11:27
Sorry, I don’t help students to solve control works.
coaper 2022-03-06 14:44:38
hi, why is this query not working?
gives a syntax error
UPDATE worker SET salary =500 WHERE id=400 ; SELECT * FROM worker WHERE id=400
xmpipp 2022-03-06 15:27:46
coaper 2022-03-06 14:44:38
hi, why is this query not working?
gives a syntax error
UPDATE worker SET salary =500 WHERE id=400 ; SELECT * FROM worker WHERE id=400

You can’t set two query in one sending
Like UPDATE AND SELECT

xmpipp 2022-03-06 15:36:30
coaper 2022-03-06 14:44:38
hi, why is this query not working?
gives a syntax error
UPDATE worker SET salary =500 WHERE id=400 ; SELECT * FROM worker WHERE id=400

queryOne = UPDATE worker SET salary = 500 WHERE id=400;
—————————————————-
queryTwo = SELECT * FROM worker WHERE id=400;

coaper 2022-03-06 15:37:02
xmpipp 2022-03-06 15:36:30
queryOne = UPDATE worker SET salary = 500 WHERE id=400;
—————————————————-
queryTwo = SELECT * FROM worker WHERE id=400;

need one queery

xmpipp 2022-03-06 15:39:31
coaper 2022-03-06 15:37:02
need one queery

https://stackoverflow.com/questions/4057244/update-and-select-in-one-query
Read this answers 🧑🏻‍🦯

Update and select in one queryStack Overflow
I found similar questions with correct answers. But they’re a bit complicated for me. I just want a simple basic statement.

I have:

string sql = “UPDATE tblPopUp
SET PopUp = ‘F…

coaper 2022-03-06 15:44:19
I’ve already watched this, thanks
VEX0102 2022-03-06 16:10:22
good day
VEX0102 2022-03-06 16:10:45
how i can generate alphanumeric id in mysql?
2022-03-06 22:41:33
SELECT CASE
WHEN c.cityname IS NULL
THEN ‘NULL’
ELSE c.cityname
END
,count(*)
FROM student s
LEFT JOIN city c ON s.city_id = c.id
GROUP BY c.cityname
ORDER BY (
CASE
WHEN c.cityname IS NULL
THEN 0
ELSE 1
END
) DESC;
2022-03-06 22:41:41
Can anyone explain this query
piterden 2022-03-07 07:00:48
2022-03-06 22:41:33
SELECT CASE
WHEN c.cityname IS NULL
THEN ‘NULL’
ELSE c.cityname
END
,count(*)
FROM student s
LEFT JOIN city c ON s.city_id = c.id
GROUP BY c.cityname
ORDER BY (
CASE
WHEN c.cityname IS NULL
THEN 0
ELSE 1
END
) DESC;

It counts students by city

cris_highlight_bot 2022-03-07 07:14:09
piterden 2022-03-07 07:14:09
CASE
WHEN c.cityname IS NULL
THEN ‘NULL’
ELSE c.cityname
END

https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html#function_ifnull

mysql_en-18452.jpg

piterden 2022-03-07 07:14:09
2022-03-06 22:41:33
SELECT CASE
WHEN c.cityname IS NULL
THEN ‘NULL’
ELSE c.cityname
END
,count(*)
FROM student s
LEFT JOIN city c ON s.city_id = c.id
GROUP BY c.cityname
ORDER BY (
CASE
WHEN c.cityname IS NULL
THEN 0
ELSE 1
END
) DESC;

CASE
WHEN c.cityname IS NULL
THEN ‘NULL’
ELSE c.cityname
END

https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html#function_ifnull

Mhdchan 2022-03-07 07:34:00
Guys guys do you have any group for dot.net framework

Plz let me know

Sushil 2022-03-07 09:08:24
No
Loving_soul10 2022-03-07 10:36:52
mysql_en-18457.jpg
How to solve this error
2022-03-07 13:59:45
coaper 2022-03-06 14:44:38
hi, why is this query not working?
gives a syntax error
UPDATE worker SET salary =500 WHERE id=400 ; SELECT * FROM worker WHERE id=400

SELECT * FROM worker
UPDATE worker
SET salary =500 WHERE id=400 ;

coaper 2022-03-07 14:05:55
2022-03-07 13:59:45
SELECT * FROM worker
UPDATE worker
SET salary =500 WHERE id=400 ;

Thank you very much!

coaper 2022-03-07 14:23:48
checked again, not working (

Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near…

Var 2022-03-07 17:02:32
Hi Guys, i want select one of signle column with out adding GROUP BY & AGRREGRATE FUNCTION but some other columns i want apply GROUP BY & AGRREGRATE FUNCTION applay. how to achive this please? Thanks in advance .
Var 2022-03-07 19:14:08
Var 2022-03-07 17:02:32
Hi Guys, i want select one of signle column with out adding GROUP BY & AGRREGRATE FUNCTION but some other columns i want apply GROUP BY & AGRREGRATE FUNCTION applay. how to achive this please? Thanks in advance .

any help please

|