<?
$statement = $mysql->prepare("INSERT INTO main (player_name, player_class, level) VALUES (:name, :class, :level)");
$statement->execute(array(":name" => $_POST['ign'], ":class" => $_POST['p_class'], ":level" => $_POST['level']));
?>

butt dickus fucked around with this message at 16:35 on Jul 14, 2011

Goat Bastard fucked around with this message at 21:58 on Jul 14, 2011

UPDATE bib 
SET    TEXT = REPLACE(TEXT, (SELECT TEXT 
                             FROM   bib                           #Table that stores individual bibliographic records
                             WHERE  bib# IN (SELECT bib# 
                                             FROM   item          #Table that has individual item records with using bib# as a foreign key to the bib table
                                             WHERE  itype = 'a')  #Trying to specifically grab all instances of a particular type of item (book, dvd etc) then use stuff to                         
                                                                   updated the 7th chracter of the string "text" in the bib table.
                                    AND tag = '000'), (SELECT 
                            Stuff((SELECT TEXT 
                                   FROM   bib 
                                   WHERE  bib# IN (SELECT 
                                          bib# 
                                                   FROM 
                                          item 
                                                   WHERE 
                                          itype = 'a') 
                                          AND tag = '000'), 7, 1, 'a'))) 
WHERE  bib# IN (SELECT bib# 
                FROM   item 
                WHERE  itype = 'a') 
       AND tag = '000' 

MrDoDo fucked around with this message at 23:27 on Jul 14, 2011

ufarn fucked around with this message at 10:19 on Jul 17, 2011

folder subfolder key acct

key timestamp day metric

key timestamp day metric dmetric

key1   2011-07-21 8:01am   2011-07-21   100  20
key1   2011-07-21 2:29pm   2011-07-21   140  40

key1   <some ts, don't care>   2011-07-21   140  60

insert into A
  select key, day, metric, dmetric
  from (select F.key, day, RANK() OVER (PARTITION BY F.key, day ORDER BY timestamp DESC) as rank,
               FIRST_KEY(metric) OVER (PARTITION BY F.key, day),
               SUM(dmetric) OVER (PARTITION BY F.key, day)
        from S join F on S.key = F.key) as Z
  where rank=1;

insert into A
  select key, day, metric, dmetric
  from (select F.key, day, RANK() OVER (PARTITION BY F.key, day ORDER BY timestamp DESC, folder, subfolder) as rank,
               FIRST_KEY(metric) OVER (PARTITION BY F.key, day ORDER BY timestamp DESC),
               SUM(dmetric) OVER (PARTITION BY F.key, day ORDER BY timestamp DESC, folder, subfolder)
        from S join F on S.key = F.key) as Z
  where rank=1;

select F.key, day,
       FIRST_KEY(metric) OVER (PARTITION BY F.key, day ORDER BY timestamp DESC),
       SUM(dmetric) OVER (PARTITION BY F.key, day ORDER BY timestamp DESC)
from (select distinct key from S) as S` join F on S`.key = F.key) as Z

kimbo305 fucked around with this message at 23:31 on Jul 21, 2011

kimbo305 fucked around with this message at 05:18 on Jul 22, 2011

kimbo305 fucked around with this message at 05:46 on Jul 22, 2011

insert into A
  select key, day, metric, dmetric
  from (select key, 
               day,
               metric,
               SUM(dmetric) OVER (PARTITION BY key, day) dmetric, 
               RANK() OVER (PARTITION BY key, day ORDER BY timestamp DESC) as rank
        from S
       where key in (select key from F)) as Z
  where rank=1;

insert into A
  select key, day, metric, sum(dmetric) dmetric
  from (select key, 
               day,
               first_key(metric) over (PARTITION BY key, day ORDER BY timestamp DESC) metric,
               dmetric
        from S
       where key in (select key from F)) as Z
  group by key, day, metric;

Jethro fucked around with this message at 17:40 on Jul 22, 2011

SELECT *
FROM mydb
WHERE (((PKey1 = x1) AND (PKey2 = y1)) OR 
       ((PKey1 = x2) AND (PKey2 = y2)) OR
       ((PKey1 = x3) AND (PKey2 = y3)) OR
       ((PKey1 = x4) AND (PKey2 = y4)))

Rescue Toaster fucked around with this message at 19:51 on Jul 22, 2011

insert into A
  select key, day, metric, dmetric
  from (select F.key, day, RANK() OVER (PARTITION BY F.key, day ORDER BY timestamp DESC, folder, subfolder) as rank,
               metric,
               SUM(dmetric) OVER (PARTITION BY F.key, day, folder, subfolder)
        from S join F on S.key = F.key) as Z
  where rank=1;

kimbo305 fucked around with this message at 22:08 on Jul 22, 2011