Insert.md

INSERT

Insert a row

$new_id = $query->insert('groups', [
    'name' => 'Moderator',
    'permissions' => 'moderator'
])->go();

Result query

INSERT INTO `groups` (`name`, `permissions`) VALUES ('Moderator', 'moderator');

Insert many rows

$query->insert('groups', [
	['name', 'role'],
	['Moderator', 'moderator'],
	['Moderator2', 'moderator'],
	['User', 'user'],
	['User2', 'user'],
])->go();

Result query

INSERT INTO `groups` (`name`, `role`)
VALUES ('Moderator', 'moderator'),
       ('Moderator2', 'moderator'),
       ('User', 'user'),
       ('User2', 'user');

To the UPDATE section

Back to doc index or readme