ჷჷჷ񪂧MySQL 3-4.ᄃᄃᄃᄃᄃᄃᄃᄃᄃᄃᄃᄃᄃ

1.DELETE-指定された条件の行を削除
「マスター」>「SQL Editor」>「Safe Updates」エントリのチェックアウトと再接続

DELETE FROM businesses
WHERE status = 'CLS';

DELETE文を使用して行全体を削除

DELETE FROM businesses;

INSERT INTO businesses (fk_section_id, business_name, status, can_takeout)
VALUES  (3, '화룡각', 'OPN', 1),
        (2, '철구분식', 'OPN', 1),
        (5, '얄코렐라', 'RMD', 1);

💡 TRUNCATE文でテーブルを初期化する

TRUNCATE businesses;

INSERT INTO businesses (fk_section_id, business_name, status, can_takeout)
VALUES  (3, '화룡각', 'OPN', 1),
        (2, '철구분식', 'OPN', 1),
        (5, '얄코렐라', 'RMD', 1);

2.UPDATE-指定された条件の行を変更する

UPDATE menus
SET menu_name = '삼선짜장'
WHERE menu_id = 12;

複数の列の変更

UPDATE menus
SET 
  menu_name = '열정떡볶이',
  kilocalories = 492.78,
  price = 5000
WHERE 
  fk_business_id = 4
  AND menu_name = '국물떡볶이';

列データを使用した変更

UPDATE menus
SET price = price + 1000
WHERE fk_business_id = 8;

UPDATE menus
SET menu_name = CONCAT('전통 ', menu_name)
WHERE fk_business_id IN (
  SELECT business_id 
  FROM sections S
  LEFT JOIN businesses B
    ON S.section_id = B.fk_section_id 
  WHERE section_name = '한식'
);

▼▼▼▼▼▼▼条件文のないすべての行の変更

UPDATE menus
SET menu_name = '획일화';