| Предыдущая версия справа и слева Предыдущая версия Следующая версия | Предыдущая версия |
| добавить_в_бд [2022/03/28 08:05] – admin | добавить_в_бд [2022/03/28 09:22] (текущий) – внешнее изменение 127.0.0.1 |
|---|
| <code> | <code> |
| SET @i = (SELECT MAX(id) + 1 FROM company); | SET @i = (SELECT MAX(id) + 1 FROM company); |
| INSERT INTO `company` (`name`, `label`, `region_id`, `main_address_id`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES (CONCAT('Компания ', @i), '', 9, 1, 1, '2022-03-28 10:15:30', NULL, 1, NULL); | INSERT INTO `company` (`name`, `label`, `region_id`, `main_address_id`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES (CONCAT('Компания ', @i), '', 9, null, 1, '2022-03-28 10:15:30', NULL, 1, NULL); |
| SET @product_id = LAST_INSERT_ID(); | SET @product_id = LAST_INSERT_ID(); |
| INSERT INTO `address` (`vista_id`, `company_id`, `name`, `label`, `inn`, `country_code`, `city`, `state`, `zip_code`, `street`, `house`, `apartment`, `address`, `latitude`, `longitude`, `type_id`, `status`, `comment`, `created_by`, `updated_by`) VALUES ( NULL, @product_id, CONCAT('Компания ', @i), '', CONCAT('Компания ', @i), 'AZ', '', '', NULL, NULL, NULL, NULL, '', '', '', NULL, 10, '', 1, NULL); | INSERT INTO `address` (`vista_id`, `company_id`, `name`, `label`, `inn`, `country_code`, `city`, `state`, `zip_code`, `street`, `house`, `apartment`, `address`, `latitude`, `longitude`, `type_id`, `status`, `comment`, `created_by`, `updated_by`) VALUES ( NULL, @product_id, CONCAT('Компания ', @i), '', CONCAT('Компания ', @i), 'AZ', '', '', NULL, NULL, NULL, NULL, '', '', '', NULL, 10, '', 1, NULL); |
| SET @variant_id = LAST_INSERT_ID(); | SET @variant_id = LAST_INSERT_ID(); |
| UPDATE `company` SET `main_address_id`= @variant_id WHERE id = @product_id; | UPDATE `company` SET `main_address_id`= @variant_id WHERE id = @product_id; |
| | |
| | INSERT INTO `address` (`vista_id`, `company_id`, `name`, `label`, `inn`, `country_code`, `city`, `state`, `zip_code`, `street`, `house`, `apartment`, `address`, `latitude`, `longitude`, `type_id`, `status`, `comment`, `created_by`, `updated_by`) VALUES ( NULL, @product_id, 'Адрес', '', 'Адрес', 'AZ', '', '', NULL, NULL, NULL, NULL, '', '', '', 6, 10, '', 1, NULL); |
| | ... |
| | INSERT INTO `address` (`vista_id`, `company_id`, `name`, `label`, `inn`, `country_code`, `city`, `state`, `zip_code`, `street`, `house`, `apartment`, `address`, `latitude`, `longitude`, `type_id`, `status`, `comment`, `created_by`, `updated_by`) VALUES ( NULL, @product_id, 'Адрес', '', 'Адрес', 'AZ', '', '', NULL, NULL, NULL, NULL, '', '', '', 6, 10, '', 1, NULL); |
| |
| </code> | </code> |