Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You never refer to the <code>timestamp</code> <strong>column</strong> in your query. You only have a <strong>string</strong>:</p> <pre><code>INSERT INTO `abc` (id, 'timestamp') VALUES ('', UNIX_TIMESTAMP ( NOW () ) ) ^^^^^^^^^^^ </code></pre> <hr> <p><strong>Edit:</strong></p> <p>I get this with your updated code:</p> <blockquote> <p>ERROR 1630 (42000): FUNCTION test.NOW does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual</p> </blockquote> <p>Assuming it's not still the actual code and after fixing the syntax error, I can't reproduce your results. My educated guess is that <code>id</code> is an auto-incremented integer primary key, your current SQL mode is making MySQL take <code>''</code> as <code>NULL</code> and inserting a new row... But I haven't really tested this hypothesis.</p> <p>My working code is this:</p> <pre><code>CREATE TABLE `abc` ( `pk` INT(10) NOT NULL AUTO_INCREMENT, `id` VARCHAR(10) NULL DEFAULT NULL, `timestamp` INT(11) NOT NULL DEFAULT '0', PRIMARY KEY (`pk`) ) ENGINE=InnoDB; INSERT INTO abc (id, timestamp) VALUES ('', UNIX_TIMESTAMP()); -- Wait a few seconds INSERT INTO abc (id, timestamp) VALUES ('', UNIX_TIMESTAMP()); -- Wait a few seconds INSERT INTO abc (id, timestamp) VALUES ('', UNIX_TIMESTAMP()); SELECT timestamp FROM abc WHERE id=''; </code></pre> <p>... and returns this:</p> <pre><code>+------------+ | timestamp | +------------+ | 1342694445 | | 1342694448 | | 1342694450 | +------------+ 3 rows in set (0.00 sec) </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POmysql query - insert data unix_timestamp ( now ( ) ) issue
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USÁlvaro González
    1. USÁlvaro González
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POmysql query - insert data unix_timestamp ( now ( ) ) issue
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COMy bad, I just edited my post, I'm sorry.
      singulars
      1. PO
      1. USReteras Remus
    2. COThank you Alvaro for your effort. Yes, I forgot to mention that ID is an INT AUTO_INCREMENT FIELD. The UNIX_TIMESTAMP() it's working. The problem was caused when I tried to output the value from seconds to date in php. I used: date('d.m.Y - H:m:s', $row['timestamp']); and it should be: date('d.m.Y - H:i:s', $row['timestamp']); That caused all the bad thins.
      singulars
      1. PO
      1. USReteras Remus
    3. COA tip for the future: debug MySQL issues from MySQL :)
      singulars
      1. PO
      1. USÁlvaro González
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload