/
githubmirror
/
sqlc
Обзор
Документация
Войти
/
githubmirror
/
sqlc
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
examples/ondeck/postgresql/query/city.sql
26 строк
413 B
Kyle Conroy
examples: Port ondeck to MySQL (#680)
26 авг 2020, 18:29
Не верифицирован
26 авг 2020, 18:29
ea268b2
Код
Авторство
О чём код?
-- name: ListCities :many SELECT * FROM city ORDER BY name; -- name: GetCity :one SELECT * FROM city WHERE slug = $1; -- name: CreateCity :one -- Create a new city. The slug must be unique. -- This is the second line of the comment -- This is the third line INSERT INTO city ( name, slug ) VALUES ( $1, $2 ) RETURNING *; -- name: UpdateCityName :exec UPDATE city SET name = $2 WHERE slug = $1;