laravel6 文档
摘要：https://learnku.com/docs/laravel/6.x
阅读全文
摘要：UPDATE `test`SET `code` = ( CASE WHEN `id` = 1 THEN 11 WHEN `id` = 2 THEN 22 WHEN `id` = 3 THEN 33 END )WHERE `id` IN (1, 2, 3);
阅读全文
摘要：根据A表中的id字段和B表中的id字段，将B表中name字段和price字段值更新到A表中name字段和price字段 UPDATE A, BSET A.name = B.name, A.price = B.priceWHERE A.id = B.id
阅读全文
