tranchausky/laravel-demo-upset.sql

Last active June 3, 2024 04:23

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/tranchausky/9c6ac34e4996ffa9e1219a488349a43e.js"></script>
Save tranchausky/9c6ac34e4996ffa9e1219a488349a43e to your computer and use it in GitHub Desktop.

Download ZIP

demo laravel upset (update/insert) need catalog_id is unique

Raw

laravel-demo-upset.sql

insert into `subModel` (`catalog_id`, `name`) values ('1', 'CCC'), ('2', 'GS'), ('3', 'SX'), ('4', 'GL'), ('10', 'Home,cc') on duplicate key update `catalog_id` = values(`catalog_id`), `name` = values(`name`)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment