SQL Create Table command not functioning

Question

I'm trying to run the following command:

CREATE TABLE artist
(
    aid INT PRIMARY KEY AUTO_INCREMENT,
    fname VARCHAR(30) NOT NULL,
    lname VARCHAR(40),
    dob DATE,
    gender CHAR(1)
);

I've tried putting it all on one line. I've tried messing with capitalization, and I get the same error message which is

-bash: syntax error near unexpected token `('

Any ideas what I'm doing wrong?

Welcome to Stack Overflow. With database questions, it is a good idea to also include your database type and version in the tags. I updated the question tags to include MySQL. If that is incorrect, please update them ). — Leigh
– Leigh, Commented May 29, 2013 at 19:43

Community · Accepted Answer · 2017-05-23 12:02:29Z

5

You have to execute this command in the database (not from the command line).

For example, if you are using MySQL, you have to login to the database first:

$ mysql -u root -p

then enter the password. You'll see a welcome screen and a mysql> prompt:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 3.23.28-gamma-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer

mysql>

Type CREATE TABLE command after the mysql> prompt.

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered May 29, 2013 at 19:38

Yang

8,2289 gold badges51 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Create Table command not functioning

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related