A FRAMEWORK FOR MYSQL PRE-PROCESSOR WITH INTERACTIVE USER INTERFACES

Abstract

The error messages displayed after compilation of MySQL query shows the MySQL error code, SQLSTATE value and text string in command prompt. The displayed error messages will lead an inconvenience to users who are willing to assess the full details of the errors. The proposed framework presents the design of pre-processor with attractive interactive user interfaces to reduce the ambiguity of the error messages generated after the compilation of MySQL query. The output of the proposed pre-processor gives the packed error details when an error occurs during the compilation of query and it shows clear error messages to the users instead of giving existing warning message in the command prompt. This will facilitate the users who are not an expert in MySQL and they easily tackle the type error message and where they occurred. The proposed pre-processor also provides a lot of interactive interfaces for handling databases and tables stored within the MySQL server as supporting elements for creation of queries generates Interactive text editor with intellisence facilities for users to minimize their careless or typing errors. Finally, the prototype of this preprocessor supports different types of queries with an expected error details and reduces the ambiguity of the warning messages displayed after the compilation of MySQL query.