Jump to content

How to insert more than 1 user in database?


david212

Recommended Posts

Hello. I have this code:

 

INSERT INTO `tbl1` (`user`, `pass`) VALUES

('nickname', 'passnick');

 

when i execute this code there only appers one user : "nickname" with his password "passnick" . I'd like to know how to create for table "tbl1" more than 1 user?

 

'nickname', 'passnick'

'nickname2', 'passnick2'

'nickname3', 'passnick3'

 

Thank you for your help!

INSERT INTO `tbl1` (`user`, `pass`) VALUES
('nickname', 'passnick'); 
INSERT INTO `tbl1` (`user`, `pass`) VALUES
('nickname2', 'passnick2'); 
INSERT INTO `tbl1` (`user`, `pass`) VALUES
('nickname3', 'passnick3'); 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.