Sample values and generated SQL are preserved exactly as exported, including Japanese data.
A report for reviewing project edits. It does not apply changes to a database.
SQL target database: MySQL
Colors: added = green, changed = yellow, deleted = red
| Column | At the start of editing | Current master data | Project edits |
|---|---|---|---|
| Code (code) | Code (code) Type: string Length/precision: 3 Required: yes Default: none | Code (code) Type: string Length/precision: 3 Required: yes Default: none | Code (code) Type: string Length/precision: 3 Required: yes Default: none |
| Product name (name) | Product name (name) Type: string Length/precision: 100 Required: no Default: none | Product name (name) Type: string Length/precision: 100 Required: no Default: none | Product name (name) Type: string Length/precision: 100 Required: no Default: none |
| Price (price) | Price (price) Type: number Length/precision: 10 Decimal places: 2 Required: no Default: none | Price (price) Type: number Length/precision: 10 Decimal places: 2 Required: no Default: none | Price (price) Type: number Length/precision: 10 Decimal places: 2 Required: no Default: none |
| Note (memo) | Note (memo) Type: long text Required: no Default: none | Note (memo) Type: long text Required: no Default: none | Note (memo) Type: long text Required: no Default: none |
| Settings (setting) | Settings (setting) Type: JSON Required: no Default: none | Settings (setting) Type: JSON Required: no Default: none | Settings (setting) Type: JSON Required: no Default: none |
| Date (biz_date) | Date (biz_date) Type: date Required: no Default: none | Date (biz_date) Type: date Required: no Default: none | Date (biz_date) Type: date Required: no Default: none |
| Updated at (updated_at) | Updated at (updated_at) Type: datetime Required: no Default: none | Updated at (updated_at) Type: datetime Required: no Default: none | Updated at (updated_at) Type: datetime Required: no Default: none |
| Active (active) | Active (active) Type: flag Required: no Default: none | Active (active) Type: flag Required: no Default: none | Active (active) Type: flag Required: no Default: none |
| Row | Primary key | Status | Changed fields | Details |
|---|---|---|---|---|
| 1 | Code (code)=001 | Changed | Price (price): 1200.00 → 1500.00 | View comparison details |
| 2 | Code (code)=002 | Deleted | Code (code): 002 → — Product name (name): 商品B → — Price (price): 2400.50 → — Note (memo): 初期メモ → — Settings (setting): {"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}} → — Date (biz_date): 2026-10-03 → — Updated at (updated_at): 2026-10-03T12:34:56.123456 → — Active (active): 1 → — | View comparison details |
| 3 | Code (code)=003 | Unchanged | None | View comparison details |
| 4 | Code (code)=004 | Added | Code (code): — → 004 Product name (name): — → 商品D Price (price): — → 4800.00 Note (memo): — → 初期メモ Settings (setting): — → {"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}} Date (biz_date): — → 2026-10-03 Updated at (updated_at): — → 2026-10-03T12:34:56.123456 Active (active): — → 1 | View comparison details |
| Field | At the start of editing | Current master data | Project edits |
|---|---|---|---|
| Code (code) | 001 | 001 | 001 |
| Product name (name) | 商品A | 商品A | 商品A |
| Price (price) | 1200.00 | 1200.00 | 1500.00 |
| Note (memo) | 初期メモ | 初期メモ | 初期メモ |
| Settings (setting) | {"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}} | {"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}} | {"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}} |
| Date (biz_date) | 2026-10-03 | 2026-10-03 | 2026-10-03 |
| Updated at (updated_at) | 2026-10-03T12:34:56.123456 | 2026-10-03T12:34:56.123456 | 2026-10-03T12:34:56.123456 |
| Active (active) | 1 | 1 | 1 |
| Field | At the start of editing | Current master data | Project edits |
|---|---|---|---|
| Code (code) | 002 | 002 | — |
| Product name (name) | 商品B | 商品B | — |
| Price (price) | 2400.50 | 2400.50 | — |
| Note (memo) | 初期メモ | 初期メモ | — |
| Settings (setting) | {"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}} | {"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}} | — |
| Date (biz_date) | 2026-10-03 | 2026-10-03 | — |
| Updated at (updated_at) | 2026-10-03T12:34:56.123456 | 2026-10-03T12:34:56.123456 | — |
| Active (active) | 1 | 1 | — |
| Field | At the start of editing | Current master data | Project edits |
|---|---|---|---|
| Code (code) | 003 | 003 | 003 |
| Product name (name) | 商品C | 商品C | 商品C |
| Price (price) | 3600.00 | 3600.00 | 3600.00 |
| Note (memo) | 初期メモ | 初期メモ | 初期メモ |
| Settings (setting) | {"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}} | {"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}} | {"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}} |
| Date (biz_date) | 2026-10-03 | 2026-10-03 | 2026-10-03 |
| Updated at (updated_at) | 2026-10-03T12:34:56.123456 | 2026-10-03T12:34:56.123456 | 2026-10-03T12:34:56.123456 |
| Active (active) | 1 | 1 | 1 |
| Field | At the start of editing | Current master data | Project edits |
|---|---|---|---|
| Code (code) | — | — | 004 |
| Product name (name) | — | — | 商品D |
| Price (price) | — | — | 4800.00 |
| Note (memo) | — | — | 初期メモ |
| Settings (setting) | — | — | {"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}} |
| Date (biz_date) | — | — | 2026-10-03 |
| Updated at (updated_at) | — | — | 2026-10-03T12:34:56.123456 |
| Active (active) | — | — | 1 |
Overlapping changes with other projects: 0 columns, 0 records
| Column | At the start of editing | Current master data | Project edits |
|---|---|---|---|
| Code (code) | Code (code) Type: string Length/precision: 3 Required: yes Default: none | Code (code) Type: string Length/precision: 3 Required: yes Default: none | Code (code) Type: string Length/precision: 3 Required: yes Default: none |
| Category name (name) | Category name (name) Type: string Length/precision: 100 Required: no Default: none | Category name (name) Type: string Length/precision: 100 Required: no Default: none | Category name (name) Type: string Length/precision: 100 Required: no Default: none |
| Row | Primary key | Status | Changed fields | Details |
|---|---|---|---|---|
| 1 | Code (code)=C01 | Unchanged | None | View comparison details |
| 2 | Code (code)=C02 | Changed | Category name (name): 日用品 → 生活雑貨 | View comparison details |
| Field | At the start of editing | Current master data | Project edits |
|---|---|---|---|
| Code (code) | C01 | C01 | C01 |
| Category name (name) | 食品 | 食品 | 食品 |
| Field | At the start of editing | Current master data | Project edits |
|---|---|---|---|
| Code (code) | C02 | C02 | C02 |
| Category name (name) | 日用品 | 日用品 | 生活雑貨 |
Overlapping changes with other projects: 0 columns, 0 records
なし
START TRANSACTION;
UPDATE `PRODUCT` SET `price` = 1500.00 WHERE `code` = '001';
DELETE FROM `PRODUCT` WHERE `code` = '002';
INSERT INTO `PRODUCT` (`code`,`name`,`price`,`memo`,`setting`,`biz_date`,`updated_at`,`active`) VALUES ('004','商品D',4800.00,'初期メモ',CAST('{"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}}' AS JSON),DATE '2026-10-03',TIMESTAMP '2026-10-03 12:34:56.123456',1);
COMMIT;
なし
なし
START TRANSACTION; UPDATE `CATEGORYCATEGORY` SET `name` = '生活雑貨' WHERE `code` = 'C02'; COMMIT;
なし