Sign upLogin

chrisandchris/passive-record-orm

View on GitHub
Star
doc/examples/insert with values.md

Summary

Maintainability
Test Coverage
# INSERT with values statement
## Simple example
SQL pendant

```sql
INSERT INTO `user` (username, password, salt) 
VALUES ('root', 'root', 'aa-bb-cc-dd');
```

With query builder

```php
$builder->insert('user')
->fieldlist([
    'username',
    'password',
    'salt'
], true)
->values([
    [
        'root',
        'root',
        'aa-bb-cc-dd'
    ]
]);
```

## Inserting multiple rows
SQL pendant

```sql
INSERT INTO `user` (username, password, salt) 
VALUES ('root', 'root', 'aa-bb-cc-dd'),
    ('admin', 'admin', 'cc-aa-bb-dd');
```

With query builder

```php
$builder->insert('usert')
->fieldlist([
    'username',
    'password',
    'salt'
], true);
->values([
    [
        'root',
        'root',
        'aa-bb-cc-dd',
    ],
    [
        'admin',
        'admin',
        'cc-aa-bb-dd'
    ]
]);
```