Schema::getTables
(No version information available, might only be in Git)
Schema::getTables — Get schema tables
Description
Avertissement
Cette fonction est actuellement non documentée ; seule la liste des arguments est disponible.
Liste de paramètres
Cette fonction ne contient aucun paramètre.
Valeurs de retour
Array of all tables in this schema, where each array element value is a Table object with the table name as the key.
Exemples
Exemple #1 mysql_xdevapi\Schema::getTables() example
<?php
$session = mysql_xdevapi\getSession("mysqlx://user:password@localhost");
$session->sql("DROP DATABASE IF EXISTS addressbook")->execute();
$session->sql("CREATE DATABASE addressbook")->execute();
$session->sql("CREATE TABLE addressbook.names(name text, age int)")->execute();
$session->sql("INSERT INTO addressbook.names values ('John', 42), ('Sam', 33)")->execute();
$session->sql("CREATE TABLE addressbook.cities(name text, population int)")->execute();
$session->sql("INSERT INTO addressbook.names values ('Portland', 639863), ('Seattle', 704352)")->execute();
$schema = $session->getSchema("addressbook");
$tables = $schema->getTables();
var_dump($tables);
?>Résultat de l'exemple ci-dessus est similaire à :
array(2) {
["cities"]=>
object(mysql_xdevapi\Table)#3 (1) {
["name"]=>
string(6) "cities"
}
["names"]=>
object(mysql_xdevapi\Table)#4 (1) {
["name"]=>
string(5) "names"
}
}
add a note
User Contributed Notes
There are no user contributed notes for this page.
