Login Register

db\Command setSql()

setSql() public method

Specifies the SQL statement to be executed.

The previous SQL execution (if any) will be cancelled, and $params will be cleared as well.

public $this setSql ( $sql )
$sql	string	The SQL statement to be set.
return	$this	This command instance

Links:

http://www.yiiframework.com/doc-2.0/yii-db-command.html#setSql()-detail

doc_Yii

2025-01-10 15:47:30

Comments

Leave a Comment

Please login to continue.

Popular Articles

db\Command $db $db public property The DB connection that this command is associated with public yii\db\Connection $db = null

db\Command batchInsert() batchInsert() public method Creates a batch INSERT command. For example, $connection->createCommand()->batchInsert('user', ['name', 'age'],

db\Command bindParam() bindParam() public method Binds a parameter to the SQL statement to be executed. See also http://www.php.net/manual/en/function.PDOStatement-bind

db\Command queryScalar() queryScalar() public method Executes the SQL statement and returns the value of the first column in the first row of data. This method is best us

db\Command queryInternal() queryInternal() protected method (available since version 2.0.1) Performs the actual DB query of a SQL statement. protected mixed queryInternal