Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with mysql
Search options not deleted
user 26002
All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.
1
vote
1
answer
31
views
MySQL Grouping Error
I'm trying to run a query on a table to see how many unique users have a usage record in the system at a given point. I've been working with the following query, but I've yet to see a proper result.
…
- 319
1
vote
2
answers
307
views
Sub-query in update function
I have a really terrible set of data that I've inherited and part of my job is going through and cleaning it up to something that's actually usable. Currently, I'm trying to update a column in my tab …
- 319
3
votes
MySQL Count Rows with Two Cells the same
What about something like:
select
height || 'x' || width as dimensions,
count(*) as number_of_banners
from
rv_banners
group by
height, width ;
- 319
1
vote
1
answer
340
views
MySQL Function Error
In an inherited database I have two tables of current interest, records and logins. login tells me the location of the user and where and when his login occured (in and out times included).
The fun …
- 319
1
vote
1
answer
75
views
Condense Query Results with Wildcard
I have the following query:
select programVersion, count(programVersion)
from records R
inner join Programs P
on P.programID=R.usageProgramID
where programName="word"
…
- 319
0
votes
1
answer
54
views
Query Optimization for added value
I have a query that's behaving a bit oddly. In my database I have a table called "records". It tells me a bunch of information about what applications a user ran on my company's machines. I'm tryin …
- 319
0
votes
2
answers
54
views
Calculating the number of times a group occures
mysql> describe logins;
+-------------+-------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------ … I can use:
mysql> select distinct programName from login_apps where sid="35" and programName! …
- 319
1
vote
MySQL can take more than an hour to start
It sounds like your database administrator has set the innodb_stats_persistent= value to OFF. Change this value to ON, and do a restart. The restart will take a long time as normal, but the following …
- 319