| From: | Yambu <hyambu(at)gmail(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: insert into table |
| Date: | 2021-05-29 04:33:24 |
| Message-ID: | CALhHtcBtCT8qMpqd+z2mC+eByzUBXCLES_TeRUKJgm92mbLSyw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi David
There is no error, it just says zero rows affected, but when i run select
it brings results
On Sat, May 29, 2021 at 6:29 AM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> On Fri, May 28, 2021 at 9:22 PM Yambu <hyambu(at)gmail(dot)com> wrote:
>
>> may i know why the below mysql is not inserting into table analyze_checks
>> insert into analyze_checks(dbname,table_name,frag_ratio,
>> days,needs_optimization,needs_analyzing )
>> (select
>>
>>
> Since I don't have the benefit of seeing an error message I'm going to
> presume the parentheses surrounding the select query are being rejected.
>
> David J.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Holger Jakobs | 2021-05-29 08:10:05 | Re: Upgrading password encryption from md5 to scram-sh-256 |
| Previous Message | David G. Johnston | 2021-05-29 04:28:45 | Re: insert into table |