Implementing a versioning system for sets?1122 (4/12/2010 6:09:54 PM) comp.databases.mysql I'm working on a web app for a quality control checklist. I already
have a table set up, but I have a hunch that our model is sub-optimal
and I could get some better performance.
Each checklist has dozens,... steve
SELECT NOT IN() -- disjoint set?3227 (2/11/2010 6:05:55 PM) comp.databases.mysql Hello, I'm having a problem getting a query to work, which I think
should work. It's in the form
SELECT DISTINCT a, b, c FROM t1 WHERE NOT IN ( SELECT DISTINCT a,b,c
FROM t2 ) AS alias
But mysql chokes ... steve
Get resource usage of query?9142 (12/3/2009 8:37:16 PM) comp.databases.mysql Is there a command to see how much total resources were used to
construct a result set?
I have some reports I'm running in php, and on my web host, the report
dies when I have a large data set. The reports... lawpoop
select `Field` from show columns?5325 (11/19/2009 3:24:06 PM) comp.databases.mysql How come this query doesn't work?
SELECT `Field` FROM ( SHOW COLUMNS FROM Cards ) AS alias
I don't want all the columns that SHOW COLUMNS returns, just `Field`.
... lawpoop
DELETE through JOIN?249 (10/29/2009 2:16:59 PM) comp.databases.mysql I have a database where the tables are in MyISAM. I have a situation where I need to delete 'grandchild' records. I was thinking it was possible to do a delete on a table, and specify a WHERE clause for a valu... lawpoop
variable concatenation is faster than inline concatenation1522 (10/26/2009 6:51:50 PM) comp.lang.php Sometimes in creating long strings, I go back and forth between concatenating values, such as $value .= "..."; $value .= "..."; and doing it inline, thusly: $value = "..." . "..."; Doing a simple test, I f... lawpoop
decorator versus child class?526 (10/23/2009 6:57:42 PM) comp.lang.php When does one use a decorator class versus a child class? I'm kind of new to this, and my current thought is that a decorator is used to temporarily 'decorate' an existing class in code, while the child class h... lawpoop
efficient way to get GROUP BY values and break down?548 (9/23/2009 3:36:41 PM) comp.databases.mysql Hello - I'm working on a report that has, for a set of records, report totals, grand totals, totals, sub-totals, etc, to an almost row-by-row breakdown of data. Each data piece -- total, sub-total, breakdown, ... lawpoop
query for fully qualified field names?1869 (9/16/2009 3:39:44 PM) comp.databases.mysql Is there a way to get MySQL to return a record set that has fully qualified field names? For instance, I have a parent and a child table that both have an 'id' column. I fully qualify the field names in the SEL... lawpoop
concat function, not operator?528 (9/9/2009 2:43:12 PM) comp.lang.php Is there a built-in concatenation function, not just the operator? I want to use concatenation in array_map, but I think I need a function name to do so. So, I would have to write my own simple concat() functio... lawpoop(267)
query for fully qualified field names?1869 (9/16/2009 3:39:44 PM) comp.databases.mysql Is there a way to get MySQL to return a record set that has fully qualified field names? For instance, I have a parent and a child table that both have an 'id' column. I fully qualify the field names in the SEL... lawpoop(267)
Another newbie question #2820 (9/20/2009 8:59:30 AM) comp.lang.php I want to be able to preview my php enabled pages as I edit them on my home PC. What all do I need to install? I *do not* want to host a web server from my home PC where anyone can access it. Thanks! Windows X... mikh2161(9)
efficient way to get GROUP BY values and break down?548 (9/23/2009 3:36:41 PM) comp.databases.mysql Hello - I'm working on a report that has, for a set of records, report totals, grand totals, totals, sub-totals, etc, to an almost row-by-row breakdown of data. Each data piece -- total, sub-total, breakdown, ... lawpoop(267)
Awful performance of mysql during DELETE3141 (10/5/2009 2:23:29 PM) comp.databases.mysql I have a website with several tables. One table "bincache" is a pile of stuff that is hard to compute and is stored for easy retrieval to avoid recomputation. The table is not linked to anything. It is kind... Ignoramus14280
one table database?7658 (10/13/2009 1:38:59 PM) comp.databases.mysql I have a simple tracking application that seems to only require one table with fields that can be updated and tracked. So far I can see no reason for any other tables, because even the status fields are bina... nospam278(83)
decorator versus child class?526 (10/23/2009 6:57:42 PM) comp.lang.php When does one use a decorator class versus a child class? I'm kind of new to this, and my current thought is that a decorator is used to temporarily 'decorate' an existing class in code, while the child class h... lawpoop(267)
variable concatenation is faster than inline concatenation1522 (10/26/2009 6:51:50 PM) comp.lang.php Sometimes in creating long strings, I go back and forth between concatenating values, such as $value .= "..."; $value .= "..."; and doing it inline, thusly: $value = "..." . "..."; Doing a simple test, I f... lawpoop(267)
DELETE through JOIN?249 (10/29/2009 2:16:59 PM) comp.databases.mysql I have a database where the tables are in MyISAM. I have a situation where I need to delete 'grandchild' records. I was thinking it was possible to do a delete on a table, and specify a WHERE clause for a valu... lawpoop(267)
dump all mysql tables into separate files automagically?8220 (9/9/2010 1:57:51 PM) comp.databases.mysql I'd like to get dumps of each mysql table into separate files. The
manual indicates that the syntax for this is
mysqldump [options] db_name [tbl_name ...]
Which indicates that you know the table names be... steve