BEGIN; DELETE FROM attribute WHERE version = 'html40'; COMMIT; INSERT INTO attribute(version,name,url) VALUES('html40','', 'http://www.w3.org/TR/REC-html40/'); INSERT INTO element_attribute(elementid,attributeid) SELECT element.id,attribute.id FROM element,attribute WHERE element.version = 'html40' AND element.name = '' AND attribute.version = 'html40' AND attribute.url = 'http://www.w3.org/TR/REC-html40/';