*** 160,168 ****
_:_MEDIAN is difficult because it cannot be done "on-line," i.e., on a stream of data. Following is a
solution to MEDIAN credited to David Rozenshtein, Anatoly Abramovich, and Eugene Birger; it is
! explained_
! <HTML><A href="http://www.oreilly.com/catalog/transqlcook/chapter/ch08.html">here</A></
! HTML>
SELECT x.Hours median
FROM BulbLife x, BulbLife y
--- 160,166 ----
_:_MEDIAN is difficult because it cannot be done "on-line," i.e., on a stream of data. Following is a
solution to MEDIAN credited to David Rozenshtein, Anatoly Abramovich, and Eugene Birger; it is
! explained here: http://www.oreilly.com/catalog/transqlcook/chapter/ch08.html
SELECT x.Hours median
FROM BulbLife x, BulbLife y
***************
*** 205,213 ****
sequence_value bigint not null default 1
)
! _:In fact, why don't you just take a look at the original module <HTML><A href="http://
! search.cpan.org/~adamk/DBIx-MySQLSequence-0.1/MySQLSequence.pm">DBIx::MySQLSequence</
! A></HTML>. 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
other, and these references are not null, you cannot insert one record until you have inserted the one to
--- 203,209 ----
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
other, and these references are not null, you cannot insert one record until you have inserted the one to
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|