-
How to use identify in Mysql
I can use the following way to create a table , what is wrong?
create table elements (id integer(3) IDENTITY,
name char(30),
number char(30),
mass char(30),
symbol char(2));
CREATE UNIQUE INDEX ui_elements_pk ON elements (symbol)
insert into elements ( name, number, mass, symbol) values ('Manganese','25','55','Mn');
insert into elements ( name, number, mass, symbol) values ('Zinc','30','65','Zn');
insert into elements ( name, number, mass, symbol) values ('Thulium','69','169','Tm');
insert into elements ( name, number, mass, symbol) values ('Californium','98','251','Cf');
insert into elements ( name, number, mass, symbol) values ('Gold','79','197','Au');
insert into elements ( name, number, mass, symbol) values ('Ytterbium','70','173','Yb');
insert into elements ( name, number, mass, symbol) values ('Molybdenum','42','96','Mo');
insert into elements ( name, number, mass, symbol) values ('Palladium','46','106','Pd');
Thank you
________
Buy herbalaire vaporizer
Last edited by sql; 03-06-2011 at 02:01 AM.
-
I guess MySQL's AUTO_INCREMENT is equivalent to MSSQL's IDENTITY..
So Try this..
create table elements (id integer(3) AUTO_INCREMENT PRIMARY KEY,
name char(30),
number char(30),
mass char(30),
symbol char(2));
-
Thank you!
________
HONDA NT650 HISTORY
Last edited by sql; 03-06-2011 at 02:02 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|