Syntax error, creating database

Question

I am trying to create database android_api and table users but I am getting error

#1064 - Something is wrong in your syntax near 'use android_api

create table 'users'(
   id int(11) NOT NULL primary KEY AU' w linii 3

Here is the code

create database android_api

use android_api

create table users(
   id int(11) NOT NULL primary KEY AUTO_INCREMENT,
   unique_id varchar(23) not null unique,
   name varchar(50) not null,
   email varchar(100) not null unique,
   encrypted_password varchar(80) not null,
   salt varchar(10) not null,
   created_at datetime,
   updated_at datetime null
);

Um.. here - updated_at datetime null ? you don't need to give null there — Gurwinder Singh
– Gurwinder Singh, Commented Dec 4, 2016 at 13:31

Dekel · Accepted Answer · 2016-12-04 13:41:03Z

2

You should separate each SQL statement with ;, otherwise your syntax is incorrect.

Here is the correct syntax:

create database android_api;

use android_api;

create table users(
   id int(11) NOT NULL primary KEY AUTO_INCREMENT,
   unique_id varchar(23) not null unique,
   name varchar(50) not null,
   email varchar(100) not null unique,
   encrypted_password varchar(80) not null,
   salt varchar(10) not null,
   created_at datetime,
   updated_at datetime null
);

In your code what you did was actually:

create database android_api use android_api

(Which is not a valid CREATE statement).

answered Dec 4, 2016 at 13:41

Dekel

62.9k12 gold badges109 silver badges130 bronze badges

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

9 Comments

Defus Over a year ago

hmm now I have error A symbol name was expected! near name unexpected beginning of statement near 50 Unrecognized statement type neae not null name varchar(50) not null,

Dekel Over a year ago

are you using mysql? which version? how exactly you run these queries?

Defus Over a year ago

SQL it's phpMyAdmin php ver 5.5

Dekel Over a year ago

and you still didn't answer what version of mysql you are using

Defus Over a year ago

My hosting using MariaDB version 10

|

questionto42 · Accepted Answer · 2021-05-30 23:02:49Z

1

Actually, the accepted answer is enough. This is a very small idea to share after running into the same problem as you report it, but in a beginner's tutorial Load PostgreSQL Sample Database in an SQL Shell.

In general, if you have the reported error in an SQL shell, and if you are not sure whether you have typed ; at the end of the last line, just type ; as a new command and press Enter to be sure that you type your next command in LINE 1 and not in LINE 2.

Without this "trick", some stupidity like this can happen:

postgres=# CREATE DATABASE dvdrental
postgres-# show databases
postgres-# create database dvdrental;
ERROR:  syntax error at or near »show«
LINE 2: show databases
         ^
postgres=# create database dvdrental
postgres-# CREATE DATABASE dvdrental;
ERROR:  syntax error at or near »CREATE«
LINE 2: CREATE DATABASE dvdrental;
         ^
postgres=# CREATE DATABASE dvdrental;
CREATE DATABASE

Finally working, as can be seen by the output CREATE DATABASE.

answered May 30, 2021 at 23:02

questionto42

9,9228 gold badges80 silver badges125 bronze badges

1 Comment

testing_22 Over a year ago

Ok, definitely as a beginner, I can't see why and where's this error coming from. But this solved!

Collectives™ on Stack Overflow

Syntax error, creating database

2 Answers 2

9 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related