Tuesday, December 29, 2015

SQL Statement create table and add data into the columns

CREATE TABLE Persons
(
PersonID int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
);

INSERT INTO persons (PersonID, LastName, FirstName, Address, City)
VALUES (1,'Ayatollah','Rock', 'Manowar', 'Mexico');



No comments:

Post a Comment