If mysql operations are encapsulated into stored procedures, can you create a website? if you encapsulate all operations performed on the database into stored procedures, isn't it easier to maintain it in the future than simply writing SQL statements in the program? share it: If mysql operations are encapsulated into a stored procedure, is it good?
Excuse me
If a website encapsulates all database operations into a stored procedure,
Is it easier for future maintenance than simply writing SQL statements in the program?
Share:
------ Solution --------------------
Stored procedures, as long as the database does not have problems, basically there will be no problems.
That is to say, in terms of security, the system that uses stored procedures is more stable.
We also need to know that the biggest problem with the stored procedure is poor portability. if the landlord ignores this aspect, we can consider using
------ Solution --------------------
In fact, we don't need to encapsulate a common PHP file for database operations.
