Tilted Forum Project Discussion Community - View Single Post - Best way to set up this Mysql? (primary key?)

Rawb · 03-10-2004, 11:27 PM

http://www.mysql.com/doc/en/ALTER_TABLE.html

Speficily(sp):
To add an index on column d, and make column a the primary key:

mysql> ALTER TABLE t2 ADD INDEX (d), ADD PRIMARY KEY (a);

03-10-2004, 11:27 PM	#8 (permalink)
Rawb Crazy Location: Salt Town, UT	Here is the MySQL guide for it http://www.mysql.com/doc/en/ALTER_TABLE.html Speficily(sp): To add an index on column d, and make column a the primary key: mysql> ALTER TABLE t2 ADD INDEX (d), ADD PRIMARY KEY (a);