|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2013-04-03 00:09 UTC] jehoshua02 at gmail dot com
Description: ------------ I'm using PDO in some simple script to do database migrations and realized that my triggers weren't being created. I checked to make sure the triggers were correct by first copying and pasting them into mysql interactive console, then by using `SOURCE ...`, then by passing the file name into mysql command, each time verifying the trigger was created by using "SHOW TRIGGERS WHERE `Trigger` = :trigger". I concluded that the problem was not with my trigger statements, or with mysql, but with PDO. The actual PHP version is 5.4.6-1ubuntu1.2 so I chose the closest one. Test script: --------------- https://gist.github.com/jehoshua02/5297332 Expected result: ---------------- I would expect to see the trigger printed as an associative array. Actual result: -------------- The trigger is not created even though the script completes without any errors or exceptions. PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Mon Oct 27 21:00:02 2025 UTC |
DELIMITER is not a mysql statement, but a mysql client command. Use a separated statement for create trigger part. e.g. $pdo->query("CREATE TRIGGER ...");This should actually be $pdo->exec('CREATE TRIGGER...');