sql query insert

Question

How can I insert multiple values in 2 tables? I thought something like this, but that obviously doesn't work:

insert into login as l,
      klantGegevens as k
      (l.password, 
       l.rechten, 
       l.status, 
       k.voornaam, 
       k.achternaam, 
       k.woonplaats, 
       k.postcode, 
       k.telefoonnr)
   values
      ('test',
        1,
        1,
        'niels',
        'jansen',
        'Amsterdam',
        '5993hk',
        0623232323)

EDIT:

 string intoDatabase = "insert into login  (password,rechten,status) values(@password,@rechten,@status) insert into klantGegevens (voornaam,achternaam,woonplaats,postcode,telefoonnr) values(@voornaam,@achternaam,@woonplaats,@postcode,@telefoonnr)";

you could ue a transaction to make sure that one won't be executed before the other — Jeremy C.
– Jeremy C., Commented May 21, 2015 at 9:05

Robert · Accepted Answer · 2015-05-21 09:02:41Z

1

Only in separate commands :

insert into login  (password,rechten,status) 
values('test',1,1)

insert into klantGegevens(voornaam,achternaam,woonplaats,postcode,telefoonnr) 
values('niels','jansen','Amsterdam','5993hk',0623232323)

edited May 21, 2015 at 9:02

answered May 21, 2015 at 9:00

Robert

25.8k8 gold badges70 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Robert Over a year ago

@jarlh No, it doesn't :)

Danyal Sandeelo Over a year ago

should have been a comment :)

Jenssen Over a year ago

Thanks for reply, what's the best way for doing this in c#? See my edit.

Robert Over a year ago

@Jenssen You have to do it in two separate commands, maybe in transaction.

Collectives™ on Stack Overflow

sql query insert

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related