Depends on which kind you&#39;re looking for.

The current integer Unix Timestamp (`1350517005`) can be retrieved like so:

    SELECT UNIX_TIMESTAMP();

MySQL often displays timestamps as date/time strings.  To get one of those, these are your basic options ([from the MySQL Date &amp; Time reference][1]):

    SELECT CURRENT_TIMESTAMP;
    SELECT CURRENT_TIMESTAMP();
    SELECT NOW();

[1]: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html

`CURRENT_TIMESTAMP` is standard SQL and works on SQL server, Oracle, MySQL, etc. You should try to keep to the standard as much as you can.

just use NOW()

Full reference: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html

What is the difference between Facade and Gateway design patterns?

I have dozens of unit tests, and I&#39;d like to fix the code I am working on now, but every time I run the tests it takes over 30 seconds to run every unit test (I think reflection is the cause of some of these being especially slow). My current test and many other tests take less than one second to run, but it is annoying to disable and then enable specific unit tests.

Is there a way to say, &quot;For now, run a single, specific test?&quot;

I&#39;m using Visual Studio 2010 with the built-in unit test system. I create tests by right-clicking any code and selecting &quot;create unit test&quot; which creates a project.

Run specific unit test in Visual Studio

How can I get the current timestamp using a mysql query?

Getting timestamp using MySQL

<p>How can I get the current timestamp using a mysql query?</p>


So I&#39;ve been looking through the internet the last hour, reading and looking for the definitive answer to this simple question.

What is the default JOIN in MySQL?

    SELECT * FROM t1 JOIN t2

Is that the same as

    SELECT * FROM t1, t2
    
    OR

    SELECT * FROM t1 INNER JOIN t2


Also a related question, when you use &quot;WHERE&quot; clauses, is it the same as JOIN or INNER JOIN ?

Right now I&#39;m thinking a stand-alone JOIN is identical to using commas and WHERE clauses.

What is the default MySQL JOIN behaviour, INNER or OUTER?

According to MySQL, a `text` column holds 65,535 bytes.

So if this a legitimate boundary then will it actually only fit about 32k UTF-8 characters, right? Or is this one of those &quot;fuzzy&quot; boundaries where the guys that wrote the docs can&#39;t tell characters from bytes and it will actually allow ~64k UTF-8 characters if set to something like `utf8_general_ci`?

How much UTF-8 text fits in a MySQL &quot;Text&quot; field?

I stumbled into a delicate SQL problem when I needed to use a value from a field inside a LIKE %..% statement.

Example:

    SELECT t1.Notes, t2.Name
    FROM Table1 t1, Table2 t2
    WHERE t1.Notes LIKE &#39;%t2.Name%&#39;

This is only an example from the top of my head to show what I need to do (I know this will not work). I need to use the value of t2.Name inside the LIKE %..%
  
I guess this is trivial when you know it ;)

Use LIKE %..% with field values in MySQL

I have a simple mysql table:

    CREATE TABLE IF NOT EXISTS `pers` (
      `persID` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(35) NOT NULL,
      `gehalt` int(11) NOT NULL,
      `chefID` int(11) DEFAULT NULL,
      PRIMARY KEY (`persID`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
    
    INSERT INTO `pers` (`persID`, `name`, `gehalt`, `chefID`) VALUES
    (1, &#39;blb&#39;, 1000, 3),
    (2, &#39;as&#39;, 1000, 3),
    (3, &#39;chef&#39;, 1040, NULL);

I tried to run following update, but I get only the error 1093:  

    UPDATE pers P 
    SET P.gehalt = P.gehalt * 1.05 
    WHERE (P.chefID IS NOT NULL 
    OR gehalt &lt; 
    (SELECT (
    	SELECT MAX(gehalt * 1.05) 
    	FROM pers MA 
    	WHERE MA.chefID = MA.chefID) 
    	AS _pers
    ))

I searched for the error and found from mysql following page http://dev.mysql.com/doc/refman/5.1/en/subquery-restrictions.html, but it doesn&#39;t help me.

What shall I do to correct the sql query?


You can&#39;t specify target table for update in FROM clause

    SHOW VARIABLES LIKE &quot;%wait%&quot;
    
    Result: 28800
    
    SET @@GLOBAL.wait_timeout=300
    
    SHOW GLOBAL VARIABLES LIKE &quot;%wait%&quot;
    
    Result: 300
    
    SHOW SESSION VARIABLES LIKE &quot;%wait%&quot;
    
    Result:28800

I am confused by the results. Why does the last query give Result:28800 ?


MySQL wait_timeout Variable - GLOBAL vs SESSION

Why there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause?

    CREATE TABLE `foo` (
      `ProductID` INT(10) UNSIGNED NOT NULL,
      `AddedDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
      `UpdatedDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
    ) ENGINE=INNODB;

The error that results:



&gt; Error Code : 1293
&gt; 
&gt; Incorrect table definition; there can
&gt; be only one TIMESTAMP column with
&gt; CURRENT_TIMESTAMP in DEFAULT or ON
&gt; UPDATE clause



Why there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT clause?

There are a lot of questions that ask about &#39;UNIX timestamp to MySQL time&#39;. I needed the reversed way, yea... Any idea?

How to convert MySQL time to UNIX timestamp using PHP?

I want to have one table with two `TIMESTAMP` columns. One column to keep track of when the record was created and another to keep track of when it was modified. I want these values handled by the database. I don&#39;t want my app layer to have to think about it.

I know that if you have a `TIMESTAMP` column with a `DEFAULT CURRENT_TIMESTAMP` or an `ON UPDATE CURRENT_TIMESTAMP` you cannot have another `TIMESTAMP` column. You can use `DATETIME` but there is no way to default it, that I know of, outside of a trigger.

I found that you &lt;a href=&quot;https://web.archive.org/web/20160401143159/http://michaelkimsal.com/blog/mysql-using-two-timestamps-for-createdupdated-values/&quot;&gt;can have multiple `TIMESTAMP` columns&lt;/a&gt; by leaving each without `DEFAULT` or `ON UPDATE` and inserting `NULL` when the record is created, causing each to have the current timestamp. From that point on the first column will automatically be updated.

This works fantastically but it leaves me with a funny feeling. Like this may be a bug and it could be patched at any time. If this is the way it is supposed to work then so be it. I will merrily go on my way. Can anyone tell me if this is the best way to do this or should I be using triggers?

One Mysql Table with Multiple TIMESTAMP Columns

I want to define table which will have 2 TIMESTAMP fields, someting like this:

    CREATE TABLE `msgs` (
        `id` INT PRIMARY KEY AUTO_INCREMENT,
        `msg` VARCHAR(256),
        `ts_create` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        `ts_update` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
    )

How to do this avoiding error:

    ERROR 1293 (HY000): Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

Point is to keep desired behavior of `ts_create` and `ts_update` in table schema.

MySQL CURRENT_TIMESTAMP on create and on update

Is there a way to get the UTC timestamp by specifying the date? What I would expect:

    datetime(2008, 1, 1, 0, 0, 0, 0)

should result in

     1199145600

Creating a naive datetime object means that there is no time zone information. If I look at the documentation for datetime.utcfromtimestamp, creating a UTC timestamp means leaving out the time zone information. So I would guess, that creating a naive datetime object (like I did) would result in a UTC timestamp. However:

    then = datetime(2008, 1, 1, 0, 0, 0, 0)
    datetime.utcfromtimestamp(float(then.strftime(&#39;%s&#39;)))
results in

    2007-12-31 23:00:00

Is there still any hidden time zone information in the datetime object? What am I doing wrong?

Content Type	Original Author	Original Content on Stackoverflow
Question	bsytKorbi	View Question on Stackoverflow
Solution 1 - Mysql	Brad Koch	View Answer on Stackoverflow
Solution 2 - Mysql	Alex	View Answer on Stackoverflow
Solution 3 - Mysql	Pablo Santa Cruz	View Answer on Stackoverflow
Solution 4 - Mysql	Proteux	View Answer on Stackoverflow

Getting timestamp using MySQL

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

Solution 4 - Mysql

Run specific unit test in Visual Studio

What is the difference between Facade and Gateway design patterns?

Attributions