Re: not able to create table tablename as (some query) IN MYSQL 5.7 DATABASE. any global variable need to be set on db level. please elp.
Posted by: ajeet kumar
Date: February 19, 2017 10:25PM

Please find the query and error code attaced below.

create table tata_mas_user_test as select * from tata_mas_user where tata_mas_districtid=1;


Error Code : 1786
Unknown error 1786

Please help me.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.