# Articles tagged

• ## How to update a field in a table with a field from another table

I needed a table which gave the map between the URLs and nodes in drupal. I ended up creating a table like this :

CREATE TABLE nid_url_map (
nid int(10) NOT NULL DEFAULT '0',
url varchar(255) DEFAULT NULL,
type varchar(32) DEFAULT NULL,
PRIMARY KEY (nid)
) ENGINE=InnoDB DEFAULT CHARSET …

Page 1 / 1