ahmedkhan

You can select null from your parent and then insert it your foreign key. INSERT INTO `transactions` (`id`, `ref`, `date`, `payee`, `amount`, `memo`, `catID`, `acctXID`, `acctID`, `version`, `userID`, `type`, `parentID`, `defCatID`) VALUES (4893, NULL, '2000-01-04 07:19:00', 'John Trivett', NULL, 'NULL', NULL, (SELECT NULL FROM defaultCategories) , 1, 0, 4, NULL, NULL, NULL), (4894, NULL, NULL, NULL, '8.76', NULL, 0, 2, NULL, 0, 4, NULL, 4893, 0), (4895, NULL, NULL, NULL, '4.84', NULL, 207, 0, NULL, 0, 4, NULL, 4893, 0), (4896, NULL, NULL, NULL, '2.28', NULL, 211, 0, NULL, 0, 4, NULL, 4893, 0);

With more than 20 years of experience under his arsenal, Bill karwin is one of the senior most guys to go to when you want to know about Databases. Bill Karwin is a Senior Database architect and has authored many different books related to SQL, including the SQL Antipatterns: Avoiding the Pitfalls of Database Programming. Before working as a Senior Database Architect, he was involved with multiple projects of software engineering and has also worked in zend for as a project manager. You can read interview here.