viewのcreate
CREATE OR REPLACE ALGORITHM = MERGE VIEW v_test AS SELECT t.*,c.hoge FROM test t LEFT JOIN code c ON t.id = c.test_id;
CREATE OR REPLACE ALGORITHM = MERGE VIEW v_test AS SELECT t.*,c.hoge FROM test t LEFT JOIN code c ON t.id = c.test_id;