php mysql "unique" error when table is created

Question

So I have this:

CREATE TABLE activeSessions (
    id VARCHAR NOT NULL UNIQUE,
    claimtime int,
    mp FLOAT
);

When I put this into the database, this comes up:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NOT NULL UNIQUE,
    claimtime int,
    mp FLOAT
)' at line 2

How do I fix this?

VARCHAR requires a length. Probably in and float need digits and decimals — Rinsad Ahmed, Sep 14 '18 at 14:46
That is bad design. Why use VARCHAR on an id column to start with? You're better off using auto_increment. — Funk Forty Niner, Sep 14 '18 at 15:14
btw, are you only responding to people who have posted in the answers area? You know that you can comment here, so don't be shy. Unless you feel that the comments posted don't mean anything to you. — Funk Forty Niner, Sep 14 '18 at 15:15
Possible duplicate of [VARCHAR requires a length when rendered on MySQL](https://stackoverflow.com/questions/5569963/varchar-requires-a-length-when-rendered-on-mysql) — Jay Blanchard, Sep 14 '18 at 15:16

Alberto · Answer 1 · 2018-09-14T14:50:39.480

2

You need to specify the constraint after the column declaration:

CREATE TABLE activeSessions (
    id VARCHAR(10) NOT NULL,
    claimtime int,
    mp FLOAT,
    UNIQUE(id)
);

Remember to give an INT value to the VARCHAR column.

edited Sep 14 '18 at 14:50

answered Sep 14 '18 at 14:43

Alberto

674
13
25

What's the error? Have you given a value to varchar? – Alberto Sep 14 '18 at 14:45
You're missing a comma after `FLOAT` – iainn Sep 14 '18 at 14:49
Thank you @iainn! – Alberto Sep 14 '18 at 14:50

php mysql "unique" error when table is created

1 Answers1