课程: Supabase Essential Training

免费学习该课程！

今天就开通帐号，24,700 门业界名师课程任您挑！

SQL queries

SQL queries

课程: Supabase Essential Training

开始一个月试用 购买团队方案

SQL queries

“

- [Instructor] Many modern web backends were using four basic actions, create, read, update, and delete, or CRUD for short. SQL queries are very similar. Similar to CRUD, PostgreSQL has four commonly used commands, INSERT, SELECT, UPDATE, and DELETE. These four commands are used when writing SQL statements. When a statement is specifically used to retrieve data with the SELECT command, it is also known as a query, but you'll often hear statement and query used interchangeably, even when INSERT, UPDATE, and DELETE are being used. Let's go to the SQL editor in the Supabase dashboard now. First you'll notice there is a purchases table. This is a table that I created ahead of time, and it has several columns here. The first one is the ID, and the ID is the primary key for this table. This ID field is a universally unique identifier field, also known as a UUID. A UUID is a guaranteed unique set of letters and numbers. Next, this is the created_at column, and this is a timestamp recording…

内容