db
db copied to clipboard
Yii Database Library
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).*