*** 5,12 ****
----
! *: Extended POSIX regular expressions (should be easy, man 3 regcomp, or http://
! mirbsd.bsdadvocacy.org/man3/regcomp.htm for reference)
SELECT * FROM table WHERE name REGEX '[a-zA-Z]+_{0,3}';
*: The EXISTS keyword is not supported (IN is, but IN is only a special case of EXISTS). And what about
--- 5,11 ----
----
! *: Extended POSIX regular expressions (should be easy, man 3 regcomp, or http://mirbsd.bsdadvocacy.org/man3/regcomp.htm for reference)
SELECT * FROM table WHERE name REGEX '[a-zA-Z]+_{0,3}';
*: The EXISTS keyword is not supported (IN is, but IN is only a special case of EXISTS). And what about
***************
*** 35,43 ****
*: Rollup and Cube - _Who can tell me what this means?_
! _::: I don't know much about it myself, but a quick google on the subject gives me... http://
! www.winnetmag.com/SQLServer/Article/ArticleID/5104/5104.html and http://databases.about.com/
! library/weekly/aa070101a.htm
_::: both of these imply that the CUBE operator causes new rows to be generated to give a wildcard
value to non-numeric columns and summing the numeric columns which match those wildcards. The
--- 34,40 ----
*: Rollup and Cube - _Who can tell me what this means?_
! _::: I don't know much about it myself, but a quick google on the subject gives me... http://www.winnetmag.com/SQLServer/Article/ArticleID/5104/5104.html and http://databases.about.com/library/weekly/aa070101a.htm
_::: both of these imply that the CUBE operator causes new rows to be generated to give a wildcard
value to non-numeric columns and summing the numeric columns which match those wildcards. The
***************
*** 203,210 ****
sequence_value bigint not null default 1
)
! _:In fact, why don't you just take a look at the original module (DBIx::MySQLSequence): http://
! search.cpan.org/~adamk/DBIx-MySQLSequence-0.1/MySQLSequence.pm. In fact, why don't you just
copy that module, and rewrite using code inside the database.
_:The main reason for doing this, is that if you want to insert multiple records which reference each
--- 200,206 ----
sequence_value bigint not null default 1
)
! _:In fact, why don't you just take a look at the original module (DBIx::MySQLSequence): http://search.cpan.org/~adamk/DBIx-MySQLSequence-0.1/MySQLSequence.pm. In fact, why don't you just
copy that module, and rewrite using code inside the database.
_:The main reason for doing this, is that if you want to insert multiple records which reference each
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|