db icon indicating copy to clipboard operation
db copied to clipboard

Yii Database Library

Results 102 db issues
Sort by recently updated
recently updated
newest added

When I execute batch inserting into tables with unique index, I hope the `batchInsert` method of `yii\db\Command` Class have a argument to specify whether to execute `INSERT IGNORE INTO` or...

### What steps will reproduce the problem? Try to add several addHavings to the query. ### What is the expected result? ```php [having] => [ 0 => 'and' 1 =>...

it should include the process of adding parenthesis to allow simpler override in sqlite\QueryBuilder. Currently the complete build() method is overridden just to add two parenthesis.

as a followup to #8644 / #11775: getting all tables and views should be consistent across schema implementations.

Hello. Sometimes I need to insert or update rows. I can do it using 'ON DUPLICATE KEY UPDATE'. what do you think?

A database can contain comments on the columns and the table itself. The comment of the columns can be read out trough the `ColumnSchema` class, but the comment on the...

The latest updates from several DB such as MySQL, Oracle, PostgreSQL are all supporting JSON data type with basic operations: create, update, index, validate. Should we implement a support at...

# Clarification There is more at play here than the "order of elements" argument: 1. Associative arrays are conceptually like dictionaries. While they have an order in PHP, it is...

Also this events should be upgraded to new Event classes. https://github.com/yiisoft/db/blob/7aef171c019f943e26482ae69e9d8a50d9449845/src/Connection.php#L158 Is it \yii\db\ConnectionEvent class name right for this purpose ?

*@rustamwin commented on Oct 9, 2018, 10:23 AM UTC:* *This issue was moved by [samdark](https://github.com/samdark) from [yiisoft/yii-core#39](https://github.com/yiisoft/yii-core/issues/39).*

status:under discussion
type:feature