[thelist] Auto Increment in database - a goofy question I am sure

[Schoolcraft, Jeffrey]

In mysql the definition for an AI index would look like:

	id int not null auto_increment

Essentially what this does is builds a primary key for the database.
Auto_increment indexes are traditionally integers.  But this is a
non-updateable key.  If you had a table that looked like this:

	create table foo (
		id int not null auto_increment,
		name varchar(50),
		phone varchar(11),
		primary key (id)
	);

You would make an insert statements like this:
	insert into foo (name, phone) values ('john doe', '555-555-1212');
	insert into foo (name, phone) values ('jane doe', '555-212-5555');

And your selects would look like:
	select * from database;
	1, john doe, 555-555-1212
	2, jane doe, 555-212-5555

It auto increments your id.

Hopefully this is what you're looking for.


> -----Original Message-----
> From: Jay Blanchard [mailto:jay.blanchard at niicommunications.com]
> Sent: Thursday, April 18, 2002 8:03 AM
> To: thelist at lists.evolt.org
> Subject: RE: [thelist] Auto Increment in database - a goofy
> question I am sure
>
>
> [snip]
> jay, what's an AI index?
> [/snip]
>
> auto increment index
>
> :)
>
> Jay
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !