Re: MySQL Function Naming

A. Pagaltzis writes: > Now granted, v5 has finally added a strict mode or whatever it's > called, where this kind of constraint violation throws an error > instead of silently mangling your data. But IT TOOK THEM FIVE VERSIONS > to put that in, AND THEN IT'S STILL NOT THE DEFAULT. Ah, yes, the "ve

Re: MySQL Function Naming

> Also that the case-sensitivity of the table and database names should be > determined by the underlying filesystem because the idea of lower- casing the > name before using it as a filename was just beyond them. God help you if you write a database application with a table called (e.g.) "

Re: MySQL Function Naming

Aaron Crane wrote: > I'm prepared to believe that this is merely a bug in our particular > point-release of the server, rather than a fundamental design flaw, but > that doesn't stop it being incredibly hateful: if I'm looking for > something equal to an exemplar, then, no, something vaguely simila

Re: MySQL Function Naming

* Aaron Crane [2007-03-20 15:15]: > I'm prepared to believe that this is merely a bug in our > particular point-release of the server, rather than a > fundamental design flaw, but that doesn't stop it being > incredibly hateful: if I'm looking for something equal to an > exemplar, then, no, someth

Re: MySQL Function Naming

I stopped reading after the first word in the subject. Too easy to hate. Some hates-software mail just writes itself, -- Aristotle Pagaltzis //

Re: MySQL Function Naming

Smylers wrote: The one in which you specify an index is called Substring(). The one in which instead of an index you specify a delimiter is called ... wait for it ... Substring_Index(). Well, "MySQL" is not much of a name by itself, so it's just being consistent. Although the even more cons

Re: MySQL Function Naming

Smylers writes: > MySQL has a couple of functions for extracting a substring from > a string. The one in which you specify an index is called > Substring(). The one in which instead of an index you specify > a delimiter is called ... wait for it ... Substring_Index(). Ah, yes. MySQL: The DBMS

MySQL Function Naming

MySQL has a couple of functions for extracting a substring from a string. They differ in how the substring is selected -- in one of them you specify a delimiter string, and in t'other you specify the index of the first character you want. The one in which you specify an index is called Substring(