trying to add a new user and I got this error

Question

sing up to php site Encountering an error

Incorrect integer value: '' for column 'id' at row 1

the data base code

  -- Table structure for table `user`


CREATE TABLE `user` (
  `id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `lname` text NOT NULL,
  `father` text NOT NULL,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `flag` enum('0','1') NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `name`, `lname`, `father`, `username`, `password`, `flag`) VALUES
(1, 'yasha', 'asadpoor', 'akbari', 'yashaaa', '123456', '1'),
(2, '1', '2', '3', '4', '5', '1'),
(3, 'm', 'm', 'm', 'm', 'm', '1');

if id is your primary key,don't need to assign it in query,it will be incremented automatically. — Vaisakh Pc, Nov 28 '14 at 12:28
if u did not set primary key auto incremented then set it then you don'nt need to give id. — Lokesh Jain, Nov 28 '14 at 12:29

score 2 · Answer 1 · edited May 23 '17 at 11:57

2

In order to take advantage of the auto-incrementing capability of the column, do not supply a value for that column when inserting rows. The database will supply a value for you.

INSERT INTO user (name, lname, father, username, password, flag) VALUES ( 'yasha', 'asadpoor', 'akbari', 'yashaaa', '123456', '1'), ( '1', '2', '3', '4', '5', '1'), ( 'm', 'm', 'm', 'm', 'm', '1');

view this question.

edited May 23 '17 at 11:57

Community

1
1

answered Nov 28 '14 at 12:37

Alireza Tajary

21
4

You may want to be more specific about how the asker can use this information to solve their problem. – Casey Rule Nov 28 '14 at 12:44
remove the from last line and update data base but The problem is still there – HAMED HNV Nov 28 '14 at 13:22

score 0 · Answer 2 · answered Nov 28 '14 at 12:29

change insert statement to

INSERT INTO `user` (`id`, `name`, `lname`, `father`, `username`, `password`, `flag`) VALUES
(NULL,'yasha', 'asadpoor', 'akbari', 'yashaaa', '123456', '1'),
(NULL,'1', '2', '3', '4', '5', '1'),
(NULL,'m', 'm', 'm', 'm', 'm', '1');

trying to add a new user and I got this error

2 Answers2