lawpoop's articles:

Items(88) /9 Next >> Last >|

Implementing a versioning system for sets? 1 122 (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

guarantee child records either in one table or another, but not both? 20 184 (3/12/2010 3:42:45 PM) comp.databases.mysql I have a table with two child tables. For each record in the parent table, I want one and only one record in one of the child tables -- not one in each, not none. How to I define that? Here's the backstory... steve

SELECT NOT IN() -- disjoint set? 3 227 (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? 9 142 (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? 5 325 (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? 2 49 (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 concatenation 15 22 (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? 5 26 (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? 5 48 (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? 18 69 (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

lawpoop's replies:

Items(60) /6 Next >> Last >|

concat function, not operator? 5 28 (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? 18 69 (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 #2 8 20 (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? 5 48 (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 DELETE 31 41 (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? 76 58 (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? 5 26 (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 concatenation 15 22 (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? 2 49 (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? 8 220 (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