Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

How to create index in two table mysql?

⇧
0
⇩
90 views

please help me how 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.

mysql index
asked January 13, 2011 10:44 am CST
sorga
posted via StackOverflow

3 Answers

⇧
0
⇩
 

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 January 13, 2011 11:23 am CST
Tomalak Geret'kal
⇧
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 January 13, 2011 11:23 am CST
Kyle Humfeld
⇧
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 January 13, 2011 11:23 am CST
Adam Prax

Your answer

Join with account you already have

Sign in with Twitter account
Sign in with Facebook account
Sign in with Google Friend Connect

Preview
Similar questions
Can I change the datatype for the "Create Table" field in the Show Create Table function in MySQL?
January 10, 2011
Create table from select then alter table by adding an auto increment column in mysql
January 11, 2011
Index on a table you must fully scan anyway? (MySQL)
January 7, 2011
MySQL - Aren't these privileges enough to create a table?
January 3, 2011
Convert Simple T-SQL DDL to MySQL DDL (Create Table)
January 6, 2011
Significance of index name in creating an index (mySQL)
January 4, 2011
Adding index on large table takes forever
January 4, 2011
How to use constants in SQL CREATE TABLE?
December 31, 2010
Trigger: after insert create a new table
January 7, 2011
[Solved] SQL CREATE TABLE Error
January 9, 2011
Hibernate: hbm2ddl.auto does not create table
December 28, 2010
Foreign key constraints missing from SHOW CREATE TABLE output
December 28, 2010
Perl - Linux - How can I make my "index.pl?see=this&foo=that&bar=that" url pretty? (index.pl/(see value)??
January 4, 2011
Rewrite index.php and index.html in .htaccess
January 10, 2011
Codeigniter: I would like create user URL's for my users when they create a username
January 8, 2011
MySQL compound index not being used
January 4, 2011
How to get MySQL database to appear on index.php
December 27, 2010
MySQL Integer vs DateTime index
January 4, 2011
MySQL index: what's the difference between how 2 fields are indexed?
January 9, 2011
Why MySQL multiple-column index is overpopulated?
December 25, 2010
Is there a way to use the index to avoid a filesort when OR is used in MySQL query?
January 10, 2011
Need suggestions to get a unique index keys for two or more tables on mysql
January 1, 2011
Mysql innodb: Choosing index type for 'greater than >=' select
January 10, 2011
Duplicated Rows with UNIQUE INDEX MySQL and NULL Columns
December 21, 2010
Can MySQL fulltext search return an index(position) instead of a score?
December 29, 2010
Choosing a primary key,surrogate key, index in the mysql stock trading database
December 30, 2010
Populating a table with a large amount of data from a temporary table - MySQL
January 5, 2011
MYSQL inserting records form table A into tables B and C (linked by foreign key) depending on column values in table A
January 7, 2011
Trying to create a MYSQL advanced search
January 6, 2011
Create MySQL Replication Delay
January 11, 2011