network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 10 months |
| seen | May 8 at 17:58 | |
| stats | profile views | 31 |
|
Apr 24 |
comment |
update statement with self join @孔夫子, thanks. For some reason I thought that would cause a syntax error. However, for reference, that's not the sybase manual. It's the Sybase IQ manual, which is a different beast. Either way, it does seem to work. |
|
Apr 24 |
revised |
update statement with self join added 200 characters in body |
|
Apr 24 |
comment |
update statement with self join @JonSeigel, Thanks anyway :) |
|
Apr 24 |
comment |
update statement with self join @JonSeigel, specifying a table alias on the first line produces a syntax error. This does not. |
|
Apr 24 |
asked | update statement with self join |
|
Apr 11 |
revised |
Why use both TRUNCATE and DROP? deleted 4 characters in body |
|
Feb 25 |
awarded | Popular Question |
|
Nov 5 |
awarded | Notable Question |
|
Jul 28 |
awarded | Yearling |
|
Jul 3 |
comment |
Can MySQL reasonably perform queries on billions of rows? My company has multiple billion row tables that use sybase. Runs fine as long as you have the correct indexes and know how to look at a query plan. |
|
May 21 |
awarded | Good Question |
|
May 18 |
accepted | where clause short circuit? (sybase) |
|
May 18 |
accepted | Best way to work around NOT IN NULL issue? |
|
May 18 |
comment |
sybase format datetime yyyymmdd Yes, it does seem to be wrong for 112. I had already seen this, but assumed it wouldn't work for me. |
|
May 18 |
accepted | sybase format datetime yyyymmdd |
|
May 17 |
revised |
sybase format datetime yyyymmdd added 81 characters in body |
|
May 17 |
asked | sybase format datetime yyyymmdd |
|
May 3 |
comment |
Best way to work around NOT IN NULL issue? Is there any performance repercussion to doing so many sub-queries? Or will the server be smart enough to realize it doesn't need to be evaluated for each row of yourtable |
|
May 3 |
revised |
Best way to work around NOT IN NULL issue? deleted 4 characters in body |
|
May 3 |
revised |
Best way to work around NOT IN NULL issue? added 6 characters in body |
