SQL Queries

SQL Queries

Python Stack

SELECT, INSERT, UPDATE, DELETE In normal curcumstances you will only be Inserting, Updating, and Deleting 1 row at a time. You will typically have 2 Select statements 1 for all and 1 for just 1 row or set of rows.

Code Snippet

SELECT * FROM <tableName>; SELECT * FROM <tableName> WHERE id = <enterID#>; INSERT INTO <tableName> (enter, column, names, here) VALUES ("Column", "Data", "Goes", "Here"); UPDATE <tableName> SET columnName="NewData", columnName="OtherNewData" WHERE id = <id of row you want to update>; DELETE FROM <tableName> WHERE id = <id of row to delete>; Copy code

dojo24 created this note. It has been liked or found useful 81 times