Tagged Questions

0
votes
1answer
24 views

Why does my MySQL database tables only exist on my Workbench?

I am developing my first php-MySQL system, but have a minimum of database experience. I have successfully created a schema with aproximately 10 tables, and the testings have so far worked fine. My ...
0
votes
1answer
44 views

Mysql query for latest value when date is missing

I have a table with a date and value column. The table is populated daily with new values. On occasion the population does not take place. I need to generate a report of the latest value on each past ...
1
vote
0answers
41 views

PHP accessing MySQL database correctly for some users, others missing some columns

I am at a loss for what is happening here -- because depending on which user I check, there isn't necessarily something wrong at all. Here's the database in question's structure: userID ...
0
votes
0answers
99 views

Select smallest value greater than x which meets specific condtions and then insert values into rows

I am working on a a (relatively) large table and am stuck with the following problem. What I am trying to do is to pick-up 'Value' from one table (table A) and putting them in another table (table B) ...
2
votes
3answers
131 views

Join/merge two tables, improvise/make up “missing” entries

I have two tables, tbl_foo and tbl_bar, and I want to join these tables with tbl_foo.foo_id = tbl_bar.foo_id in the on-clause. However, for each tbl_bar.baz_id there should be one row for each ...
0
votes
2answers
110 views

MySQL >, <, and missing by group

I have two tables in MySQL that I'm comparing with the following attributes: tbl_fac : facility_id, chemical_id, criteria 10 , 25 , 50 10 , 26 , 60 ...