sqlite3 auto-incrementing integer id

[CodingCabbage]

How do i make an auto-incrementing column? Heres my pseudocode/sql attempt

How do you make an auto-incrementing ID for a record

c.execute('''CREATE TABLE <tableName>
(
<columnName> <aut incrementing??!!>,
<columnName2> text,
<columnName3> text,
<columnName4> text
)
''')

[pritaeas]

create table test 
(
    id integer primary key not null
);