What is wrong with this table design?

Databases
#1

this forum doesn’t see enough activity and i’m bored

what is wrong with this table design?

wrong answers only

CREATE TABLE customers
( id INTEGER NOT NULL AUTO_INCREMENT
, name VARCHAR(100) NOT NULL
, addr VARCHAR(400)
, phone VARCHAR(37)
)
1 Like
#2

You’re right. It looks like Christmas hit really hard and we’re all exhausted.

To be honest, I don’t see anything particularly wrong with the design per ser.
Probably I would call CustomerID and not only ID the firfs field, and I guess that 37 digits for a phone number is a bit too much.

But now you’ll tell me something really obvious that it is right in front of my face and that I didn’t pay attention :rofl:

2 Likes
#3

Not sure about the SQL dialect but I would say INT instead of INTEGER

2 Likes
#4

excellent!!

two answers so far, and both wrong as requested!

#5

You never set the primary key.

2 Likes
#6

Varchar has a max length of 255 therefore 400 is wrong

1 Like
#7

You got it. An auto_increment must be a key.

1 Like
#8

reread the op. He is asking for wrong answers, not for what is rightfully wrong.

So a wrong answer is that it does not have an order ID

1 Like
#9

beautiful!!

and wrong, as requested

#10

that’s not wrong, so your answer is wrong, so it’s right!!!

#11

i love it!!

wrong as requested!!

#12

So the right answer is that there’s nothing wrong :stuck_out_tongue:

#13

As my answer is not wrong, your answer is wrong as requested

#14

255 characters will be the maximum lengh in a database like Access.I think the limit for varchar is 8000

#15

that answer is wrong! i love it!!

#16

This depends on the database. That’s why I asked for the dialect. For MYSQL it is 4096 chars, for Postgres it’s 65535 for example

#17

I’m so happy that you’re having fun on our behalf :rofl:

1 Like
#18

pls do a little bit of googling (or test it yourself)

an auto_increment has to have an index, but it does not have to be a PK

#19

wrong!! well done!!

“The length can be specified as a value from 0 to 65,535.” – https://dev.mysql.com/doc/refman/8.0/en/char.html

#21

Please read my post. I said “key" not primary key, what for me is similar to an index. It’s just an other word