Wednesday, 14 September 2016

Insert data into Table

Here's how to insert data into a Table.
  • First create a table of suitable attributes. Here's how you create a table - Create a table.
  • Then here;'s the syntax for entering values into that table.
SYNTAX -
1: insert into <table_name>
2: (field names)
3: values (corresponding values);

Examples -
1: insert into student
2: (Roll_no,Name,Address,Phone_Number)
3: values(15121,'Trunks','Capsule Corps',1234567890);

1: insert into student
2: (Roll_no,Name,Address,Phone_Number)
3: values(15226,'Reas Grimmery','High School DxD',0198765432);

1: insert into student
2: (Roll_no,Name,Address,Phone_Number)
3: values(15094,'Naruto Uzumaki','Konohaghure','7777777779');


No comments:

Post a Comment

If u need any help,