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-5.1
Search options not deleted
user 26002
MySQL version 5.1 - please also tag with mysql for search purposes.
1
vote
1
answer
225
views
Conditional Counting
I'm analyzing a database of login records for a university and I'm trying to write a query that will give me an idea as to how many users are using the labs for short bursts, verse a more extended sta …
- 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
0
votes
2
answers
54
views
Calculating the number of times a group occures
I'm trying to figure out how many times in my database a particular grouping has occurred. I have two relevant tables.
mysql> describe logins;
+-------------+-------------+------+-----+------------- …
- 319