Basics of Insert statement in MySQL

So we have already created a table as in Basics of Create Table statement in MySQL

Now, let's insert some values in table myfirsttable



INSERT INTO MyFirstTable VALUES(1,'user1','100000','Manager');
INSERT INTO MyFirstTable VALUES(2,'user2','80000','Lead');

INSERT INTO MyFirstTable VALUES(3,'user3','50000','Employee');
INSERT INTO MyFirstTable VALUES(4,'user4','50000','Employee');
INSERT INTO MyFirstTable VALUES(5,'user5','50000','Employee');
Basics of Insert statement in MySQL Basics of Insert statement in MySQL Reviewed by Ishan Dev Shukl on June 27, 2017 Rating: 5

No comments:

Thanks a lot for your valuable Comment!

Powered by Blogger.