1

Topic: Good afternoon! I try to create empty

create database test
go
use [Human resources department]
go
create database testing
(id_personnal int (10) AUTO_INCREMENT
name varchar (20) NOT NULL
email varchar (50) NOT NULL
password varchar (15) NOT NULL
PRIMARY KEY (id_user));
create table posts (
id_post int (10) AUTO_INCREMENT;
message text NOT NULL;
id_author int (10) NOT NULL;
id_topic int (10) NOT NULL;
PRIMARY KEY (id_post);
FOREIGN KEY (id_author) REFERENCES users (id_user);
FOREIGN KEY (id_topic) REFERENCES topics (id_topic)
);
Writes incorrect syntax in id_personnal,
I ask not to judge strictly, whether prompt syntax is correctly written?

2

Re: Good afternoon! I try to create empty

belu4ano-kg;
"create database testing" - you want to create a DB, and write further columns as though want to create the table. Really it does not rush at once to eyes? And all because  practically night on a court yard, evening of Sunday. Have a rest, on Monday with new forces start tables to do...

3

Re: Good afternoon! I try to create empty

belu4ano-kg;
And still the remark. A lesson you take from here , but there not MSSQL, and MySQL. It not SSMS as studio to work, and absolutely other utility.

4

Re: Good afternoon! I try to create empty

Andy_OLAP;
I will correct

5

Re: Good afternoon! I try to create empty

belu4ano-kg wrote:

Andy_OLAP;
I will correct

The colleague, here it is necessary not to correct syntax mysql for mssql, and to find a dial-up of lessons for MSSQL...

6

Re: Good afternoon! I try to create empty

Andy_OLAP;
I will correct