Please tell me what software can be used to view the database by employees?

|
KK Z 2021-11-12 17:46:17
Hi I have to install MySQL two nodes cluster in RHEL 7 for production with physical server. Data will keep in DELL EMC storage.
KK Z 2021-11-12 17:46:30
What is the best solution for that?
KK Z 2021-11-12 19:54:43
Yes
juanmi72 2021-11-12 22:15:22
this group is in spanish language?
juanmi72 2021-11-12 22:17:14
if you know of any group in Spanish version of MsQL in Spanish
zhaprozhak 2021-11-13 13:08:59
Hello. Please tell me what software can be used to view the database by employees? Now we use ODBC + Excel. Are there any analogues?
MasterZiv 2021-11-13 13:50:21
zhaprozhak 2021-11-13 13:08:59
Hello. Please tell me what software can be used to view the database by employees? Now we use ODBC + Excel. Are there any analogues?

Use DBeaver

MasterZiv 2021-11-13 19:32:04
mysql_en-14009.jpg
For this error
MasterZiv 2021-11-13 19:32:04
I have some error in my SQL code
Any body Can you help me?
rodrigo_tc7 2021-11-13 21:32:03
Create table
Marinasb28 2021-11-14 15:02:15
Hi! I have a question I don’t know if this codes are equivalent
Marinasb28 2021-11-14 15:02:35
mysql_en-14021.jpg
and: select id_recipe,count(*) as quant
from contents
where quant < 3
group by id_recipe;
BrioStoCazz 2021-11-14 15:06:05
I don’t think u can do this, because the “where” part is executed before the Select, so it doesn’t know what is “quant”
Marinasb28 2021-11-14 15:11:08
and how about if I put: select id_recipe,count(*) as quant
from contents
where count(*) < 3
group by id_recipe;
BrioStoCazz 2021-11-14 15:12:38
Marinasb28 2021-11-14 15:11:08
and how about if I put: select id_recipe,count(*) as quant
from contents
where count(*) < 3
group by id_recipe;

The where condition is executed before group By, if I’m not wrong

BrioStoCazz 2021-11-14 15:12:57
So it will count the total row from “contents” if it is < 3
And only after group by
Marinasb28 2021-11-14 15:13:01
right!
BrioStoCazz 2021-11-14 15:13:39
Marinasb28 2021-11-14 15:13:01
right!

You should check what I’m saying, I’m sure enough but not 100%

Marinasb28 2021-11-14 15:13:50
Gracias!
rodrigo_tc7 2021-11-14 17:17:53
I would try that in having instead of where clause
madno 2021-11-15 10:50:00
svart 2021-11-11 00:52:34
questions: 1) could you please show the update statement? 2) are you able to reproduce the issue without the “update” statement, i.e. with only insert statement? 3) how much rows in the partition where inserted record located?

Have you checked?

Maoltech 2021-11-16 08:45:53
I am having problem with error 150
Maoltech 2021-11-16 08:46:04
Setting up foreign key
MasterZiv 2021-11-16 08:52:26
Maoltech 2021-11-16 08:45:53
I am having problem with error 150

Details needed…

ChildProcessError 2021-11-16 12:29:08
making a column unique help query to run faster?
MasterZiv 2021-11-16 12:30:45
Send TEXT , not pictures.
madno 2021-11-16 12:32:13
Anybody has any guide for gdb to learn more about the MySQL locks
MasterZiv 2021-11-16 12:32:41
Maoltech 2021-11-16 08:45:53
I am having problem with error 150

Send DDL of all related tables, and the query, and the diagnostics. All as text.
Then ask your question

MasterZiv 2021-11-16 12:32:53
madno 2021-11-16 12:32:13
Anybody has any guide for gdb to learn more about the MySQL locks

for what ?

madno 2021-11-16 12:33:32
MasterZiv 2021-11-16 12:32:53
for what ?

For MySQL locks debugging

MasterZiv 2021-11-16 12:33:40
ChildProcessError 2021-11-16 12:29:08
making a column unique help query to run faster?

Is it a general question ?

In general, this depends on the query and the table.

mashaibumamlaka1 2021-11-16 16:41:38
mysql_en-14078.jpg
What’s the output?
MasterZiv 2021-11-16 16:42:57
mashaibumamlaka1 2021-11-16 16:41:38
What’s the output?

there is no output, UPDATEs don’t output anything

mashaibumamlaka1 2021-11-16 16:43:27
Please explain why so?
MasterZiv 2021-11-16 16:44:11
mashaibumamlaka1 2021-11-16 16:43:27
Please explain why so?

As I have said , UPDATE statement never outputs anything

|