MySQL Forums
Forum List  »  Newbie

Interpreting Data
Posted by: Jeff Kapral
Date: September 24, 2017 06:35AM

Hey Everyone, I'm new to this so this should be a pretty easy problem. I'm taking an online class using Codio and I'm told to create a TABLE within a DATABASE, with the following settings:

| Field | Type | Null | Key | Default | Extra |
+-----------------+---------------------+------+-----+----------+-------+
| user_id | int(7) | NO | | NULL | |
| email_frequency | tinyint(2) unsigned | YES | | 15 | |
| layout | varchar(70) | YES | | vertical | |
| updated_at | datetime | YES | | NULL | |
+-----------------+---------------------+------+-----+----------+-------+

I use this code below and it says Query OK.


CREATE TABLE settings (
user_id INT(7) UNSIGNED NOT NULL auto_increment,
email_frequency TINYINT(2) DEFAULT 15,
layout VARCHAR(70) DEFAULT “vertical”,
updated_at DATETIME DEFAULT NULL,
PRIMARY KEY (user_id)
) AUTO_INCREMENT = 1

But the Codio unit won't let me pass through because of this error:

LAST RUN on ‎9‎/‎23‎/‎2017‎ ‎12‎:‎07‎:‎42‎ ‎PM
[Error]: Task 2. Expected: Create a 'settings' table in the 'App' database with the specified features. Try again.

Someone from my class said it could be my auto increment settings? But I don't what I should change it to.

Options: ReplyQuote


Subject
Written By
Posted
Interpreting Data
September 24, 2017 06:35AM
September 24, 2017 11:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.