• Replies 5 replies
  • Subscribers 95 subscribers
  • Views 2090 views
  • Users 0 members are here
Options
Related

How modify multiple database table when modify or delete user

davidhsu
over 4 years ago

Dears, 

I need some advice how I modify multiple table when modify or delete user, for example, 

When I delete user, the SQL statement as bellow,

1. update users set active='2', <multiple column> where userid=xxxx

2. delete from xxx where userid=xxxx

I use OneIM 8.1.3 and native database connector, Please help, very thanks~~

Parents
  • over 2 years ago

    Problem
    You want to insert a new record into a table. For example, you want to insert a new record into the DEPT table. The value for DEPTNO should be 50, DNAME should be “PROGRAMMING”, and LOC should be “BALTIMORE”.

    Solution
    Use the INSERT statement with the VALUES clause to insert one row at a time:

    insert into dept (deptno,dname,loc)
    values (50,'PROGRAMMING','BALTIMORE')
    For DB2 and MySQL you have the option of inserting one row at a time or multiple rows at a time by including multiple VALUES lists:

    /* multi row insert */
    insert into dept (deptno,dname,loc)
    values (1,'A','B'),
    (2,'B','C')

    Regards,
    Peter

Reply
  • over 2 years ago

    Problem
    You want to insert a new record into a table. For example, you want to insert a new record into the DEPT table. The value for DEPTNO should be 50, DNAME should be “PROGRAMMING”, and LOC should be “BALTIMORE”.

    Solution
    Use the INSERT statement with the VALUES clause to insert one row at a time:

    insert into dept (deptno,dname,loc)
    values (50,'PROGRAMMING','BALTIMORE')
    For DB2 and MySQL you have the option of inserting one row at a time or multiple rows at a time by including multiple VALUES lists:

    /* multi row insert */
    insert into dept (deptno,dname,loc)
    values (1,'A','B'),
    (2,'B','C')

    Regards,
    Peter

Children
No Data