Primary Key (1 Viewer)

A

aedislee

New member

Local time

Today, 10:13

Joined

Feb 12, 2015

Messages

4

• Nov 13, 2015

• #1

morning all

Can someone tell me how to a an AutoNumber Primary Key to a create table query please??

Thanks

 

gemma-the-husky

Super Moderator

Staff member

Local time

Today, 10:13

Joined

Sep 12, 2006

Messages

15,652

• Nov 13, 2015

• #2

ignore post

 

A

aedislee

New member

Local time

Today, 10:13

Joined

Feb 12, 2015

Messages

4

• Nov 13, 2015

• #3

No I haven't tried anything

 

B

ButtonMoon

Registered User.

Local time

Today, 10:13

Joined

Jun 4, 2012

Messages

304

• Nov 13, 2015

• #4

Like this:

CREATE TABLE t1 (x AUTOINCREMENT PRIMARY KEY, z String NOT NULL);