Creating tables syntax error?

Databases
1

im tying to figure out my syntax error

CREATE TABLE users
(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
first_name VARCHAR(50),
last_name VARCHAR(50),
email varchar(50),
UNIQUE (email),
PRIMARY KEY (id)
);

CREATE TABLE permissions
(
id SMALLINT UNSIGNED AUTO_INCREMENT,
directory VARCHAR(50),
description TEXT,
PRIMARY KEY (id)
);

CREATE TABLE users-permissions
(
user-id SMALLINT UNSIGNED,
permission-id SMALLINT UNSIGNED,
FOREIGN KEY (user-id) REFERENCES users (id),
FOREIGN KEY (permission-id) REFERENCES permissions (id),
PRIMARY KEY (user-id, permission-id)
);

heres the error

1920×1080 68 KB

Thanks

2

use an underscore instead of a dash (which is interpreted as the arithmetic subtraction operator) in both table names and column names

1 Like
3

ok, made the change (it worked!)
Now im getting this error when I try to insert data

1920×1080 57.1 KB

what is the error, the only thing I can think of is the descriptions data type is TEXT, but does that matter?

4

In this case, don’t think. look

5

what are those, images for ants?

any chance we could convince you to paste text into your posts?

1 Like
6

okay, i took the extraordinary step of downloading your image… then opened it up in a graphic editor, and zoomed in

you won’t believe what i found!!!

the error message tells you EXACTLY where the error is!!!

as @Mittineague said, take a look

7

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.