write the syntax of following commands with example.....................(create, select, update and insert)
Share
write the syntax of following commands with example.....................(create, select, update and insert)
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
CREATE TABLE my_table (
id INTEGER AUTOINCREMENT
name text
age INT
);
SELECT * FROM my_table;
UPDATE my_table SET name = 'Timmy' WHERE id = 69;
INSERT INTO my_table (name, age) VALUES ('Mohini', 18);