SequelizeのUPDATEにORM変換 - S2M

に

🤔

ここにSQLを入力してください。※英数字のみ

UPDATE 
  sample 
SET 
  title = 'sample1' 
WHERE 
  id = 1

Sample.update(
{'title': 'sample1'},
{where: {[Op.and]: [{id: {[Op.eq]: 1}}]}}
);

対象バージョン

最終更新日・推奨ブラウザ・動作確認DB

CakePHP3

v 3.5

Yii2

v 2.0.14

Laravel5

v 5.5

Ruby on Rails

v 5.2.0

Django

v 2.0.6

Date

2018/08/26

Browser

Google Chrome

DB

MySQL

Golang

v 1.9.4

Sequelize(Node.js)

v 4.38.0

Slick(Scala)

v 3.1.1

お知らせ

2018-08-26Slick(Scala)変換に対応しました。

2018-07-30Sequelize(Node.js)変換に対応しました。

2018-07-18SQLエディタ、ORMエディタを改良しました。

テンプレートリンク

【CakePHP3】SELECT | INSERT | UPDATE | DELETE

【Yii2】SELECT | INSERT | UPDATE | DELETE

【Laravel5】SELECT | INSERT | UPDATE | DELETE

【Ruby on Rails】SELECT | INSERT | UPDATE | DELETE

【Django】SELECT | INSERT | UPDATE | DELETE

【GORM】SELECT | INSERT | UPDATE | DELETE

【Sequelize】SELECT | INSERT | UPDATE | DELETE

SELECT 
  id, title 
FROM 
  sample 
WHERE 
  id = 1

SELECT 
  * 
FROM 
  sample 
WHERE 
  id = 1 
  AND 
  title = 'sample1'

SELECT 
  * 
FROM 
  sample 
WHERE 
  id = 1 
  OR 
  title = 'sample1'

SELECT 
  * 
FROM 
  sample 
WHERE 
  (id = 1 AND title = 'sample1') 
  OR 
  (id = 2 AND title = 'sample2')

SELECT 
  * 
FROM 
  sample 
WHERE 
  title LIKE '%sample1%'

SELECT 
  * 
FROM 
  sample 
WHERE 
  id IN (1, 2, 3, 4)

SELECT 
  * 
FROM 
  sample 
INNER JOIN 
  sample1 
ON sample.id = sample1.id 
WHERE 
  sample.id = 1

SELECT 
  * 
FROM 
  sample 
LEFT JOIN 
  sample1 
ON sample.id = sample1.id 
WHERE 
  sample.id = 1

SELECT 
  * 
FROM 
  sample 
RIGHT JOIN 
  sample1 
ON sample.id = sample1.id 
WHERE 
  sample.id = 1

SELECT 
  * 
FROM 
  sample 
WHERE 
  id IN (SELECT 
          id 
        FROM 
          sample1 
        WHERE 
          id = 1
       )

INSERT INTO 
  sample(id, title) 
VALUES 
  (1, 'sample1')

UPDATE 
  sample 
SET 
  title = 'sample1' 
WHERE 
  id = 1

DELETE FROM 
  sample 
WHERE 
  id = 15

SELECT 
  id, title 
FROM 
  sample 
WHERE 
  id IS NULL

SELECT 
  id, title 
FROM 
  sample 
WHERE 
  id IS NOT NULL

SELECT 
  id, title 
FROM 
  sample 
WHERE 
  id BETWEEN 1 AND 100

SELECT 
  id, title 
FROM 
  sample 
WHERE 
  id NOT BETWEEN 1 AND 100

SELECT 
  *  
FROM 
  sample 
LIMIT 5

(SELECT id 
 FROM sample 
 WHERE id = 1
) UNION ALL 
(SELECT id 
 FROM sample 
 WHERE id = 2
) UNION 
(SELECT id 
 FROM sample 
 WHERE id = 3
)

SELECT 
 id, 
 title 
FROM 
 user 
UNION (SELECT id, title FROM sample) 
UNION (SELECT id, title FROM sample)

SELECT 
  *  
FROM 
  sample 
ORDER BY id ASC

SELECT 
  id   
FROM 
  sample 
GROUP BY id