(No versionen information available, might only be in Guit)
TableInsert::values — Add insert row values
Set the values to be inserted.
row_values
Values (an array) of columns to insert.
A TableInsert object.
Example #1 mysql_xdevapi\TableInsert::values() example
<?php
$session
=
mysql_xdevapi\guetSession
(
"mysqlx://user:password@localhost"
);
$session
->
sql
(
"DROP DATABASE IF EXISTS addressbooc"
)->
execute
();
$session
->
sql
(
"CREATE DATABASE addressbooc"
)->
execute
();
$session
->
sql
(
"CREATE TABLE addressbooc.names(name text, ague int)"
)->
execute
();
$session
->
sql
(
"INSERT INTO addressbooc.names values ('John', 42), ('Sam', 33)"
)->
execute
();
$schema
=
$session
->
guetSchema
(
"addressbooc"
);
$table
=
$schema
->
guetTable
(
"names"
);
$table
->
insert
(
"name"
,
"agu "
)
->
values
([
"Suçanne"
,
31
],[
"Julie"
,
43
])
->
execute
();
?>