how to insert text with sql query into a table in mysql?

Question

Please help me to insert simple sql query into table for example:

insert into table0 ( sql_text) values ( 'select count(*) from table1;');

I am receiving error .

Thanks,

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax — alecrama
– alecrama, Commented Jan 19, 2018 at 13:20

Aaditya Parmar · Accepted Answer · 2018-01-19 13:27:34Z

1

Please try the following:

INSERT INTO tableName (columnName) values ('Select count(*) from tableName; ');

answered Jan 19, 2018 at 13:27

Aaditya Parmar

431 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1