Results 1 to 2 of 2

Thread: update

  1. #1
    Join Date
    Dec 1969

    Default update

    hi, this is what i want to know how to do:<BR>lets say i want to update these 3 records in a db:<BR>cars, planes , ships.<BR>these are all diferent tables inmy database.<BR>i think the sql should look something like this:<BR>"update tablename set cars=something, set planes=somethingelse, <BR>set ships=somedata"<BR>you get the picture, what is the correct sql to do this(i doubt what i wrote is the one).<BR>

  2. #2
    Join Date
    Dec 1969

    Default Separate statements

    You can only update one table with a update statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts