Re: insert into table

[Yambu <hyambu@xxxxxxxxx>]

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.g.johnston@xxxxxxxxx> wrote:

On Fri, May 28, 2021 at 9:22 PM Yambu <hyambu@xxxxxxxxx> 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.