besokuse233的博客

with person_name as ( select c.id, array_to_string(array_agg(distinct p.c_name), ' , ') as p_name from biz_notification_config c join biz_notification_person p ...

数据表的添加 通用语法：CREATE TABLE table_name (column_name column_type); 比如 CREATE TABLE IF NOT EXISTS `tb_book`( `book_id` INT UNSIGNED AUTO_INCREMENT, `book_title` VARCHAR(100) NOT NULL, `book_author...

添加数据 INSERT INTO table_name ( field1, field2,...fieldN ) VALUES ( value1, value2,...valueN ); 如果要添加多条数据的话一定，一个括号代表 一条，不要把多条数据写在一个括号里。 INSERT INTO table_name ( field1, field2,...fieldN ) VALUE...