How can I implement graph database with MySQL?

Question

I want to implement connection as friends of friends using MySQL

symcbean · Accepted Answer · 2011-03-23 11:38:38Z

4

CREATE TABLE user (
 id MEDIUMINT NOT NULL AUTO_INCREMENT,
 name VARCHAR(30) NOT NULL,
 email VARCHAR(60) NOT NULL,
 ....
 PRIMARY KEY (id)
);
CREATE TABLE friendof (
  user_a_id MEDIUMINT NOT NULL,
  user_b_id MEDIUMINT NOT NULL,
  PRIMARY KEY(user_a_id, user_b_id),
  FOREIGN KEY(user_a_id) REFERENCES user(id),
  FOREIGN KEY(user_b_id) REFERENCES user(id),
  KEY reverseLookup (user_b_id),
  KEY lookup (user_a_id),
);

Was that really so hard?

answered Mar 23, 2011 at 11:38

symcbean

48.4k6 gold badges63 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dan Over a year ago

maybe he meant how to traverse such tables? running DFS on mySql can be tricky

Jon Black Over a year ago

add engine=innodb (now default in 5.5) and drop key lookup(user_a_id) and you'll be well sorted !

Collectives™ on Stack Overflow

How can I implement graph database with MySQL?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related