Write a significance of maintaining order of attribute while inserting values in table
Answers
Answer -
____________________________________
- For you to insert rows into a table, the table must be in your own schema or you free space in the table into which you are inserting and maintains referential integrity constraints.
____________________________________
→ Hope it will help you ❣️❣️
Significance of maintaining order of attribute while inserting values in table of database are :
Explanation:
Database is a place where all the information is maintained , either updated, inserted , deleted and many operation.
It is important to handle the data in the database carefully. Having a better knowledge of SQL queries, and database management knowledge.
Whenever we insert some elements into a database. We need to always mention Table Name , not column name , where we are inserting in SQL query.
To maintain the order attributes while inserting values in database:
query used
insert into "tablename"
(first_colum,...last_colum)
values (first_val,...last_val);
Example
insert into member
(firstname , lastname , age, address, city, state)
values ('Harry', 'shan', 35, '213 hno west ',
'Mumbai', 'Maharashtra');
Rule: Strings closed in a single string :
Harry is inserted in the list of member
entry