INSERT INTO Goods (good_id, good_name, type) VALUES ((SELECT * FROM (SELECT COUNT(*) FROM Goods) AS t) + 1, 'Table', 'equipment');
INSERT INTO Goods (good_id, good_name, type)
VALUE ((SELECT COUNT(*)+1 FROM Goods AS a),
'Table',
(SELECT good_type_id FROM GoodTypes AS b WHERE good_type_name ='equipment'));
SELECT * FROM Goods
В качестве первичного ключа (good_id) укажите количество записей в таблице + 1.
INSERT INTO Goods (good_id, good_name, type)
VALUES ((SELECT COUNT(*) FROM Goods) + 1, 'Table', 'equipment');
пишет что не правильно
Выдает
ER_UPDATE_TABLE_USED: You can't specify target table 'Goods' for update in FROM clause