Keep track of the errors encountered today in thinkphp3.2.3 SQLSTATE[42S02]: Base table or view not found:1146 table ' test.file_info ' doesn ' t exist, previously with PD o Connection to the database has been no problem, today suddenly found that
Learn SQLSTATE, sqlstate08001
1. What is SQLSTATE?
Shell> SELECT * FROM no_such_table;
ERROR 1146 (42S02): Table 'test. no_such_table 'doesn' t exist
Display after an error occurs in the preceding SQL statement. 1146 is the error code defined by
Http://dev.mysql.com/doc/refman/5.7/en/error-messages-server.htmlB.3 Server Error Codes and MessagesMySQL programs has access to several types of error information when the server returns an error. For example, the MySQLclient program displays
In MySQL, specific exceptions require specific processing. These exceptions can be linked to errors, as well as general process control in subroutines. Defining an exception is a prior definition of the problem encountered during the execution of
Stored Procedure 5-handling of conditions and exceptions and handling of Stored Procedure exceptions
Exception Handling can be used for general process control in subprograms. If you want to handle errors during SQL Execution, you can use exception
Exception Handling can be used for general process control in subprograms. If you want to handle errors during SQL Execution, you can use exception handling. For example, for errors or warnings that may occur in Stored Procedures, triggers, or
MySQL defines the exception and exception handling methods, and MySQL defines the handling methods
In MySQL, specific exceptions must be handled. These exceptions can be associated with errors and general process control in subprograms. Defining
In MySQL, the basic form of creating stored procedures is as follows:
CREATE PROCEDURE sp_name ([proc_parameter[,...]])
[Characteristic ...] Routine_body
Where the Sp_name parameter is the name of the stored procedure,
Transferred from: http://www.cnblogs.com/exmyth/p/3303470.html14.1.1 Creating a stored procedureIn MySQL, the basic form of creating stored procedures is as follows:
CREATE PROCEDURE sp_name ([proc_parameter[,...]])
[Characteristic ...]
In MySQL, the basic form of creating stored procedures is as follows:
CREATE PROCEDURE sp_name ([proc_parameter[,...]])
[Characteristic ...] Routine_body
Where the Sp_name parameter is the name of the stored procedure,
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.