Re: Create a row, use id as value in another row?

[Don Ireland]

Sorry for got to add the code....

CREATE TABLE test (
id INT(6) AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(30) NOT NULL,
parentID INT(6)
)

INSERT INTO `test` (`name`, `parentID`) VALUES
('child',
INSERT INTO `test` (`name`) VALUES ### subquery to insert a row. The id field from this will be used as the parentID value of the main query.('top');
);

Don