| |

VerySource

 Forgot password?
 Register
Search
View: 666|Reply: 9

Ask: create a new table? Can you set a joint primary key directly in the Enterprise Manager? Thank you

[Copy link]

3

Threads

10

Posts

8.00

Credits

Newbie

Rank: 1

Credits
8.00

 China

Post time: 2020-2-21 10:30:02
| Show all posts |Read mode
Ask: create a new table? Can you set a joint primary key directly in the Enterprise Manager? Thank you
Reply

Use magic Report

0

Threads

100

Posts

53.00

Credits

Newbie

Rank: 1

Credits
53.00

 China

Post time: 2020-4-29 23:00:02
| Show all posts
You can go.
Reply

Use magic Report

0

Threads

100

Posts

53.00

Credits

Newbie

Rank: 1

Credits
53.00

 China

Post time: 2020-4-29 23:30:01
| Show all posts
Design table, relationship. New
Reply

Use magic Report

3

Threads

10

Posts

8.00

Credits

Newbie

Rank: 1

Credits
8.00

 China

 Author| Post time: 2020-4-30 00:00:01
| Show all posts
Or give a statement to build a table and build a primary key Thank you
Reply

Use magic Report

0

Threads

100

Posts

53.00

Credits

Newbie

Rank: 1

Credits
53.00

 China

Post time: 2020-4-30 06:15:01
| Show all posts
Are you using multiple columns as primary keys or foreign keys?
Reply

Use magic Report

0

Threads

100

Posts

53.00

Credits

Newbie

Rank: 1

Credits
53.00

 China

Post time: 2020-4-30 09:00:01
| Show all posts
create table test (pk1 int, pk2 int, other int, primary key (pk1, pk2))
Reply

Use magic Report

0

Threads

100

Posts

53.00

Credits

Newbie

Rank: 1

Credits
53.00

 China

Post time: 2020-4-30 10:00:02
| Show all posts
The above is multiple columns as the primary key.
Reply

Use magic Report

0

Threads

88

Posts

55.00

Credits

Newbie

Rank: 1

Credits
55.00

 China

Post time: 2020-4-30 11:45:01
| Show all posts
Yes, hold down ctrl and select the column you want. You can select multiple columns. Press the small key above to become the joint primary key.
Reply

Use magic Report

3

Threads

10

Posts

8.00

Credits

Newbie

Rank: 1

Credits
8.00

 China

 Author| Post time: 2020-4-30 16:15:01
| Show all posts
One surface theory has two character ends combined to be the primary key Thank you
Reply

Use magic Report

0

Threads

211

Posts

108.00

Credits

Newbie

Rank: 1

Credits
108.00

 China

Post time: 2020-4-30 18:15:02
| Show all posts
can
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