METHOD AND SYSTEM FOR GENERATING SQL STATEMENT, ELECTRONIC APPARATUS AND READABLE STORAGE MEDIUM

摘要

A method and system for generating an SQL statement, an electronic apparatus and a readable storage medium, which realize automatic and accurate generation of an SQL statement. The method comprises: receiving an SQL statement generation instruction sent by a user, and generating and displaying an SQL statement generation type selection interface; if an instruction of choosing to generate a universal SQL statement by the user based on the SQL statement generation type selection interface is received, generating and displaying a DDL statement parameter setting interface, and after basic information input by the user based on the DDL statement parameter setting interface is received, generating a DDL statement according to the basic information; and if an instruction of choosing to generate a customized SQL statement by the user based on the SQL statement generation type selection interface is received, generating and displaying a function change selection interface, and after a changed function selected by the user based on the function change selection interface is received, determining, according to a pre-set mapping relationship between a function change item and an SQL statement block, an SQL statement block corresponding to the selected changed function.