All Questions
5 questions
0
votes
2
answers
452
views
Mysql Update with selection min/max count group
i have a simple table like this:
id grouped type_error
-- ------- ------------------
1 1-0 TL
2 1-0 TL
3 1-0 TL
4 1-1 TL
5 ...
- 682
4
votes
1
answer
1k
views
Using MIN() in SET statement MySQL
I am using MySQL. Lets call a table that I have as Inventory which looks is below:
+----+--------+--------+-------------+----------+
| ID | Price1 | Price2 | TargetPrice | Quantity |
+----+--------+--...
- 364
0
votes
1
answer
1k
views
MySQL update query with where condition only updating one record
I have two tables:
Product details - For storing product information.
Product Listings - For multiple copies that may be sold by different users.
I'm using this select query to gather the lowest ...
1
vote
1
answer
148
views
Update table with MAX() and MIN() from another table + performance problems
I have a problem that i have tried to solve for the last 2 days, i have 2 tables, workspat and xtractor_wrk.
xtractor_wrk contains 250000 rows and workspat contains 67 million rows.
CREATE TABLE `...
- 11
0
votes
1
answer
2k
views
Update with a Min in the table
I want to update a Column in a Table, based on the minimum of another column of the same table.
eg.
JobPositonId | JobPositonName | JobDescriptionId | ContactId
1 | 1 | 1 ...
- 624