Andrew

Albuquerque, NM

atomodo.com

Age: 45

Art major accidentally finds career in IT.

1h
comment Bulk insert CSV error
Maybe see stackoverflow.com/questions/479819/… for CHR(10) trick.
1h
comment Query to determine Task Concurrency
Might get you started: sqlfiddle.com/#!3/beb7a/12/0
May
2
comment D3 force layout by node size
I think you were pretty close - try what you did w charge() for gravity().
Apr
30
comment If then else within a select
@ypercube okaaaaaaay :)
Apr
30
answered If then else within a select
Apr
16
comment Synchronizing between DATETIME and TIMESTAMP
Sorry- it worked for me on the latest version. See here stackoverflow.com/questions/4489548/… for some ideas for a solution to #1293.
Apr
15
answered Synchronizing between DATETIME and TIMESTAMP
Apr
10
comment An auto-increment column or the UNIQUE constraint?
stackoverflow.com/questions/3747730/…
Mar
26
comment Update or insert element into xml column dependent on existence
It might be faster to do the insert first, then do the replace on the entire table leaving off the WHERE clause and saving the cost of one exist check. I think you'd have to write a procedure to be able to use your IF THEN ELSE logic.
Mar
26
comment Binding multiple items of data from SQL to label
I meant that I edited my answer. Let me know if the new version still has the error.
Mar
26
comment Binding multiple items of data from SQL to label
changed "lbl1" to "course.lbl1" in second line.
Mar
26
revised Binding multiple items of data from SQL to label
added 7 characters in body
Mar
26
answered Update or insert element into xml column dependent on existence
Mar
26
answered Binding multiple items of data from SQL to label
Mar
15
awarded Autobiographer
Mar
12
answered Join Query for autocomplete in mysql
Mar
5
comment Retrieving an particular element from JSONArray
o.getJSONArray(2).getString(0)
Mar
5
answered Hive (or MySQL): Finding event of different type with maximum timestamp
Mar
5
comment javascript d3.js date string parsing issue
You might not need the [+] in [+%Z]. Try ["%Y-%m-%d_%H:%M:%S%Z"]
Mar
4
awarded Caucus
1 2 3 4 5