Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.
user avatar
user avatar
user avatar
Mihai
  • Member for 9 years, 4 months
  • Last seen more than a month ago
  • Romania
24 votes

Store output of sp_who2 in a table

9 votes
Accepted

Select Multiple Values from Same Column; one sql statment

7 votes
Accepted

Delete all the data from all tables

7 votes
Accepted

Why does this simple select statement require quotes?

7 votes

Is there any command to optimize all MySQL tables one by one automatically?

6 votes
Accepted

Constraint to prevent 'duplicates' only when column > 0

4 votes

Select random rows up to a limit

4 votes
Accepted

How to group by continuous days in mysql

3 votes

innodb DEPENDENT SUBQUERY very slow

3 votes

Can I use PHP function strtotime() in SQL queries?

3 votes
Accepted

select items with one or more specified tags

2 votes
Accepted

How to SELECT rows with time duration stored in varchar column?

2 votes

Pivot table with MySQL

2 votes
Accepted

How to sort words in a column in mysql?

2 votes

How can i return the date of max id?

2 votes
Accepted

MySQL FULL JOIN on same table

2 votes
Accepted

Want to write a trigger after UPDATE

1 vote
Accepted

Tricky condition for PostgreSQL UPDATE query

1 vote

Order By DateTime With 00:00:00 Last

1 vote

MySQL uses intersection instead compound index

1 vote

PostgreSQL get first letter of each word (except...)

1 vote
Accepted

Rank variable value in MySQL is always being set to null

1 vote

Need separate columns that calculate percentage

1 vote
Accepted

prepared statements are not inserted

1 vote

How can I efficiently search for all records from a given month, or a given year?

1 vote

How to UPDATE MAX and MIN of a GROUP BY?

1 vote
Accepted

SQL Delete rows where a dataname will equal mulitple variables

1 vote
Accepted

Order result by number of occurence of a word in a text

1 vote
Accepted

MYSQL REGEXP for text not between parentheses

1 vote
Accepted

Coalesce per row - get all Detail IDs grouped per HeaderRow e.g. Invoice1 | 1,2,3 Invoice 2 | 4,5,6