Michael - sqlbot's user avatar
Michael - sqlbot's user avatar
Michael - sqlbot's user avatar
Michael - sqlbot
  • Member for 10 years
  • Last seen more than a month ago
  • Cincinnati, OH
26 votes
10 answers
73k views

Any option for mysqldump to ignore databases for backup?

  • 697
23 votes
2 answers
40k views

SQL Server Join/where processing order

22 votes
3 answers
40k views

How to determine master in mysql master-slave

21 votes
3 answers
40k views

What's the difference between POINT(X,Y) and GeomFromText("POINT(X Y)")?

  • 313
17 votes
1 answer
126k views

MySQL 5.6 DateTime Incorrect datetime value: '2013-08-25T17:00:00+00:00' with Error Code 1292

  • 273
16 votes
1 answer
21k views

Autoincrement primary key in CREATE TABLE ... AS SELECT

15 votes
3 answers
34k views

Why does MySQL ignore the index even on force for this order by?

  • 953
11 votes
1 answer
13k views

Qcache_free_memory not full yet I get alot of Qcache_lowmem_prunes

  • 1,432
6 votes
1 answer
10k views

How to choose a good value for MySQL relay-log-space-limit?

6 votes
2 answers
5k views

How do uninitialized variables differ from NULL in Mysql?

  • 796
6 votes
1 answer
6k views

Prepared statement execution with variable number of parameters to be bound

6 votes
1 answer
32k views

Query to compare two subsets of data from the same table?

  • 187
5 votes
1 answer
5k views

InnoDB "corruption"

  • 51
4 votes
0 answers
2k views

Galera Cluster Failed to report last committed

4 votes
1 answer
1k views

Will creating a view on a MySQL replication slave break the replication?

3 votes
1 answer
366 views

MySQL Replication not proceeding

  • 5,163
3 votes
2 answers
3k views

MySQL bin log missing data?

  • 31
3 votes
1 answer
2k views

Fast query, in theory using index, still in the slow-query log

3 votes
1 answer
984 views

"Set Password" with a limited user

3 votes
1 answer
6k views

Using Workbench to export. Views no longer work

3 votes
1 answer
4k views

MySQL SELECT query hangs - Opening Tables INNODB

3 votes
1 answer
1k views

MySQL/MariaDB stored procedure compiles with typos

  • 171
3 votes
2 answers
704 views

Can I configure MySQL's typecasting to consider 0 != 'foo'?

3 votes
1 answer
1k views

MySQL user is not expired but asking for Password RESET

3 votes
1 answer
2k views

Why is InnoDB auto_increment column skipping over large blocks of unused values?

  • 133
2 votes
1 answer
166 views

Make sure slave has finished reading from master

2 votes
1 answer
14k views

MySQL query to evaluate ranges in date and time elements of a datetime column separately

2 votes
3 answers
552 views

Does MySQL 5.6 support fan-in replication?

  • 359
2 votes
2 answers
194 views

Logging only mySQL logins on heavily used system

2 votes
1 answer
441 views

Is DETERMINISTIC NO SQL function which returns the same value always a good alternative for using as a constant in MySQL?

  • 149