Designing SQL table for queue system

Question

I am new to SQL database, and I would like to build a membership queue system. However, I do not know how to design tables, so that each time when user input and register personal data, the SQL will automatically assign a queue number for the record. Any website or reference have tutorial for that ?

Also, I am trying to build it with mobile platform, so is it good to use sqllite and parse it with JSON to the web server or use websql ?

Please help, Thank You.

ErichBSchulz · Accepted Answer · 2014-01-21 05:32:40Z

2

There are two unrelated questions there. But in relation to the first part, you just need a standard auto_increment column:

CREATE TABLE `members` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `name_key` (`name`)
);

This table will automatically assign a new id to each record as a name is inserted.

answered Jan 21, 2014 at 5:32

ErichBSchulz

15.8k6 gold badges61 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Designing SQL table for queue system

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related