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
Reviewed by Ishan Dev Shukl
on
June 27, 2017
Rating:
No comments:
Thanks a lot for your valuable Comment!