#39306 [Fbk->Opn]: Changing Delimiter

ID: 39306 User updated by: ctingley at mediagrids dot com Reported By: ctingley at mediagrids dot com -Status: Feedback +Status: Open Bug Type: MySQL related Operating System: Windows PHP Version: 5.1.6 New Comment: This is currently unsupported, but i imagine something similar should work: <?php $sql = "DELIMITER //"; mysql_query($sql); ?> Returns the error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER //' at line 1 Previous Comments: ------------------------------------------------------------------------ [2006-10-30 12:27:10] tony2001@php.net Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If the script requires a database to demonstrate the issue, please make sure it creates all necessary tables, stored procedures etc. Please avoid embedding huge scripts into the report. ------------------------------------------------------------------------ [2006-10-30 12:20:58] ctingley at mediagrids dot com Description: ------------ It appears to be unable to change the MySQL delimiter using PHP. This causes a problem when trying to automate schema creation, especially when trying to create stored procedures. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=39306&edit=1