    SELECT USER_ID, (CASE USER_ID WHEN 1 THEN 1 ELSE 0 END) as FIRST_USER FROM USER

    SELECT USER_ID, IF(USER_ID = 1, 1, 0) AS FIRST_USER FROM USER

The [IF()][1] statement works similarly to the ternary ? : operator.


  [1]: http://dev.mysql.com/doc/refman/5.1/en/control-flow-functions.html

Suppose I have a string &quot;AAA BBB CCC DDD EEE FFF&quot;.

How can I split the string and retrieve the nth substring, in a batch file?

The equivalent in C# would be

    &quot;AAA BBB CCC DDD EEE FFF&quot;.Split()[n]


How to split a string by spaces in a Windows batch file?

How can you clearly illustrate multiple threads of execution in a sequence diagram or similar diagram?  

I haven&#39;t been able to find any clear examples.  All diagrams I see are used to illustrate a single thread.

---

**Update**: The accepted answer was the best example I saw but it does leave a fair bit to be desired.  I ended up illustrating the threads in separate sequence diagrams.  I&#39;m not sure if the sequence diagram necessarily works for multiple threads.

How to illustrate multiple threads in sequence diagram?

I&#39;m using MySQL, and I want to do a sort of ternary statement in my SQL like:

    SELECT USER_ID, ((USER_ID = 1) ? 1 : 0) AS FIRST_USER
      FROM USER

The results would be similar to:

    USER_ID | FIRST_USER
    1       | 1
    2       | 0
    3       | 0
    etc.

How does one accomplish this?

How do you write a conditional in a MySQL select statement?

I'm using MySQL, and I want to do a sort of ternary statement in my SQL like:
<pre><code class="hljs language-sql">SELECT USER_ID, ((USER_ID = 1) ? 1 : 0) AS FIRST_USER
 FROM USER
</code></pre>
The results would be similar to:
<pre><code class="hljs">USER_ID | FIRST_USER
1 | 1
2 | 0
3 | 0
etc.
</code></pre>
How does one accomplish this?

The only thing I don&#39;t have an automated tool for when working with Oracle is a program that can create INSERT INTO scripts. 

I don&#39;t desperately need it so I&#39;m not going to spend money on it. I&#39;m just wondering if there is anything out there that can be used to generate INSERT INTO scripts given an existing database without spending lots of money.

I&#39;ve searched through Oracle with no luck in finding such a feature. 

It exists in PL/SQL Developer, but errors for BLOB fields.

Generating sql insert into for Oracle

Using the command:

    CREATE TABLE IF NOT EXISTS `test`.`t1` (
        `col` VARCHAR(16) NOT NULL
    ) ENGINE=MEMORY;

Running this twice in the MySQL Query Browser results in:

&gt;Table &#39;t1&#39; already exists Error 1050

I would have thought that creating the table &quot;IF NOT EXISTS&quot; would not throw errors. Am I missing something or is this a bug? I am running version **5.1**. Thanks.

MySQL &quot;CREATE TABLE IF NOT EXISTS&quot; -&gt; Error 1050

I&#39;ve got big (&gt;Mil rows) MySQL database messed up by duplicates. I think it could be from 1/4 to 1/2 of the whole db filled with them.
I need to get rid of them quick (i mean query execution time).
Here&#39;s how it looks:  
id (index) | text1 | text2 | text3  
text1 &amp; text2 combination should be unique,
if there are any duplicates, only one combination with text3 NOT NULL should remain. Example:  

    1 | abc | def | NULL  
    2 | abc | def | ghi  
    3 | abc | def | jkl  
    4 | aaa | bbb | NULL  
    5 | aaa | bbb | NULL  

...becomes:  

    1 | abc | def | ghi   #(doesn&#39;t realy matter id:2 or id:3 survives)   
    2 | aaa | bbb | NULL  #(if there&#39;s no NOT NULL text3, NULL will do)

New ids cold be anything, they do not depend on old table ids.  
I&#39;ve tried things like:

    CREATE TABLE tmp SELECT text1, text2, text3
    FROM my_tbl;
    GROUP BY text1, text2;
    DROP TABLE my_tbl;
    ALTER TABLE tmp RENAME TO my_tbl;

Or SELECT DISTINCT and other variations.  
While they work on small databases, query execution time on mine is just huge (never got to the end, actually; &gt; 20 min)

Is there any faster way to do that?  Please help me solve this problem.

MySQL remove duplicates from big database quick

How can one call a stored procedure for each row in a table, where the columns of a row are input parameters to the sp ***without*** using a Cursor?

SQL Call Stored Procedure for each Row without using a cursor

I want to list all sales, and group the sum by day.

    Sales (saleID INT, amount INT, created DATETIME)

NOTE: I am using SQL Server 2005.


SQL query to group by day

In reading &quot;High performance MySQL&quot; from O&#39;Reilly I&#39;ve stumbled upon the following

&gt; Another common garbage query is SET
&gt; NAMES UTF8, which is the wrong way to
&gt; do things anyway (it does not change
&gt; the client library&#39;s character set; it
&gt; affects only the server).

I&#39;m a bit confused, because I used to put &quot;SET NAMES utf8&quot; on the top of every script to let the db know that my queries are utf8 encoded.

Can anyone comment the above quote, or, to put it more formally, what are your suggestions / best practices to ensure that my database workflow is unicode-aware.

My target languages are php and python if this is relevant.

Whether to use &quot;SET NAMES&quot;

I&#39;m using PDO to insert a record (mysql and php)

    $stmt-&gt;bindParam(&#39;:field1&#39;, $field1, PDO::PARAM_STR);
    $stmt-&gt;bindParam(&#39;:field2&#39;, $field2, PDO::PARAM_STR);
    $stmt-&gt;execute();

Is there a way to know if it inserted successfully, for example if the record was not inserted because it was a duplicate?

Edit: of course I can look at the database, but I mean programmatic feedback.

PDO mysql: How to know if insert was successful

I have a Microsoft SQL Server 2008 query that returns data from three tables using a left outer join.  Many times, there is no data in the second and third tables and so I get a null which I think is the default for left outer join.  Is there a way to replace the default values in the select statement?  I have a workaround in that I can select into a table variable but it feels a little dirty.


    SELECT iar.Description, iai.Quantity, iai.Quantity * rpl.RegularPrice as &#39;Retail&#39;, 
	iar.Compliance FROM InventoryAdjustmentReason iar
    LEFT OUTER JOIN InventoryAdjustmentItem iai  on (iar.Id = iai.InventoryAdjustmentReasonId)
    LEFT OUTER JOIN Item i on (i.Id = iai.ItemId)
    LEFT OUTER JOIN ReportPriceLookup rpl on (rpl.SkuNumber = i.SkuNo)
    WHERE iar.StoreUse = &#39;yes&#39;

I would like the Quantity and RegularPrice to default to zero if possible.


Content Type	Original Author	Original Content on Stackoverflow
Question	Langdon	View Question on Stackoverflow
Solution 1 - Sql	x2.	View Answer on Stackoverflow
Solution 2 - Sql	Jason	View Answer on Stackoverflow

How do you write a conditional in a MySQL select statement?

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

How to illustrate multiple threads in sequence diagram?

How to split a string by spaces in a Windows batch file?

Attributions