Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Get - SQL used to determine how data will be retrieved from the database.

SELECT id, year, make, model FROM auto_info WHERE year = {:2} AND make = {:3} AND model = {:4}

Set - SQL used to determine how data will be set in the database.

Insert - SQL used to determine how data will be inserted into the database.

INSERT INTO auto_info(id, year, make, model) VALUES ({:1}, {:2}, {:3}, {:4})

Update - SQL used to determine how data will be updated in the database.

UPDATE auto_info SET year = {:2}, make = {:3}, model = {:4} WHERE id = {:1}

Delete - SQL used to determine how data will be deleted from the database.

DELETE FROM auto_info WHERE id = {:1}

Search - SQL used to determine how data will be searched in the database.

SELECT id, year, make, model FROM auto_info WHERE year = {:2} AND make = {:3} AND model = {:4}

Seq - I don’t know what the hell this is