| |

VerySource

 Forgot password?
 Register
Search
View: 1746|Reply: 2

update in sybase

[Copy link]

1

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-3-8 23:30:01
| Show all posts |Read mode
update cource set teacher_name = teacher.name where cource.teacher_id = teacher.id

Does this update operation support sybase?
Reply

Use magic Report

0

Threads

2

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

Post time: 2020-7-19 14:45:01
| Show all posts
update cource set teacher_name = teacher.name from teacher where cource.teacher_id = teacher.id
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-8-12 16:30:01
| Show all posts
update cource a
    set (teacher_id ,teacher_name) =
    (select
           b.teacher_id ,b.teacher_name
      from student b
      where condition 1
    )
   where condition 2

How to deal with this kind of statement in Sybase?
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list