MySQL Forums :: Newbie :: SQL instructions enclosed in "/*! ... */"


Advanced Search

SQL instructions enclosed in "/*! ... */"
Posted by: Pepi Lepioux ()
Date: July 26, 2012 07:31AM

Hello,

I use MySQLDump to transfer a database.
In the output file I can see lines like :
/*!50003 CREATE*/ /*!50017 DEFINER=`user`@`localhost`*/ /*!50003 TRIGGER `ai_stats_cat` AFTER INSERT ON `stats_cat`
FOR EACH ROW BEGIN ,etc.

Il searched the doc for this (strange) syntax but couldn't find anything (except that /* */ are comment delimiters. But in fact these commands are executed when I use this file as input for mysql).

Could anyone please give me a link to an explanation about these /*! ? (ever tried to google "/*!" ? )


Thank you

Options: ReplyQuote


Subject Written By Posted
SQL instructions enclosed in "/*! ... */" Pepi Lepioux 07/26/2012 07:31AM
Re: SQL instructions enclosed in "/*! ... */" Peter Brawley 07/26/2012 10:46AM
Re: SQL instructions enclosed in "/*! ... */" Pepi Lepioux 07/26/2012 02:41PM
Re: SQL instructions enclosed in "/*! ... */" Peter Brawley 07/26/2012 02:43PM
Re: SQL instructions enclosed in "/*! ... */" Barry Galbraith 07/26/2012 03:46PM
Re: SQL instructions enclosed in "/*! ... */" Peter Brawley 07/26/2012 07:18PM
Re: SQL instructions enclosed in "/*! ... */" Barry Galbraith 07/26/2012 07:31PM
Re: SQL instructions enclosed in "/*! ... */" Peter Brawley 07/26/2012 07:38PM
Re: SQL instructions enclosed in "/*! ... */" Barry Galbraith 07/26/2012 08:11PM
Re: SQL instructions enclosed in "/*! ... */" Peter Brawley 07/26/2012 11:49PM
Re: SQL instructions enclosed in "/*! ... */" Barry Galbraith 07/26/2012 11:55PM
Re: SQL instructions enclosed in "/*! ... */" Peter Brawley 07/27/2012 08:27AM
Re: SQL instructions enclosed in "/*! ... */" Barry Galbraith 07/27/2012 06:59PM
Re: SQL instructions enclosed in "/*! ... */" Rick James 07/29/2012 08:58AM
Re: SQL instructions enclosed in "/*! ... */" Pepi Lepioux 08/02/2012 10:26AM
Re: SQL instructions enclosed in "/*! ... */" Peter Brawley 08/02/2012 11:11AM
Re: SQL instructions enclosed in "/*! ... */" Pepi Lepioux 08/04/2012 07:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.