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 |
MySQL version 5.1 - please also tag with mysql for search purposes.
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;
+-------------+-------------+------+-----+------------- …
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 …
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 …