Questions tagged [mysql-5]
Generic MySQL version 5 tag. Please use a mysql-5.x tag instead. Also tag with mysql for search purposes.
5
questions with no upvoted or accepted answers
2
votes
0
answers
122
views
Signal handler on mysql connection break
I want to know if there is any signal that I can catch by which I can know that my mysql connection with the server has broken in c programming? I know I can check at query time whether my connection ...
- 21
1
vote
0
answers
214
views
How to speed up this query
MySQL doesn't have nearest neighbor search so. So I try to come up with a "distance" that's reasonable so the number of returned query is around 20-200. That way innodb doesn't have to compute ...
- 1,365
1
vote
0
answers
2k
views
Tables don't exist after MySQL restart
I recently made changes to optimize performance for InnoDB engine-based DB and soon after when restarting I encounter into the following strange behavior:
I have some tables with data in them
I made ...
- 111
-1
votes
1
answer
1k
views
Mysql Select all Rows after nth Position
I wish to fetch all rows from table after the nth Position as i given offset value
my table like
id | Value
1 | A |
2 | B |
3 | C |
4 | D |
5 | E |
...
N | R |
I wants the 3rd row Data to ...
- 1
-1
votes
1
answer
2k
views
Calculating employee's work time
I need to store and analyze employee's work time.
Currently, I've developed this table structure
CREATE TABLE `hirefire` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`employeeid` int(10) ...
- 745