Presumably this would work:

    IF(compliment = &#39;set&#39; OR compliment = &#39;Y&#39; OR compliment = 1, &#39;Y&#39;, &#39;N&#39;) AS customer_compliment

    IF(compliment IN(&#39;set&#39;,&#39;Y&#39;,1), &#39;Y&#39;, &#39;N&#39;) AS customer_compliment
Will do the job as [Buttle Butkus][1] suggested.


  [1]: https://stackoverflow.com/users/631764/buttle-butkus

A java String variable whose value is

    String path = &quot;http://cdn.gs.com/new/downloads/Q22010MVR_PressRelease.pdf.null&quot;

I want to remove the last four characters i.e., `.null`. Which method I can use in order to split.

Remove the last chars of the Java String variable

I am using simple_form gem, I have a countries collection, it work fine when I select the country, and updated record will have the country id stored, but, when I try to edit the record, the chosen country is not selected by default at edit form.

Here is the code at edit form:

    = f.input :country_id, :collection =&gt; all_countries
    
Shouldn&#39;t simple_form view the selected country from the db ?

rails, simple_form, how to set selected index of a collection when page loaded?

The following works - returns Y when chargeback equal to 1 else it defaults to N

    IF(fd.charge_back = 1, &#39;Y&#39;, &#39;N&#39;) AS charge_back

however I cannot seem to get this one working?  Is the syntax valid

    IF(compliment = (&#39;set&#39; OR &#39;Y&#39; OR 1), &#39;Y&#39;, &#39;N&#39;) AS customer_compliment



mysql SELECT IF statement with OR

The following works - returns Y when chargeback equal to 1 else it defaults to N
<pre><code class="hljs language-ini">IF(fd.charge_back = 1, 'Y', 'N') AS charge_back
</code></pre>
however I cannot seem to get this one working? Is the syntax valid
<pre><code class="hljs language-ini">IF(compliment = ('set' OR 'Y' OR 1), 'Y', 'N') AS customer_compliment
</code></pre>

I&#39;m writing a PHP application that will store `STUDENT` data in a MySQL relational database. I&#39;m trying to find the best way / datatype to store a month and year together without the day.

I don&#39;t know whether I should just store it as a DATE and use PHP someway to just store the day as the 1-st or use a different datatype that I&#39;m not currently familiar with. Ideally, I do not want to store a day, because the day will not always be the same and would require changing PHP source code if the day changed in the future.

Just for more background info, I&#39;m storing a STUDENT&#39;s `INTENT_TO_GRAD`. The client seems to only want this information as a reference or a visual for a report as opposed to using it for data manipulation. In other words, the only functional requirement for this data is to be displayed in a report.

MySQL datatype to store month and year only

In MySQL I am trying to copy a row with an **autoincrement** `column ID=1` and **insert** the data into same table as a new row with `column ID=2`.

How can I do this in a single query?

How to copy a row and insert in same table with a autoincrement field in MySQL?

What I need is to set the values of all the fields of a record with a particular key (the key is composite actually), inserting the record if there is no record with such a key yet.

&lt;a href=&quot;http://dev.mysql.com/doc/refman/5.0/en/replace.html&quot;&gt;`REPLACE`&lt;/a&gt; seems as meant to do the job, but at the same time its manual page suggests 
&lt;a href=&quot;http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html&quot;&gt;`INSERT ... ON DUPLICATE KEY UPDATE`&lt;/a&gt;.

What of them should I better choose and why?

The only &quot;side effect&quot; of `REPLACE` that comes into my mind is that it would increment autoincrement values (fortunately I don&#39;t use any) while `INSERT ... ON DUPLICATE KEY UPDATE` probably wouldn&#39;t. What are the other practical differences to take in mind? In what particular cases can `REPLACE` be preferred over `INSERT ... ON DUPLICATE KEY UPDATE` and vice versa?

What are practical differences between `REPLACE` and `INSERT ... ON DUPLICATE KEY UPDATE` in MySQL?

I need to remove a unique key from my mysql table. How can remove that using mysql query.

I tried this but it is not working

    alter table tbl_quiz_attempt_master drop unique key;

Please help me

Thanks

How to remove unique key from mysql table

I have the following sql create statement


    mysql&gt; CREATE  TABLE IF NOT EXISTS `erp`.`je_menus` (
        -&gt;   `id` INT(11) NOT NULL AUTO_INCREMENT ,
        -&gt;   `name` VARCHAR(100) NOT NULL ,
        -&gt;   `description` VARCHAR(255) NOT NULL ,
        -&gt;   `live_start_date` DATETIME NULL DEFAULT NULL ,
        -&gt;   `live_end_date` DATETIME NULL DEFAULT NULL , 
        -&gt;   `notes` VARCHAR(255) NULL ,
        -&gt;   `create_date` TIMESTAMP NOT NULL DEFAULT  &#39;0000-00-00 00:00:00&#39;,
        -&gt;   `created_by` INT(11) NOT NULL ,
        -&gt;   `update_date` TIMESTAMP NOT NULL DEFAULT  CURRENT_TIMESTAMP  ,
        -&gt;   `updated_by` INT(11) NOT NULL , 
        -&gt;   `status` VARCHAR(45) NOT NULL ,
        -&gt;   PRIMARY KEY (`id`) ) 
        -&gt; ENGINE = InnoDB;

giving following error

`ERROR 1067 (42000): Invalid default value for &#39;create_date&#39;`

What is the error here?





Invalid default value for &#39;create_date&#39; timestamp field

    Calendar cal;
    String sql = &quot;INSERT INTO ttable (dt) values (?);&quot;
    //dt is a dateTime field in ttable
    
    PreparedStatement stmt = connection.prepareStatement(sql);
    
    stmt = setDate(1,cal); //not working
    
    stmt.execute();
    stmt.close();

I would like to convert cal to a Date type to insert into table.



How to convert Calendar to java.sql.Date in Java?

I have a list of e-mail addresses, some of them are in my table, some of them are not. I want to select all e-mails from that list and whether they are in the table or not.  
  
I can get users whose mail adresses are in the table like this:  
`SELECT u.* FROM USERS u WHERE u.EMAIL IN (&#39;email1&#39;, &#39;email2&#39;, &#39;email3&#39;)  `
  
But how can I select values in that list which are not exist in the table?  
  
Moreover, how can I select like this:  

    E-Mail | Status
    email1 | Exist  
    email2 | Exist  
    email3 | Not Exist  
    email4 | Exist  

  
  
Thanks in advance.

T-SQL: How to Select Values in Value List that are NOT IN the Table?

I want to do this:


    Declare @a int;
    Declare @b int;

    SET @a,@b = (SELECT StartNum,EndNum FROM Users Where UserId = &#39;1223&#39;)

    PRINT @a
    PRINT @b

But this is invalid syntax. How do I set multiple scalar variables in one select statement? I can do:

    Declare @a int;
    Declare @b int;

    SET @a = (SELECT StartNum FROM Users Where UserId = &#39;1223&#39;)
    SET @b = (SELECT EndNum FROM Users Where UserId = &#39;1223&#39;)

    PRINT @a
    PRINT @b

But this will take twice as long. What is the fastest way?

Setting two scalar variables in one SELECT statement?

MySQL How do you INSERT INTO a table with a SELECT subquery returning multiple rows?

  

      INSERT INTO Results
        (
         People,
         names,
        )
        VALUES
        (
         (
           SELECT d.id
           FROM Names f
           JOIN People d ON d.id  = f.id
         ),
        
         (
          &quot;Henry&quot;
         ),
        );

I **WANT** to populate the new table with all results returning from this subquery. How do I do this without getting a **ERROR 1242 (21000): Subquery returns more than 1 row**


MySQL How do you INSERT INTO a table with a SELECT subquery returning multiple rows?

Hi can somebody tell me what is the wrong in the below code?

Selected=&quot;selected&quot; not working for me.

    &lt;!DOCTYPE HTML PUBLIC &quot;-//W3C//DTD HTML 4.0 Transitional//EN&quot;&gt;
        &lt;select id=&quot;tstselect&quot; name=&quot;tstselect&quot; onchange=&quot;showselected(this.value);&quot;&gt;
        &lt;option value=&quot;0&quot; &gt;0&lt;/option&gt;
        &lt;option value=&quot;1&quot; &gt;1&lt;/option&gt;
        &lt;option value=&quot;2&quot; &gt;2&lt;/option&gt;
        &lt;option value=&quot;3&quot; selected=&quot;selected&quot;&gt;3&lt;/option&gt;
        &lt;/select&gt;

Thanks in advance


HTML selected=&quot;selected&quot; not working

How can I stop a running SELECT statement by killing the session?

The command is continuously giving me output based on the SELECT statement, I want to stop it in between.

How to kill a running SELECT statement

I tried the following select:

    SELECT (id,name) FROM v_groups vg 
    inner join people2v_groups p2vg on vg.id = p2vg.v_group_id
    where p2vg.people_id =0;

and I get the following error column reference `id` is ambiguous.

Thing is if I try the same `SELECT` but I only ask for `name`, and not for `id` also, it works.
I&#39;m new to this and maybe I am missing something obvious. Any suggestions? 

Thanks.

Postgresql column reference &quot;id&quot; is ambiguous

 I need to select rows randomly from an Oracle DB. 

Ex:  Assume a table with 100 rows, how I can randomly return 20 of those records from the entire 100 rows. 

How to get records randomly from the oracle database?

Why does this first `if` compile well and the second fail?

    if(proceed) {int i;} // This compiles fine.
    if(proceed) int i;// This gives an error. (Syntax error on token &quot;)&quot;, { expected after this token)



Compiler error when declaring a variable inside if condition and no curly braces

I have a foreach loop and an if statement. If a match is found i need to ultimately break out of the foreach. 

    foreach ($equipxml as $equip) {

        $current_device = $equip-&gt;xpath(&quot;name&quot;);
        if ($current_device[0] == $device) {

            // Found a match in the file.
            $nodeid = $equip-&gt;id;

            &lt;break out of if and foreach here&gt;
        }
    }

break out of if and foreach

This may sound like a silly question, and I hesitated to post it, but still:
if something needs to run only in a certain condition, which of these is more efficient:

**A.**

    if (condition) {
       // do
       // things...
    }

**B.**

    if (!condition) { return; }
    // do
    // things...
    


if-&gt;return vs. if-&gt;else efficiency

In python, is there a difference between say:

    if text == &#39;sometext&#39;:
        print(text)
    if text == &#39;nottext&#39;:
        print(&quot;notanytext&quot;)
and

     if text == &#39;sometext&#39;:
            print(text)
     elif text == &#39;nottext&#39;:
            print(&quot;notanytext&quot;)

Just wondering if multiple `if`s could cause any unwanted problems and if it would be better practice to use `elif`s.



Difference between multiple if&#39;s and elif&#39;s?

I have three functions that find the nth element of a list:

    nthElement :: [a] -&gt; Int -&gt; Maybe a 
    nthElement [] a = Nothing
    nthElement (x:xs) a | a &lt;= 0 = Nothing
                        | a == 1 = Just x
                        | a &gt; 1 = nthElement xs (a-1)

    nthElementIf :: [a] -&gt; Int -&gt; Maybe a
    nthElementIf [] a = Nothing
    nthElementIf (x:xs) a = if a &lt;= 1
                            then if a &lt;= 0 
                                 then Nothing
                                 else Just x -- a == 1
                            else nthElementIf xs (a-1)                           

    nthElementCases :: [a] -&gt; Int -&gt; Maybe a
    nthElementCases [] a = Nothing
    nthElementCases (x:xs) a = case a &lt;= 0 of
                                 True -&gt; Nothing
                                 False -&gt; case a == 1 of
                                            True -&gt; Just x
                                            False -&gt; nthElementCases xs (a-1)

In my opinion, the first function is the best implementation because it is the most concise. But is there anything about the other two implementations that would make them preferable? And by extension, how would you choose between using guards, if-then-else statements, and cases?

Content Type	Original Author	Original Content on Stackoverflow
Question	Robbo_UK	View Question on Stackoverflow
Solution 1 - Mysql	Digbyswift	View Answer on Stackoverflow
Solution 2 - Mysql	AleXqwq	View Answer on Stackoverflow

mysql SELECT IF statement with OR

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

rails, simple_form, how to set selected index of a collection when page loaded?

Remove the last chars of the Java String variable

Attributions