mysql学习之路

1-- 更新

UPDATE help_topic a

SET`name` = 'WANG'

WHERE

    a.help_category_id = 28;

1-- 查询

SELECT
      *
FROM
      help_topic A
WHERE
      A. NAME = 'DAVID';

1--删除

DELETE
FROM
    help_topic
WHERE
    `name` = 'WANG';

1-- 添加

INSERTINTO help_topic (
    `name`,
    `help_category_id`,
    `description`,
    `example`,
    `url`
)
VALUES
    (
        'DAVID',
        28,
        'DAD',
        'DADA',
        'SB'
    );

1—GROUP BY剔除重复,适用于两张表