Jehad Keriaki's user avatar
Jehad Keriaki's user avatar
Jehad Keriaki's user avatar
Jehad Keriaki
  • Member for 8 years, 11 months
  • Last seen this week
13 votes
Accepted

mysql - unique index with nulls - actual solution anyone?

9 votes
Accepted

grant select on all databases except one mysql

9 votes

Identify slow query without slow query logs in mysql server

6 votes
Accepted

Is mysqldump a "hot" backup kind?

5 votes
Accepted

INSERT of 1 wrong value -> Error; INSERT of 2 wrong values -> Warning!

5 votes
Accepted

inner join on true

4 votes

Convert MyISAM to InnoDB

4 votes

Is binary logs required on the slave in order to do replication?

4 votes

How to find the nth highest salary in SQL?

4 votes
Accepted

HA - MySQL Master Master replication - Duplicate entry errors

4 votes
Accepted

Which is better MAX function or ORDER BY column_name DESC with LIMIT 1

4 votes
Accepted

Missing commands in MySQL command line history

3 votes
Accepted

MySQL - Large Table best practices/indexes

3 votes

Best practice to delete big portion of big mysql table

3 votes

Does the order of the column name assignation in the join part have an impact on indexes in MySQL?

3 votes

How to select status variables into temp variables in mysql

2 votes

Select only rows with at least 2 non-missing values

2 votes
Accepted

I'm seeing inconsisntecies in table data after exporting from one server and importing to another, why is this?

2 votes
Accepted

MySql - Ranking so it only needs to be done once

2 votes
Accepted

Importing from CSV file, is crashing mysql server

2 votes
Accepted

How to debug huge binary log file increases in MySQL replication setup?

2 votes

Error Referencing wp_users as Foreign Key

2 votes

selecting all row of max value of a column

2 votes

improve mysql query in large tables

2 votes
Accepted

Shouldn't mysql be using both indexes in a join?

2 votes

How to query if record exists for prior month in mysql

2 votes

Select results inclusively based on NOW()

2 votes
Accepted

Should I store data pre-ordered rather than ordering on the fly?

2 votes

Optimal SQL solution

2 votes
Accepted

mysql load data local infile is skipping the 1st column of the 1st row

1
2 3 4 5