SQL QUERIES

SQL QUERIES

1. "NSERT INTO"query

   • Insert into a record into a database using a query
   • INSERT INTO tbl_name (fld_1, fld_2, fld_3, fld_4) VALUES (val_1, val_2, val_3, val_4);
     • REMEMBER if you are inserting into all fields you to not need to include the field names

2. "SELECT *" query

   • Select records from a database using a query
   • SELECT * FROM tbl_name;
     • SELECT fld_name1, fld_name2 FROM tbl_name;
       • SELECT * FROM tbl_name WHERE fld_name = value;

3. "UPDATE" query

   • Update records in a database using a query
   • UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE ID = value

4. "DELETE" query

   • DELETE FROM table_name WHERE fld_name=value

5. FOR MORE VISIT W3SCHOOLS WEBSITE