What does DELIMITER // do in a Trigger?

by

It changes the statement delimiter from ; to //. This is so you can write ; in your trigger definition without the MySQL client misinterpreting that as meaning you’re done with it.

Note that when changing back, it’s DELIMITER ;, not DELIMITER; as I’ve seen people try to do.

More Related Contents:

  1. Find records from one table which don’t exist in another
  2. How to use GROUP BY to concatenate strings in MySQL?
  3. Best way to test if a row exists in a MySQL table
  4. Comparing date ranges
  5. Delete from two tables in one query
  6. Fulltext Search with InnoDB
  7. MySQL’s now() +1 day
  8. Rewriting mysql select to reduce time and writing tmp to disk
  9. Can you access the auto increment value in MySQL within one statement?
  10. Which SQL query is better, MATCH AGAINST or LIKE?
  11. Maintaining order in MySQL “IN” query
  12. Does Mysql have an equivalent to @@ROWCOUNT like in mssql?
  13. How do you version your database schema? [closed]
  14. MySQL, Get users rank
  15. How to create a multi-tenant database with shared table structures?
  16. MySQL #1140 – Mixing of GROUP columns
  17. MySQL: GROUP_CONCAT with LEFT JOIN
  18. Boolean vs tinyint(1) for boolean values in MySQL
  19. MySQL: “The SELECT would examine more than MAX_JOIN_SIZE rows”
  20. Find rows that have the same value on a column in MySQL
  21. what is the difference between GROUP BY and ORDER BY in sql
  22. How to change string date to MySQL date format at time of import of CSV using MySQL’s LOAD DATA LOCAL INFILE
  23. What does collation mean?
  24. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  25. MySQL: Count records from one table and then update another
  26. COUNT(id) vs. COUNT(*) in MySQL
  27. sql pulling a row for next or previous row of a current row
  28. Row Rank in a MySQL View
  29. Select Rows with Maximum Column Value group by Another Column
  30. mysql GROUP_CONCAT duplicates

Leave a Comment