insert value without setting primary key
<p>i got minimal database like so</p>

<pre><code>CREATE TABLE IF NOT EXISTS `users` (
  `id` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `pass` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `reg_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=40 ;
</code></pre>

<p>then i try to insert new user, setting only username/email/pass</p>

<blockquote>
  <p>"INSERT INTO <code>users</code> SET name='user_name', email='users_email', `pass = 'users_top_secret_pass."';</p>
</blockquote>

<p>or every time i ned insert new id like:</p>

<pre><code>INSERT INTO `users` (`id`, `name`, `email`, `pass`, `reg_time`) VALUES
(1, 'user', 'user@server.com', 'pass', '2016-01-31 03:10:13');
</code></pre>

<p>name and email are UNIQUE, time is default current timestamp and i no need  to test them. This is good but how i can be insert id, and does i need it?</p>

<p>testing on local phpmyadmin gives me nothing new.</p>

<p>upd: removed outdated code with php functions, only sql.</p>