CREATE OR REPLACE with MyISAM + OQGRAPH

CREATE TABLE ttt (

	a INT NOT NULL,

	b INT NOT NULL

) ENGINE = MyISAM;

INSERT INTO ttt (a, b) VALUES (1, 10), (2, 10), (3, 10);

CREATE TABLE oq (

  latch VARCHAR(32) NULL,

  origid BIGINT UNSIGNED NULL,

  destid BIGINT UNSIGNED NULL,

  weight DOUBLE NULL,

  seq BIGINT UNSIGNED NULL,

  linkid BIGINT UNSIGNED NULL,

  KEY (latch, origid, destid) USING HASH,

  KEY (latch, destid, origid) USING HASH

) 

	ENGINE = OQGRAPH 

	DATA_TABLE = 'ttt'

	ORIGID = 'a'

	DESTID = 'b';

SELECT *

	FROM oq

	WHERE latch = 'dijkstras'

		AND origid = 1

		AND destid = 10;

SELECT * FROM ttt;

CREATE OR REPLACE TABLE ttt (

	a INT,

	b INT

) ENGINE = MyISAM;

SELECT * FROM ttt;