Which one is good in market oracle sql or MySQL?

|
MasterZiv 2021-12-06 07:56:35
Yes read in the docs . the idea is that you restart the server with special parameter and it changes pass word to new one
SK R 2021-12-09 17:22:50
Which one is good in market oracle sql or MySQL???
MasterZiv 2021-12-09 17:35:08
SK R 2021-12-09 17:22:50
Which one is good in market oracle sql or MySQL???

For a market, Oracle DBMS would be too expensive and complex solution, use MySQL, it is free

piterden 2021-12-09 20:14:05
You should define column names correct
piterden 2021-12-11 12:46:49
nometa.xyz
smlkw 2021-12-11 12:56:32
piterden 2021-12-11 12:46:49
nometa.xyz

It’s in Russian

smlkw 2021-12-11 12:56:48
https://www.nohello.com/ is better

No HelloNohello
Don’t Just Say “Hello” in Chat.
piterden 2021-12-11 12:56:55
https://nohello.net/

no hellonohello.net
please don’t say just hello in chat
piterden 2021-12-11 12:57:07
smlkw 2021-12-11 12:56:32
It’s in Russian

Soryan

piterden 2021-12-11 14:37:32
Columns of what?
piterden 2021-12-11 14:39:58
Okay. So columns of what in MySQL do you want to have? Table columns, view columns, selection columns?
piterden 2021-12-11 14:41:17
Okay. You shouldn’t store duplicates of your data in your tables.
piterden 2021-12-11 14:43:24
If you have col1 and col2 you can easily and at any time calculate the value you need from them
piterden 2021-12-11 14:43:44
You shouldn’t store it
piterden 2021-12-11 14:46:05
Database is about to store your data. The presentation layer places not here
piterden 2021-12-11 14:47:51
If you would explain what you want to achieve, maybe me or someone else could help you with better suggestion
piterden 2021-12-11 14:50:07
If I have table

CREATE TABLE test (
a int,
b int
);

I can do next at any time:

SELECT a, b, a * b AS c FROM test;

piterden 2021-12-11 14:55:33
If your business requires to keep some intermediate data already calculated, it is acceptable. But I doubt very much that it is like that
Liran 2021-12-12 10:26:54
I have mySQL running as cloud SQL, i’ve enabled audit logs for cloud sql in the IAM but when I try to trace connection logs all I see is connections coming from the gcp cloud shell, if I try to connect from mysql workbench/datagrip I don’t see logs. can any one help please?
2021-12-12 13:12:59
Hello everyone who is well versed in mysql, help with the script. I’ll pay.
MasterZiv 2021-12-12 14:35:18
It is code send by means of picture.
A big problem!
MasterZiv 2021-12-12 14:36:03
2021-12-12 13:12:59
Hello everyone who is well versed in mysql, help with the script. I’ll pay.

$100/hour my rate

MasterZiv 2021-12-12 14:37:02
This is Java code why sending here?
MasterZiv 2021-12-12 14:37:42
Eden , you’re message is offtopic, will be deleted
Eden 2021-12-12 14:37:43
The problem is with the sql query
That’s why
MasterZiv 2021-12-12 14:38:09
Eden 2021-12-12 14:37:43
The problem is with the sql query
That’s why

Send then the query, errors and the question

Eden 2021-12-12 14:39:19
That’s what I did actually
MasterZiv 2021-12-12 14:39:28
Eden 2021-12-12 14:37:43
The problem is with the sql query
That’s why

All as text

Liran 2021-12-12 17:37:23
I try to connect to mySQL with user/pass using environemnt variable like this – >“` MYSQL_PWD=”$MYSQL_PASSWORD” mysql –host=“` but when I run this the password is displayed on the screen/output
MasterZiv 2021-12-12 17:58:32
Liran 2021-12-12 17:37:23
I try to connect to mySQL with user/pass using environemnt variable like this – >“` MYSQL_PWD=”$MYSQL_PASSWORD” mysql –host=“` but when I run this the password is displayed on the screen/output

And what is the question?

This is expected behavior.

Liran 2021-12-12 17:59:27
How can I hide the password from the output? I want it to be safe so nobody can know the password.
Liran 2021-12-12 17:59:47
Unless they can check the environment variable
MasterZiv 2021-12-12 18:05:57
Liran 2021-12-12 17:59:27
How can I hide the password from the output? I want it to be safe so nobody can know the password.

Specify option -p to the mysql command but you will have to type the password in manually

Liran 2021-12-12 18:07:16
And if I need to run this command line as a Cron or from Jenkins? Is there any other option then manually type it
MasterZiv 2021-12-12 18:50:30
Liran 2021-12-12 18:07:16
And if I need to run this command line as a Cron or from Jenkins? Is there any other option then manually type it

There was something like password file for mySQL, check the docs

|