May
26
awarded Popular Question
Jun
7
answered search and replace html tags (with slashes) in sed
Jun
6
comment How to select tables that have different columns except for an id
I'd add a note, that if other columns' names are not distinguish, remember to add a table name or an alias, like: SELECT t1.id, t1.col1, t2.col1 FROM table1 t1 LEFT JOIN table2 t2 ....
Jun
6
answered How do I get a list of numbers in MySQL?
Jun
6
answered Borland C++ Builder 6 and string concatenation
Jun
5
answered Does ORDER BY apply before or after DISTINCT?
Jun
5
comment Mysql: Toggle value of int field under two conditions for UPDATE query
You could do unconditional update of inUse to 0 as a first query then insert with inUse=1. Are there any reasons not to do it this way?
Jun
5
comment Print elements in an array
I think your answer is better ;) The code is probably taken from an exam/test question with a conscious "defect". Both yours and mine suggestions are correct but this one says "you can't catch me".
Jun
5
answered query - select data by first inserted
Jun
5
answered C To MIPS - translate a simple code
Jun
5
awarded Supporter
Jun
5
awarded Teacher
Jun
5
answered MySQL and SQL Server terminology
Jun
5
answered Print elements in an array
May
19
revised Avoid showing empty page after unsuccessful authentication
added 12 characters in body
May
19
accepted How to use container-managed security with SPNEGO and Kerberos?
May
18
asked Avoid showing empty page after unsuccessful authentication
May
18
accepted Cannot deploy Java EE application referencing other EJB module
May
18
accepted DB constraint violation details from EJBException
Apr
10
revised DB constraint violation details from EJBException
added 44 characters in body; edited tags
1 2