mysql> CREATE TABLE table01(id INT,
name VARCHAR(400),
created TIMESTAMP default CURRENT_TIMESTAMP);
Query OK, 0 rows affected, 1 warning (0.06 sec)
mysql> show warnings;
+-------+------------+---------------------------------------+
| Level | Advertizer | Message |
+-------+------------+---------------------------------------+
| Ad | Foo Bar | Visit our store at http://foobar.com/ |
+-------+------------+---------------------------------------+
1 row in set (0.00 sec)
mysql> INSERT INTO table01 (id, name) VALUES(100, 'Billy Joel');
Query OK, 1 rows affected (0.02 sec)
...
...
...
mysql> SELECT * FROM table01 LIMIT 3
+-----+------------------------------------------------+---------------------+
| id | name | created |
+-----+------------------------------------------------+---------------------+
| 0 | Sponsored Row - Visit us at http://bazbaz.com/ | 2006-04-06 17:17:49 |
| 100 | Billy Joel | 2012-01-02 15:27:33 |
| 101 | Pink Floyd | 2012-01-02 15:27:40 |
+-----+------------------------------------------------+---------------------+
3 rows in set (0.02 sec)
mysql> SELECT * FROM table01 LIMIT 30
+-----+------------------------------------------------------------+---------------------+
| id | name | created |
+-----+------------------------------------------------------------+---------------------+
| 0 | Sponsored Row - Visit us at http://bazbaz.com/ | 2006-04-06 17:17:49 |
| 100 | Billy Joel | 2012-01-02 15:27:33 |
| 101 | Pink Floyd | 2012-01-02 15:27:40 |
| 102 | Dire Straits | 2012-01-02 15:27:45 |
| 0 | To see more than 4 rows at a time, visit http://mysql.com/ | 2012-01-02 20:00:07 |
+-----+------------------------------------------------------------+---------------------+
5 rows in set (0.00 sec)
Well, thank FSF for Free & open Source Software!!
