在php和sql server中执行sql查询有什么区别？ [英] what is the difference between when execute sql query in php and sql server ?

问题描述

正常的php代码执行sql查询与存储过程有什么区别？

what is the difference between execute sql query in php code normally and with a stored procedure?

推荐答案

可能你想知道'标准'之间的区别 SQL 查询和存储过程。 Google可能会提供帮助 [ ^ ]。

Probably you want to know the difference between a 'standard' SQL query and a stored procedure. Google might help[^].

取而代之在PHP代码中编写SQL查询，

a存储过程是一个用MySQL编写的SQL程序，存储在数据库中，可以由数据库引擎和连接的编程语言（如PHP）调用。

参考： stored-procedures-mysql-php [ ^ ]

Instead of writing sql queries in the PHP code,
a Stored Procedure is a procedure written in SQL in your case MySQL and is stored in a database which can be called by the database engine and connected programming languages like PHP.
Refer: stored-procedures-mysql-php[^]

这篇关于在php和sql server中执行sql查询有什么区别？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！