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

xiaoxu

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

unkmass

You can go.

unkmass

Design table, relationship. New

xiaoxu

Or give a statement to build a table and build a primary key Thank you

unkmass

Are you using multiple columns as primary keys or foreign keys?

unkmass

create table test (pk1 int, pk2 int, other int, primary key (pk1, pk2))

unkmass

The above is multiple columns as the primary key.

cv4bf5d65fd

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.

xiaoxu

One surface theory has two character ends combined to be the primary key Thank you

fanfan1980

can