What if the bought product twice or more times?

|
laith_leo20 2021-05-30 19:40:22
I want small help from brother to brother
laith_leo20 2021-05-30 19:42:16
At 5 june
Liran 2021-06-01 11:07:29
Why does my MySQL doesn’t create binlog files? it’s a standalone. do I need to configure something in the my.cnf file?
Deb_575 2021-06-01 15:32:17
Log_bin = ON
Add this to your my.cnf and restart
Bharath Gajula 2021-06-01 17:19:50
I have sql server management studio installed. When I try to insert a row in a table it is inserting multiple and duplicate rows. Can some 1 guide me with this
shub260319 2021-06-01 17:24:11
I want to schedule backup for all the databases in MySQL and create separate backup file for each database . I tried to create a script but it’s asking for root password .
I have no experience with Linux so any help is appreciated
MasterZiv 2021-06-01 17:25:53
Liran 2021-06-01 11:07:29
Why does my MySQL doesn’t create binlog files? it’s a standalone. do I need to configure something in the my.cnf file?

If it’s standalone you don’t need binlog files

MasterZiv 2021-06-01 17:26:33
Bharath Gajula 2021-06-01 17:19:50
I have sql server management studio installed. When I try to insert a row in a table it is inserting multiple and duplicate rows. Can some 1 guide me with this

SQL server is not the topic

MasterZiv 2021-06-01 17:28:18
shub260319 2021-06-01 17:24:11
I want to schedule backup for all the databases in MySQL and create separate backup file for each database . I tried to create a script but it’s asking for root password .
I have no experience with Linux so any help is appreciated

most probably this is root of MySQL, not the system root account.
You don’t need root to backup MySQL

Deb_575 2021-06-01 17:29:35
Bharath Gajula 2021-06-01 17:19:50
I have sql server management studio installed. When I try to insert a row in a table it is inserting multiple and duplicate rows. Can some 1 guide me with this

Share your query and output as well

MasterZiv 2021-06-01 17:36:20
Bharath Gajula 2021-06-01 17:19:50
I have sql server management studio installed. When I try to insert a row in a table it is inserting multiple and duplicate rows. Can some 1 guide me with this

What is your RDBMS?

shub260319 2021-06-01 18:14:53
MasterZiv 2021-06-01 17:28:18
most probably this is root of MySQL, not the system root account.
You don’t need root to backup MySQL

I have a user which have appropriate access for backup and everything . This user and password is mentioned in script for mysqldump. I scheduled script via cronjob

israeldieguez 2021-06-02 00:35:28
shub260319 2021-06-01 18:14:53
I have a user which have appropriate access for backup and everything . This user and password is mentioned in script for mysqldump. I scheduled script via cronjob

You should do: mysqldump -umyuser -pmypassword …

Karthick 2021-06-02 18:42:44
I have 10lak record daily insert and update in php and MySQL. Now I am getting performance issues query. It’s take more than 6hr to insert and update. How can I improve code? Data response getting from Mcloud
MasterZiv 2021-06-02 20:03:24
Hi, am running 3 node MariaDB Galera cluster, 2 nodes in cloud and 1 node in onpremise. 2 nodes are working properly and recently we built in additional node in onprem and trying to connect with Master in cloud. But it’s failed to connect and sync with master. The MariaDB service is failing repeatedly saying Innodb tables space cannot be found and Innodb storage engine error. Do anyone face this type of error and can anyone help me to fix this issue..? Please PM me
Deb_575 2021-06-02 20:29:07
MasterZiv 2021-06-02 20:03:24
Hi, am running 3 node MariaDB Galera cluster, 2 nodes in cloud and 1 node in onpremise. 2 nodes are working properly and recently we built in additional node in onprem and trying to connect with Master in cloud. But it’s failed to connect and sync with master. The MariaDB service is failing repeatedly saying Innodb tables space cannot be found and Innodb storage engine error. Do anyone face this type of error and can anyone help me to fix this issue..? Please PM me

Make sure all the versions are same for on prem and cloud.
Share the error log msg.
Also try to replicate from the on prem server to the new on prem server. Galera is by default multi master

MasterZiv 2021-06-03 00:41:33
@BV2021A !
Kumar 2021-06-03 09:38:37
Hi,
I have a task in mysql anyone interested to work on it. Please ping me personally ready to pay for the same. Indians are preferred(Sorry for others).
Thanks
Deb_575 2021-06-03 12:12:36
Kumar 2021-06-03 09:38:37
Hi,
I have a task in mysql anyone interested to work on it. Please ping me personally ready to pay for the same. Indians are preferred(Sorry for others).
Thanks

I am interested

Aj 2021-06-03 17:31:45
mysql_en-10154.jpg
Please help me with this codes
Aj 2021-06-03 17:31:46
mysql_en-10155.jpg

Aj 2021-06-03 17:31:47
mysql_en-10156.jpg

fozilov_jasur 2021-06-03 21:06:38
Aj 2021-06-03 17:31:45
Please help me with this codes

which website ?

piterden 2021-06-04 00:25:39
Aj 2021-06-03 17:31:45
Please help me with this codes

If we help you, then you will never finish your studying. It is better if you do it by yourself

svraju2020 2021-06-04 17:47:33
If we create a new user, in which database it is created
bilbss 2021-06-04 20:05:03
i got these data,

product_id | user_id
1 1
2 1
3 1
1 2
2 2
1 3
4 4
im trying to get output like this
for user_id=1
user_id | similarity
2 0.67
3 0.33
4 0
how can i do that?

piterden 2021-06-05 14:36:13
bilbss 2021-06-04 20:05:03
i got these data,

product_id | user_id
1 1
2 1
3 1
1 2
2 2
1 3
4 4
im trying to get output like this
for user_id=1
user_id | similarity
2 0.67
3 0.33
4 0
how can i do that?

What similarity means?

piterden 2021-06-05 14:59:11
bilbss 2021-06-04 20:05:03
i got these data,

product_id | user_id
1 1
2 1
3 1
1 2
2 2
1 3
4 4
im trying to get output like this
for user_id=1
user_id | similarity
2 0.67
3 0.33
4 0
how can i do that?

I got it. It’s pure math here. Just think about it and make queries you need.

israeldieguez 2021-06-05 17:37:23
I think it’s a count in percent mode.
piterden 2021-06-05 17:40:38
That task is incomplete, cause it can be a several edge cases which isn’t described in task. For exapmle what to do if product_id would repeated?
bilbss 2021-06-05 22:59:55
piterden 2021-06-05 14:36:13
What similarity means?

i am trying to make some product recomment. if users bought same products. i will recommend new product for them(which has similarity is high)

bilbss 2021-06-05 23:00:11
israeldieguez 2021-06-05 17:37:23
I think it’s a count in percent mode.

yes as you said

bilbss 2021-06-05 23:01:13
piterden 2021-06-05 17:40:38
That task is incomplete, cause it can be a several edge cases which isn’t described in task. For exapmle what to do if product_id would repeated?

for user_id=1
user_id | similarity
2 0.67
3 0.33
4 0
——————
for user_id=2
user_id | similarity
1 0.67
3 0.33
4 0

piterden 2021-06-05 23:13:52
bilbss 2021-06-05 22:59:55
i am trying to make some product recomment. if users bought same products. i will recommend new product for them(which has similarity is high)

What if the bought product twice or more times?

piterden 2021-06-05 23:15:00
It is much easier to calculate how many times the product was bought
|