DataManipulationStatementsInterface
in
These statements do not implicitly commit the current transaction.
Data Manipulation Language (DML) statements are used for managing data within schema objects DML deals with data manipulation, and therefore includes most common SQL statements such as SELECT, INSERT, etc. DML allows adding / modifying / deleting data itself.
Tags
Table of Contents
Methods
- delete() : int|null
- deleteWhere() : int|null
- insert() : string|null
- insertMany() : void
- insertOne() : string|null
- replace() : string|null
- replaceOne() : string|null
- select() : array<string|int, mixed>|null
- update() : int|null
- updateWhere() : int|null
- updateWhereMany() : void
Methods
delete()
public
delete(string $query) : int|null
Parameters
- $query : string
Return values
int|nulldeleteWhere()
public
deleteWhere(array<string|int, mixed> $whereFields, string $table[, array<string|int, mixed> $whereNotFields = [] ]) : int|null
Parameters
- $whereFields : array<string|int, mixed>
- $table : string
- $whereNotFields : array<string|int, mixed> = []
Return values
int|nullinsert()
public
insert(string $query) : string|null
Parameters
- $query : string
Return values
string|nullinsertMany()
public
insertMany(array<string|int, mixed> $data, array<string|int, string> $cols, string $table[, bool $ignore = false ][, string $onDuplicateSql = '' ]) : void
Parameters
- $data : array<string|int, mixed>
- $cols : array<string|int, string>
- $table : string
- $ignore : bool = false
- $onDuplicateSql : string = ''
Tags
insertOne()
public
insertOne(array<string, float|int|MydbExpressionInterface|string|null> $data, string $table) : string|null
Parameters
- $data : array<string, float|int|MydbExpressionInterface|string|null>
- $table : string
Return values
string|nullreplace()
public
replace(string $query) : string|null
Parameters
- $query : string
Return values
string|nullreplaceOne()
public
replaceOne(array<string, float|int|MydbExpressionInterface|string|null> $data, string $table) : string|null
Parameters
- $data : array<string, float|int|MydbExpressionInterface|string|null>
- $table : string
Return values
string|nullselect()
public
select(string $query) : array<string|int, mixed>|null
Parameters
- $query : string
Return values
array<string|int, mixed>|nullupdate()
public
update(string $query) : int|null
Parameters
- $query : string
Return values
int|nullupdateWhere()
public
updateWhere(array<string, float|int|string|MydbExpressionInterface|null> $update, array<string|int, mixed> $whereFields, string $table[, array<string|int, mixed> $whereNotFields = [] ]) : int|null
Parameters
- $update : array<string, float|int|string|MydbExpressionInterface|null>
- $whereFields : array<string|int, mixed>
- $table : string
- $whereNotFields : array<string|int, mixed> = []
Return values
int|nullupdateWhereMany()
public
updateWhereMany(array<string|int, mixed> $columnSetWhere, array<string|int, mixed> $where, string $table) : void
Parameters
- $columnSetWhere : array<string|int, mixed>
- $where : array<string|int, mixed>
- $table : string