Is it not possible to run the "show create table __" via PDO? I swear I
was able to do this in the past, and for some reason this is not
working. Am I doing something wrong, is this a bug, or is this planned?
Pasted below is the mysql command and result expected, test code, and
its result.
-ralph
#### PROOF THE COMMAND WORKS
ralph@localhost ~/development/code/php5.1-200604220230 $ echo "show
create table blog_comments" | mysql -u root --password=xxxxxx test
Table Create Table
blog_comments CREATE TABLE `blog_comments` (\n `id` int(11) NOT NULL
auto_increment,\n `blog_entry_id` int(11) NOT NULL,\n `comment` text
NOT NULL,\n `comment_datetime` datetime NOT NULL,\n PRIMARY KEY
(`id`),\n KEY `FK_blog_comments_1` (`blog_entry_id`),\n CONSTRAINT
`FK_blog_comments_1` FOREIGN KEY (`blog_entry_id`) REFERENCES
`blog_entries` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n)
ENGINE=InnoDB DEFAULT CHARSET=utf8
#### THE TEST SCRIPT
ralph@localhost ~/development/code/php5.1-200604220230 $ cat
/home/ralph/development/vhosts/ralphschindler.com/development/test_show.php
<?
$db = new PDO("mysql:dbname=test", "root", "xxxxxx");
echo "\nTEST PREPARED-------\n";
try {
$stmt = $db->prepare("SHOW CREATE TABLE blog_comments");
$stmt->execute();
print_r($stmt); echo "\n";
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
print_r($result);
echo "no exceptions\n";
} catch (Exception $e) {
echo $e->getMessage();
echo "exception";
}
echo "\n\nTEST QUERY--------\n";
try {
$thing = $db->query("SHOW CREATE TABLE blog_comments");
print_r($thing); echo "\n";
echo "no exception\n";
} catch (Exception $e) {
echo $e->getMessage();
echo "exception";
}
#### TEST SCRIPT OUTPUT
ralph@localhost ~/development/code/php5.1-200604220230 $ ./sapi/cli/php
/home/ralph/development/vhosts/ralphschindler.com/development/test_show.php
TEST PREPARED-------
PDOStatement Object
(
[queryString] => SHOW CREATE TABLE blog_comments
)
Array
(
)
no exceptions
TEST QUERY--------
no exception
