CODEWITHSUNDEEP
sql
David C
David C

Reputation: 1

I'm learning SQL by myself , when I create a query but I have an error (invalid name of 'Employee') when I insert it

Step 1: create a new database

CREATE DATABASE MyfirstDatabase;

Step 2:

USE MyFirstDatabase

Step 3 create an employee table inside MyFirstDatabase:

CREATE TABLE Employee
(
    EmpID nvarchar(50), 
    Name nvarchar(50),
    DOB Date
);

Step 4: insert values into Employee table:

INSERT INTO Employee 
VALUES ('E01', 'John', '3 November 2000');

INSERT INTO Employee 
VALUES ('E02', 'Kelly', '24 November 2000');

DROP DATABASE MyfirstDatabase

Upvotes: 0

Views: 47

Answers (1)

Nayanish Damania
Nayanish Damania

Reputation: 652

Try this:

After creating databse MyFirstDatabase and table Employee

USE MyFirstDatabase;

INSERT INTO Employee VALUES
('E01','John','2000-11-03');

INSERT INTO Employee VALUES
('E02','Kelly','2000-11-24');

Date format should be in yyyy-MM-dd format

Upvotes: 1

Related Questions