What is friendship?

|
ysf_cms 2021-03-28 20:19:05
MasterZiv 2021-03-27 22:48:26
The GNU/Linux command to show 10 top lines of CSV file

I can see it that way.

piterden 2021-03-28 21:50:55
ysf_cms 2021-03-28 20:18:24

And what do these digits mean?

ysf_cms 2021-03-29 00:36:59
Δ°t is value and table value
JordanErifried 2021-03-29 22:30:35
Wao that’s great 🀧🀧🀧
joshtee4 2021-03-30 10:02:12
I just finished learning MySQL I need a volunteer work to gather some experience, if you have please share the link to apply
Deb_575 2021-03-30 12:20:43
mysql_en-8902.jpg

Deb_575 2021-03-30 12:20:59
Can someone help with this it’s a workbench issue it seems
MasterZiv 2021-03-30 12:32:05
Deb_575 2021-03-30 12:20:59
Can someone help with this it’s a workbench issue it seems

It is not a standard issue, you must investigate the problem first

Deb_575 2021-03-30 14:08:39
I did try to check the activity log but it didn’t record anything related to this
eg2710 2021-03-31 09:51:50
Hello everyone, I would like if possible a help regarding a part of the design of a db , I am trying to make a small db for a social network , and I am encountering some doubts regarding the functionality of friendships. I have a user entity , and a friendship entity , that interact through an association , that is request.
My doubt is that I’m not sure if this association should be 1 to N or N to N.
Thanks in advance
MasterZiv 2021-03-31 10:34:27
eg2710 2021-03-31 09:51:50
Hello everyone, I would like if possible a help regarding a part of the design of a db , I am trying to make a small db for a social network , and I am encountering some doubts regarding the functionality of friendships. I have a user entity , and a friendship entity , that interact through an association , that is request.
My doubt is that I’m not sure if this association should be 1 to N or N to N.
Thanks in advance

What is friendship?
Please Post DDL or ER-diagrams of this past of DB

piterden 2021-03-31 10:36:31
The bold friendship ))
MasterZiv 2021-03-31 10:38:55
eg2710 2021-03-31 09:51:50
Hello everyone, I would like if possible a help regarding a part of the design of a db , I am trying to make a small db for a social network , and I am encountering some doubts regarding the functionality of friendships. I have a user entity , and a friendship entity , that interact through an association , that is request.
My doubt is that I’m not sure if this association should be 1 to N or N to N.
Thanks in advance

Most probably it should be M2M, but who knows your DB…

piterden 2021-03-31 10:46:03
Actually Friendship is M-M between User and User
piterden 2021-03-31 10:47:45
users
– id
– name
– …

friendships
– id
– user1_id
– user2_id

eg2710 2021-03-31 11:25:02
Ok wait
eg2710 2021-03-31 11:29:18
amicizia is friendship
MasterZiv 2021-03-31 11:30:03
eg2710 2021-03-31 11:29:18
amicizia is friendship

Sorry, man, no way. I can’t understand this language

MasterZiv 2021-03-31 11:30:22
Nothing can I see from this.
MasterZiv 2021-03-31 11:32:05
BTW, a good idea is not to use role names for fields when this is not needed, when there is only one FK to this table in a child.
eg2710 2021-03-31 11:32:17
MasterZiv 2021-03-31 10:34:27
What is friendship?
Please Post DDL or ER-diagrams of this past of DB

The friendship is a feature that occurs when a user wants to follow another user.

eg2710 2021-03-31 11:33:42
MasterZiv 2021-03-31 11:30:03
Sorry, man, no way. I can’t understand this language

ok i do the model again

MasterZiv 2021-03-31 11:34:25
I’ll try to translate , what is this language ?
MasterZiv 2021-03-31 11:35:53
Italiano, fine
MasterZiv 2021-03-31 11:37:58
eg2710 2021-03-31 11:33:42
ok i do the model again

Stop doing, I have read it

MasterZiv 2021-03-31 11:39:59
eg2710 2021-03-31 11:32:17
The friendship is a feature that occurs when a user wants to follow another user.

You already have a many-to-many relationship between users, so all is FINE.

Only I would recommend REMOVING the surrogate key in FRIENDSHIP table, id_amicizia.

It is almost never needed,

eg2710 2021-03-31 11:45:17
I didn’t see any need for it, but the derivation rules provide for it.
eg2710 2021-03-31 11:46:40
Fortunately I saw the message in time, I was making the diagram again.πŸ˜…πŸ˜‚
piterden 2021-03-31 11:47:45
More looks like a chemical formula than a database structure ))
piterden 2021-03-31 11:48:32
I see benzene rings
eg2710 2021-03-31 11:49:10
piterden 2021-03-31 11:47:45
More looks like a chemical formula than a database structure ))

ok

MasterZiv 2021-03-31 11:49:58
incresed max connection to 250
MasterZiv 2021-03-31 11:49:58
tried restart mysql service and reboot server
MasterZiv 2021-03-31 11:49:58
Server ubuntu
MasterZiv 2021-03-31 11:49:58
mysql_en-8939.jpg
Hi guys
I need help
phpmyadmin working correctly but 3rd party resurces not connecting squel or workbench

Login and password correct

|