SQL Flashcards
(7 cards)
How to select all fields from a table.
SELECT * FROM table_name
how to use conditions in SQL
WHERE condition = true/false OR/AND condition = true/false
How to use the “LIKE” condition?
WHERE -field- LIKE “A%” OR -field- LIKE “B%”
How to enter data into a database using SQL?
INSERT INTO <table name> (field1, field2, field3….)
VALUES (“string”, “string”, integer)
how to delete data from a database?
DELETE FROM <table name> WHERE <field> = <condition></condition></field>
how do you change values in SQL?
UPDATE <table name>
SET <field> = <value></value></field>
WHERE <field> = <condition></condition></field>
how do we combine two tables in SQL?
SELECT table1.field, table2.field
FROM table1
JOIN table2 <——- JOIN
ON table1.field = table2.field
WHERE condition = true/false
