how to create index in two table mysql?

Question

Please help me to create index between two tables in mysql? I have "account" and "group" table. I have to index with "group_id with index_id" and to be unique.

This question has absolutely nothing to do with PHP.

Lightness Races in Orbit
– Lightness Races in Orbit

2011-01-13 16:47:20 +00:00
Commented Jan 13, 2011 at 16:47 — Lightness Races in Orbit
– Lightness Races in Orbit, Commented Jan 13, 2011 at 16:47
What do you mean, precisely, by "be unique" ?

Victor Nicollet
– Victor Nicollet

2011-01-13 16:47:29 +00:00
Commented Jan 13, 2011 at 16:47 — Victor Nicollet
– Victor Nicollet, Commented Jan 13, 2011 at 16:47

Lightness Races in Orbit · Accepted Answer · 2011-01-13 16:46:30Z

1

MySQL table indexes are on single tables.

Perhaps you're thinking of a FOREIGN KEY, which is only available with the InnoDB storage engine.

answered Jan 13, 2011 at 16:46

Lightness Races in Orbit

387k77 gold badges670 silver badges1.1k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kyle Humfeld · Accepted Answer · 2011-01-13 16:55:01Z

0

I just learned this myself, here, but apparently if you create a Unique constraint on a field, mySql will automatically create a nonclustered index on that field.

answered Jan 13, 2011 at 16:55

Kyle Humfeld

1,8974 gold badges24 silver badges29 bronze badges

Comments

user463535 · Accepted Answer · 2011-01-13 17:00:37Z

0

I think you're looking for a Foreign key.

This statement assumes that 'group_id' is a column in the account table and 'index_id' is a column in the group table.

ALTER TABLE account ADD CONSTRAINT group_index FOREIGN KEY (group_id) REFERENCES  group (index_id)

answered Jan 13, 2011 at 17:00

user463535

Collectives™ on Stack Overflow

how to create index in two table mysql?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related