i know sqlite and mysql are very different, but at sqlite i can create `native` functions at mysql only with plugins
since i like a lot mariadb, i think a plugin with many usefull functions could be enabled with some variable or some install plugin command that help a lot, some times for example the base64_encode/decode function was a verrrrry old feature that i reported to mysql maybe at 2004 or 2006, but only now (2013/2014) it`s inside mysql/mariadb code :( 2014-03-19 12:33 GMT-03:00 Reindl Harald <[email protected]>: > i feel like to comment mailing-list basics > > * DON'T top-post, you are destryoing threads > * DON'T convert plaintext posts to HTML > * DON'T reply-all, the reply button results in a off-list answer > > Am 19.03.2014 16:25, schrieb Peter Laursen: > > I feel like to comment here on "because it can't use indexes for such > things". > > This is not a serious reply IMO. It is just another way or saying > "Please shut up!" > > it is serious and don't insinuate words one have not said > there is a) no such function and b) no benefit of it > > > How many existing string functions ( > http://dev.mysql.com/doc/refman/5.6/en/string-functions.html) use an > index? > > Does "select concat('a','b');" do for instance? > > that does not read and seek anything in a column > frankly "select concat('a','b');" is the same as "ab" > > > I cannot think of any. And why do we have 'stored programs' if a > > database server should only do things that uses indexes? Does a > > WHILE-loop inside a stroed program use an index? > > surely can someone discuss what should be donme > > > Unlike most other RDBMS, MySQL has a tradition to do things in the > application thet other RDBMS would do in the > > database. But that traditions is/was because of lack of functionality in > the server before 5.0 (what is still the > > case in some respects. Try compare a MySQL TRIGGER with an Oracle or > SQL Server same, for instance). > > > > That said: this functionality can be implemented in a stored function > using existing string functions (or in the > > application, as sugggested) quite easily > > maybe > > > It is not possible (or desirable) to add build-in functions for > everything > > which was my point > > > And I have no clue is such string function exists in other RDBMS. > > unlikely > > > On Wed, Mar 19, 2014 at 4:03 PM, Reindl Harald > > <[email protected]<mailto: > [email protected]>> wrote: > > > > Am 19.03.2014 15:51, schrieb Roberto Spadim: > > > hi guys, i'm not finding a function to return how many character i > have, for example: > > > > > > "banana" > > > > > > i want a function that return 2 "n" characters, example: > > > substr_count("banana","n") => 2 > > > > > > sorry it a begginners question, but i didn't found it in > mysql/mariadb manual > > > > that is not the job of the database server because it > > can't use indexes for such things - just iterate > > the result and do it in the application > > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > > -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
