using [`DATE_SUB` *&lt;sup&gt;[docs]&lt;/sup&gt;*][1]
 like :

    DATE_SUB((DATE_SUB(curdate(), INTERVAL 1 MONTH)), INTERVAL 4 DAY)


  [1]: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-sub

    SELECT DATE_ADD(DATE_ADD(NOW(),INTERVAL -1 MONTH), INTERVAL -4 DAY)

Keep it simple:

    SELECT CURDATE() - INTERVAL 1 MONTH - INTERVAL 4 DAY;

or

    SELECT &#39;2014-03-27&#39; - INTERVAL 1 MONTH - INTERVAL 4 DAY;

or if you like to preserve the current time:

    SELECT NOW() - INTERVAL 1 MONTH - INTERVAL 4 DAY;

(Tested on MySQL 5.1.73 and newer)

```SELECT CURRENT_TIMESTAMP + INTERVAL - 1 MONTH + INTERVAL - 4 DAY;```  
or   
```SELECT CURRENT_DATE + INTERVAL - 1 MONTH + INTERVAL - 4 DAY;```

I have a custom UIView which has a dedicated, manually set frame for portrait and landscape orientation because autoresizingMasks just don&#39;t work in my case. 

I set this frame in:   

     - (void)viewWillAppear:(BOOL)animated

 And it works as expected.

My problem is now, that my UIView furthermore has subviews that also have a dedicated position for portrait/landscape. 

I position these subviews in: 
   
   
    - (void)layoutSubviews

If I now leave my viewController in **e.g.** portrait orientation, rotate to landscape on another viewController and then come back to this viewController I see that my view got resized correctly, but the subviews of my view, which get positioned in layoutSubviews are not repositioned yet but are resized in an animated fashion after the view already appeared.

I do nothing in viewDidAppear and I already tried calling

     - (void)layoutIfNeeded

As well as:

     - (void)setNeedsLayout

In `viewWillAppear`, but it doesn&#39;t seem to change anything.

Any ideas what I&#39;m doing wrong?




How to force layoutSubviews of UIView?

This question is not language specific.  **I&#39;m curious how to properly send username and password from a website login form to a server.**  

My guess is to hash the password, put username/password in the POST body and send it over `HTTPS`.  What&#39;s a better way?

For good measure I&#39;ll mention a less than ideal method:

    http://www.somesite.com/login?un=myplaintextusername&amp;pw=myplaintextpassword

Proper way to send username and password from client to server

I need to subtract 1 month and 4 days with mysql, I saw the command
`DATE_ADD (NOW (), - 1 MONTH)` perfect for 1 month but for 1 month and 4 days, using 31 days is not valid for every month that some bring 30, 29, 28. I can not add 31 + 4, 30 + 4, etc.


Subtract month and day mysql

<p>I need to subtract 1 month and 4 days with mysql, I saw the command
<code>DATE_ADD (NOW (), - 1 MONTH)</code> perfect for 1 month but for 1 month and 4 days, using 31 days is not valid for every month that some bring 30, 29, 28. I can not add 31 + 4, 30 + 4, etc.</p>


I&#39;m trying to find the rows that are in one table but not another, both tables are in different databases and also have different column names on the column that I&#39;m using to match.

I&#39;ve got a query, code below, and I think it probably works but it&#39;s way too slow:

    SELECT `pm`.`id`
    FROM `R2R`.`partmaster` `pm`
    WHERE NOT EXISTS (
    	SELECT * 
    	FROM `wpsapi4`.`product_details` `pd`
    	WHERE `pm`.`id` = `pd`.`part_num`
    )

So the query is trying to do as follows:

Select all the ids from the R2R.partmaster database that are not in the wpsapi4.product_details database. The columns I&#39;m matching are partmaster.id &amp; product_details.part_num

Select from one table where not in another

I did some queries without a commit. Then the application was stopped.

How can I display these open transactions and commit or cancel them?

Display open transactions in MySQL

I was just trying to add a column called &quot;location&quot; to a table (main_table) in a database. The command I run was

    ALTER TABLE main_table ADD COLUMN location varchar (256);

The main_table contains &gt; 2,000,000 rows. It keeps running for more than 2 hours and still not completed. 

I tried to use `mytop`
to monitor the activity of this database to make sure that the query is not locked by other querying process, but it seems not. Is it supposed to take that long time? Actually, I just rebooted the machine before running this command. Now this command is still running. I am not sure what to do. 


ALTER TABLE ADD COLUMN takes a long time

Say I have a simple function in MySQL:

    SELECT SUM(Column_1)
    FROM Table
    WHERE Column_2 = &#39;Test&#39;

If no entries in `Column_`2 contain the text &#39;Test&#39; then this function returns `NULL`, while I would like it to return 0. 

I&#39;m aware that a similar question has been asked a few times here, but I haven&#39;t been able to adapt the answers to my purposes, so I&#39;d be grateful for some help to get this sorted.

How do I get SUM function in MySQL to return &#39;0&#39; if no values are found?

How would I do something like this?

&lt;pre&gt;
SQL SELECT row FROM table WHERE id=max(id)
&lt;/pre&gt;

How do I select an entire row which has the largest ID in the table?

Please clarify two things for me:

1. Can a Foreign key be NULL?
2. Can a Foreign key be duplicate?

As fair as I know, `NULL` shouldn&#39;t be used in foreign keys, but in some application of mine I&#39;m able to input `NULL` in both Oracle and SQL Server, and I don&#39;t know why.

Can a foreign key be NULL and/or duplicate?

My lower level knowledge of SQL (Server 2008) is limited, and is now being challanged by our DBAs. Let me explain (I have mentioned obvious statements in the hope that I am right, but if you see something wrong, please tell me) the scenario:

We have a table which holds &#39;Court Orders&#39; for people. When I created the table, (Name: CourtOrder), I created it like:

    CREATE TABLE dbo.CourtOrder
    (
      CourtOrderID INT NOT NULL IDENTITY(1,1), (Primary Key)
      PersonId INT NOT NULL,
      + around 20 other fields of different types.
    )

I then applied a non-clustered index to the primary key (for efficiency). My reasons is that it is a unique field (primary key), and should be indexed, mainly for selection purposes, as we often `Select from table where primary key = ...`

I then applied a CLUSTERED index on PersonId. The reason was to group orders for a particular person physically, as the vast majority of work is getting orders for a person. So, `select from mytable where personId = ...`

I have been pulled up on this now. I have been told that we should put the clustered index on the primary key, and the normal index on the personId. That seems very strange to me. First off, why would you put a clustered index on a unique column? what is it clustering? Surely that&#39;s a waste of the clustered index? I&#39;d have believed a normal index would be used on a unique column. Also, clustering the index would mean we can&#39;t cluster a different column (One per table, right?).

The reasoning for me being told I have made a mistake is that they believe putting a clustered index on the PersonId would make inserts slow. For the 5% gain in speed of a select, we would be getting a 95% degradation in speed on inserts and updates. Is that correct and valid?

They say that because we cluster the personId, SQL Server has to rearrange data when ever we insert or make a change to the PersonId.

So then I have asked, why would SQL have the concept of a CLUSTERED INDEX, if it&#39;s so slow? Is it as slow as they&#39;re saying? How should I have setup my indexes to achieve optimum performance? I&#39;d have thought SELECT is used more than INSERT... but they say that we&#39;re having locking issues on INSERTS...

Hope someone can help me.

Clustered vs Non-Clustered

I have ssis package in that I&#39;m taking values from flat file and insert it into table.

I have taken one Execute SQL Task in that creating one temptable 

    CREATE TABLE [tempdb].dbo.##temptable 
    (
    date datetime,
    companyname nvarchar(50),
    price decimal(10,0),
    PortfolioId int,
    stype nvarchar(50)
    )

    Insert into [tempdb].dbo.##temptable (date,companyname,price,PortfolioId,stype) 
    SELECT   date,companyname,price,PortfolioId,stype
    FROM        ProgressNAV
    WHERE     (Date = &#39;2011-09-30&#39;) AND (PortfolioId = 5) AND (stype in (&#39;Index&#39;))
    ORDER BY CompanyName

Now in above query I need to pass `(Date = &#39;2011-09-30&#39;) AND (PortfolioId = 5) AND (stype in (&#39;Index&#39;))`
these 3 parameter using variable name I have created variables in package so that I become dynamic.

Content Type	Original Author	Original Content on Stackoverflow
Question	Alexd2	View Question on Stackoverflow
Solution 1 - Mysql	Haim Evgi	View Answer on Stackoverflow
Solution 2 - Mysql	ptomli	View Answer on Stackoverflow
Solution 3 - Mysql	david	View Answer on Stackoverflow
Solution 4 - Mysql	M Rostami	View Answer on Stackoverflow

Subtract month and day mysql

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

Solution 4 - Mysql

Proper way to send username and password from client to server

How to force layoutSubviews of UIView?

Attributions