StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
2520799
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-03-26T02:21:41.473
FavoriteCount
0
LastActivityDate
2010-03-26T02:33:36.007
LastEditDate
2010-03-26T02:33:36.007
LastEditorUserId
298016
OwnerUserId
298016
ParentId
2516828
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
I think this is what you want if using innodb (recommended) although you can simplify this with myisam <pre><code>delimiter ; drop table if exists customer; create table customer( cust_id int unsigned not null auto_increment primary key, name varchar(255) unique not null, next_proposal_id smallint unsigned not null default 0 )engine = innodb; insert into customer (name) values ('c1'),('c2'),('c3'); drop table if exists proposal; create table proposal( cust_id int unsigned not null, proposal_id smallint unsigned not null, proposal_date datetime not null, primary key (cust_id, proposal_id) -- composite clustered primary key )engine=innodb; delimiter # create trigger proposal_before_ins_trig before insert on proposal for each row begin declare new_proposal_id smallint unsigned default 0; select next_proposal_id+1 into new_proposal_id from customer where cust_id = new.cust_id; update customer set next_proposal_id = new_proposal_id where cust_id = new.cust_id; set new.proposal_id = new_proposal_id; set new.proposal_date = now(); end# delimiter ; insert into proposal (cust_id) values (1),(2),(1),(3),(2),(1),(1),(2); select * from proposal; select * from customer; </code></pre> hope it helps :) i've added the myisam version below for good measure: <pre><code>drop table if exists customer; create table customer( cust_id int unsigned not null auto_increment primary key, name varchar(255) unique not null )engine = myisam; insert into customer (name) values ('c1'),('c2'),('c3'); drop table if exists proposal; create table proposal( cust_id int unsigned not null, proposal_id smallint unsigned not null auto_increment, proposal_date datetime not null, primary key (cust_id, proposal_id) -- composite non clustered primary key )engine=myisam; insert into proposal (cust_id,proposal_date) values (1,now()),(2,now()),(1,now()),(3,now()),(2,now()),(1,now()),(1,now()),(2,now()); select * from customer; select * from proposal order by cust_id; </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POMysql - second auto_increment col with diff behaviour
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USJon Black
UserOwnerUserId
1. USJon Black
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.