Forum PHP.pl

[SQL] pobierz, plaintext 
DELIMITER |
CREATE PROCEDURE tomcio()
BEGIN DELETE FROM np_klienci; END|
DELIMITER ;
[SQL] pobierz, plaintext 

#1064 - 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 |
CREATE PROCEDURE tomcio()
BEGIN DELETE FROM np_klienci' at line 1

[PHP] pobierz, plaintext 
<?php
$query = "DELIMITER |";
$result = mysql_query($query);
echo mysql_error();
$query = "CREATE PROCEDURE tomcio()
BEGIN
DELETE FROM np_klienci;
END|";
$result = mysql_query($query);
echo mysql_error();
 
$query = "DELIMITER ;";
$result = mysql_query($query);
echo mysql_error();
?>
[PHP] pobierz, plaintext 

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 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '//' at line 4You 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