SQL query you can use for both INSERT into values and SELECT. This query mostly used in testing regions while you are working Data Warehousing project or any development project.
The Query INSERT and SELECT
The simple syntax is
INSERT INTO table_name(column_values1,coulumn_values2) values(name1,name2); SELECT * FROM table_name;
The above query is more than enough to learn. The real advantage is you can insert values as many as you want and you can see the data you entered.
Real SQL query
CREATE TABLE SRNI_TABLE(NAME CHAR (10),ROLE CHAR(10)); INSERT INTO SRNI_TABLE(NAME,ROLE) VALUES('SRINI','ENGINEER'); SELECT * FROM SRNI_TABLE;
NAME, ROLE ===== ==== SRINIMF SOFTWARE SRINIMF SOFTWARE SRINIMF SOFTWARE SRINI ENGINEER
The benefits of INSERT and SELECT
- You can avoid mistakes
- Saves time again to re-check the values