can i do sql in sql

Results 1 to 2 of 2

Thread: can i do sql in sql

  1. #1
    Join Date
    Dec 1969

    Default can i do sql in sql

    i was thinking something like:<BR>update table set just = (select id from table where just1 = 1) + 1<BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default Maybe, depends on dbms.

    According to ANSI-sql it is perfectly feasible to write as you do. Alas, it is not supported by all DBMS.<BR><BR>If you just wish to refer to columns within the same table, you can do that directly<BR><BR>update table set just = just + 1 where id = 1 <BR><BR>for instance.<BR><BR><BR><BR><BR>

Posting Permissions

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