738 reputation
315
bio website noneatthemoment.de
location Germany
age 33
visits member for 2 years, 9 months
seen 1 hour ago

Dec
23
comment Sorting by two columns conditionally
@Bhargava When it solves your problem you should accept the answer by clicking the check to the left of the answer. This way others also know, that the issue is solved.
Dec
22
comment SELECT returning NULL always
Provide sample data (feel free to do this on sqlfiddle.com), or we can't really answer this. The most probable answer with this scarce information is, that you have an entry in your table where the uid = 0 and all other fields are null. That's it.
Dec
22
answered Sorting by two columns conditionally
Dec
16
awarded  Enthusiast
Dec
10
comment How do I create a user-defined aggregate function in MySQL (redux)?
Please don't add multiple answers, edit your first answer if it actually answers the question. If you want to add additional information to the question, edit the question. Here's a quick tour, of how this site works, in case you're interested :)
Dec
10
awarded  Popular Question
Dec
6
answered enum vs boolean in case of multiple yes/no fields
Dec
6
answered Restricting the # of Rows a User can return in a single query
Dec
5
reviewed No Action Needed ORA-39244:Event to disable dropping null bit image header during relational select
Dec
5
reviewed Reviewed Mysql fulltext index search returning weird result
Dec
4
reviewed Reviewed Does SQL/MED (ISO/IEC 9075-9) defines a writable foreign data wrapper interface
Dec
4
answered Single SQL query to retrieve data in a particular order (not ASC/DESC)
Dec
2
revised update column based on sum of data from another table
improved readability
Dec
2
reviewed No Action Needed SSAS / MDX Query - Need row total
Dec
2
reviewed Reviewed update column based on sum of data from another table
Dec
2
suggested approved edit on update column based on sum of data from another table
Dec
1
reviewed No Action Needed connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host
Dec
1
comment Enforce referential integrity for FriendRequest table that has UserA and UserB
What's the problem? Create two foreign key constraints on tble FriendRequest (referencing User). What doesn't?
Nov
28
reviewed Reviewed InnoDB inserts 100 times slower than SQL Server inserts
Nov
28
comment Stored Procedure count and list the occurrence using like from another table
You shouldn't store multiple values in one column. Read about normalization. Also you're doing a cross join. This is most probably not the result you're looking for. Read about joins, too.