how to execute mysql command DELIMITER

by

You probably don’t need to change the delimiter.

The delimiter is needed in the CLI to tell where the SQL statement ends, because the CLI is going to keep reading and executing more statements until you tell it to stop (e.g., with exit or Control-D). But what it actually reads is just a stream of characters; it somehow needs to figure out where one statement ends and the next starts. That’s what the delimiter does.

In PHP, each function call executes one statement. There can’t be multiple statements in one function call, so there is no need for a way to delimit them. The statement is the entire string. This is true of the old mysql_query as well as the newer mysqli_query and PDO. Of course, there is mysqli_multi_query if you really want to pass multiple queries to one function.

In the case of a stored procedure/trigger/function/etc., there can be multiple statements, but that’s handled by MySQL itself (and is always ;, AFAIK). So as far as PHP is concerned, that’s still one statement.

The delimiter setting you’re seeing in phpMyAdmin is probably being used to split statements apart, and is probably being done in PHP code. It has to do this because it is accepting user input consisting of multiple statements, but must pass only one statement per function call. (I haven’t checked the phpMyAdmin code to be completely sure of this).

More Related Contents:

  1. Using PHP data in MySQL [closed]
  2. Checking the availability of rooms
  3. How to sort user data by id
  4. Select those record only from table 1 where city exist against state id in table 2 in PHP
  5. PHP PDO prepared statements
  6. mysqli::query(): Couldn’t fetch mysqli
  7. select count(*) from table of mysql in php
  8. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  9. Loading .sql files from within PHP
  10. Incorrect Integer (2147483647) is inserted into MySQL?
  11. I need my PHP page to show my BLOB image from mysql database
  12. Cannot connect to MySQL 4.1+ using old authentication
  13. Delete multiple rows by selecting checkboxes using PHP
  14. Object of class DateTime could not be converted to string
  15. PHP Commands Out of Sync error
  16. PHP MYSQL UPDATE if Exist or INSERT if not?
  17. how to check and set max_allowed_packet mysql variable [duplicate]
  18. mysql_real_escape_string VS addslashes
  19. PHP: multiple SQL queries in one mysql_query statement
  20. MySql Error: 1364 Field ‘display_name’ doesn’t have default value
  21. Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted
  22. Codeigniter Transactions
  23. PDO::rowCount VS COUNT(*)
  24. How can I select rows in MySQL starting at a given row number?
  25. how to fetch all the row of the result in php mysql?
  26. Coverting Hex to Image in PHP?
  27. Create a Insert… Select statement in Laravel
  28. php/mysql zip code proximity search
  29. php connection pooling mysql [duplicate]
  30. Limit pagination page number

Leave a Comment