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](http://stackoverflow.com/posts/16822425/edit) ). — Leigh, May 29 '13 at 19:43

score 5 · Answer 1 · edited May 23 '17 at 12:02

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.

SQL Create Table command not functioning

1 Answers1