mysql> insert into t1 values (-1, now(),sysdate()); ERROR 1136 (21S01): Column count doesn't match value count at row 1 mysql> insert into t1 values (-1, 'single insert',sysdate(),now()); Query OK, 1 row affected (0.00 sec) mysql> select * from t1; +----+---------------+---------------------+---------------------+ | id | level | dt_sysdate | dt_outer | +----+---------------+---------------------+---------------------+ | -1 | single insert | 2012-03-28 08:55:16 | 2012-03-28 08:55:16 | +----+---------------+---------------------+---------------------+ 1 row in set (0.00 sec) mysql> insert into t1 values (-1, 'single insert',sysdate(),now()); ERROR 1062 (23000): Duplicate entry '-1' for key 'PRIMARY' mysql> insert into t1 values (-2, 'multi insert',sysdate(),now()),(-3,'multi ins ert',sysdate(),now()); Query OK, 2 rows affected (0.00 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> select * from t1; +----+---------------+---------------------+---------------------+ | id | level | dt_sysdate | dt_outer | +----+---------------+---------------------+---------------------+ | -3 | multi insert | 2012-03-28 08:56:37 | 2012-03-28 08:56:37 | | -2 | multi insert | 2012-03-28 08:56:37 | 2012-03-28 08:56:37 | | -1 | single insert | 2012-03-28 08:55:16 | 2012-03-28 08:55:16 | +----+---------------+---------------------+---------------------+ 3 rows in set (0.00 sec) mysql> insert into t1 values (-2, 'multi insert',sysdate(),now()),(-3,'multi ins ert',sysdate(),now()); ERROR 1062 (23000): Duplicate entry '-2' for key 'PRIMARY' mysql> select * from t1; +----+---------------+---------------------+---------------------+ | id | level | dt_sysdate | dt_outer | +----+---------------+---------------------+---------------------+ | -3 | multi insert | 2012-03-28 08:56:37 | 2012-03-28 08:56:37 | | -2 | multi insert | 2012-03-28 08:56:37 | 2012-03-28 08:56:37 | | -1 | single insert | 2012-03-28 08:55:16 | 2012-03-28 08:55:16 | +----+---------------+---------------------+---------------------+ 3 rows in set (0.00 sec) mysql> insert into t1 values (-3, 'multi insert partial overlap',sysdate(),now() ),(-4,'multi insert partial overlap',sysdate(),now()); ERROR 1062 (23000): Duplicate entry '-3' for key 'PRIMARY' mysql> select * from t1; +----+---------------+---------------------+---------------------+ | id | level | dt_sysdate | dt_outer | +----+---------------+---------------------+---------------------+ | -3 | multi insert | 2012-03-28 08:56:37 | 2012-03-28 08:56:37 | | -2 | multi insert | 2012-03-28 08:56:37 | 2012-03-28 08:56:37 | | -1 | single insert | 2012-03-28 08:55:16 | 2012-03-28 08:55:16 | +----+---------------+---------------------+---------------------+ 3 rows in set (0.00 sec) mysql> insert into t1 values (-4, 'multi insert partial overlap',sysdate(),now() ),(-3,'multi insert partial overlap',sysdate(),now()); ERROR 1062 (23000): Duplicate entry '-3' for key 'PRIMARY' mysql> select * from t1; +----+---------------+---------------------+---------------------+ | id | level | dt_sysdate | dt_outer | +----+---------------+---------------------+---------------------+ | -3 | multi insert | 2012-03-28 08:56:37 | 2012-03-28 08:56:37 | | -2 | multi insert | 2012-03-28 08:56:37 | 2012-03-28 08:56:37 | | -1 | single insert | 2012-03-28 08:55:16 | 2012-03-28 08:55:16 | +----+---------------+---------------------+---------------------+ 3 rows in set (0.00 sec) mysql> call example1(now()); Query OK, 1 row affected (0.00 sec) mysql> select * from t1; +----+---------------+---------------------+---------------------+ | id | level | dt_sysdate | dt_outer | +----+---------------+---------------------+---------------------+ | -6 | example1 | 2012-03-28 09:08:54 | 2012-03-28 09:08:54 | | -5 | example1 | 2012-03-28 09:08:54 | 2012-03-28 09:08:54 | | -3 | multi insert | 2012-03-28 08:56:37 | 2012-03-28 08:56:37 | | -2 | multi insert | 2012-03-28 08:56:37 | 2012-03-28 08:56:37 | | -1 | single insert | 2012-03-28 08:55:16 | 2012-03-28 08:55:16 | +----+---------------+---------------------+---------------------+ 5 rows in set (0.00 sec) mysql> call example2(now()); ERROR 1062 (23000): Duplicate entry '-5' for key 'PRIMARY' mysql> select * from t1; +----+---------------+---------------------+---------------------+ | id | level | dt_sysdate | dt_outer | +----+---------------+---------------------+---------------------+ | -6 | example1 | 2012-03-28 09:08:54 | 2012-03-28 09:08:54 | | -5 | example1 | 2012-03-28 09:08:54 | 2012-03-28 09:08:54 | | -3 | multi insert | 2012-03-28 08:56:37 | 2012-03-28 08:56:37 | | -2 | multi insert | 2012-03-28 08:56:37 | 2012-03-28 08:56:37 | | -1 | single insert | 2012-03-28 08:55:16 | 2012-03-28 08:55:16 | +----+---------------+---------------------+---------------------+ 5 rows in set (0.00 sec) mysql> call example3(now()); ERROR 1062 (23000): Duplicate entry '-5' for key 'PRIMARY' mysql> select * from t1; +----+---------------+---------------------+---------------------+ | id | level | dt_sysdate | dt_outer | +----+---------------+---------------------+---------------------+ | -8 | example3 | 2012-03-28 09:09:20 | 2012-03-28 09:09:20 | | -6 | example1 | 2012-03-28 09:08:54 | 2012-03-28 09:08:54 | | -5 | example1 | 2012-03-28 09:08:54 | 2012-03-28 09:08:54 | | -3 | multi insert | 2012-03-28 08:56:37 | 2012-03-28 08:56:37 | | -2 | multi insert | 2012-03-28 08:56:37 | 2012-03-28 08:56:37 | | -1 | single insert | 2012-03-28 08:55:16 | 2012-03-28 08:55:16 | +----+---------------+---------------------+---------------------+ 6 rows in set (0.00 sec) mysql> call example4(now()); ERROR 1062 (23000): Duplicate entry '-5' for key 'PRIMARY' mysql> select * from t1; +----+---------------+---------------------+---------------------+ | id | level | dt_sysdate | dt_outer | +----+---------------+---------------------+---------------------+ | -8 | example3 | 2012-03-28 09:09:20 | 2012-03-28 09:09:20 | | -6 | example1 | 2012-03-28 09:08:54 | 2012-03-28 09:08:54 | | -5 | example1 | 2012-03-28 09:08:54 | 2012-03-28 09:08:54 | | -3 | multi insert | 2012-03-28 08:56:37 | 2012-03-28 08:56:37 | | -2 | multi insert | 2012-03-28 08:56:37 | 2012-03-28 08:56:37 | | -1 | single insert | 2012-03-28 08:55:16 | 2012-03-28 08:55:16 | +----+---------------+---------------------+---------------------+ 6 rows in set (0.00 sec) mysql> call example4(now()); ERROR 1062 (23000): Duplicate entry '-5' for key 'PRIMARY' mysql> select * from t1; +----+---------------+---------------------+---------------------+ | id | level | dt_sysdate | dt_outer | +----+---------------+---------------------+---------------------+ | -8 | example3 | 2012-03-28 09:09:20 | 2012-03-28 09:09:20 | | -6 | example1 | 2012-03-28 09:08:54 | 2012-03-28 09:08:54 | | -5 | example1 | 2012-03-28 09:08:54 | 2012-03-28 09:08:54 | | -3 | multi insert | 2012-03-28 08:56:37 | 2012-03-28 08:56:37 | | -2 | multi insert | 2012-03-28 08:56:37 | 2012-03-28 08:56:37 | | -1 | single insert | 2012-03-28 08:55:16 | 2012-03-28 08:55:16 | +----+---------------+---------------------+---------------------+ 6 rows in set (0.00 sec) mysql>