mysql insert syntax

Create a table

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `company` varchar(150) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Insert record - Way 1

insert into `users` set name='php tutorial'

Insert record - Way 2

INSERT INTO `users` (`id`, `name`, `image`, `company`, `created`, `modified`) VALUES (NULL, 'arun', NULL, 'php-tutorial', NULL, CURRENT_TIMESTAMP);

Add multiple records

INSERT INTO `mysql_certification`.`users` (`id`, `name`, `image`, `company`, `created`, `modified`) VALUES (NULL, 'arun', NULL, 'php-tutorial', NULL, CURRENT_TIMESTAMP), (NULL, 'arun', NULL, 'php-tutorial', NULL, CURRENT_TIMESTAMP);

Copying rows from one table to another

INSERT INTO `users`  (name, company) select name, company from users where id<5