Tuesday, June 27, 2017

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');