ID: 39306 Updated by: [EMAIL PROTECTED] Reported By: ctingley at mediagrids dot com -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: Windows PHP Version: 5.1.6 New Comment:
The delimiter has to be changed when using command line interface to MySQL. In PHP it's not required, stored procedures and functions can be created without changing it. Previous Comments: ------------------------------------------------------------------------ [2006-10-30 13:44:25] ctingley at mediagrids dot com 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 ------------------------------------------------------------------------ [2006-10-30 12:27:10] [EMAIL PROTECTED] 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
