Sayısal İşlevler, sayılar üzerinde işlem yapmak ve sayıları döndürmek için kullanılır. SQL'de tanımlanan sayısal işlevler şunlardır:
Syntax: SELECT ABS(-243.5); Output: 243.5
INSERT INTO city VALUES ('1', 'Adana', '2012-12-12', '2012-12-12'); | |
INSERT INTO city VALUES ('2', 'Adıyaman', '2012-12-12', '2012-12-12'); | |
INSERT INTO city VALUES ('3', 'Afyonkarahisar', '2012-12-12', '2012-12-12'); | |
INSERT INTO city VALUES ('4', 'Ağrı', '2012-12-12', '2012-12-12'); | |
INSERT INTO city VALUES ('5', 'Amasya', '2012-12-12', '2012-12-12'); | |
INSERT INTO city VALUES ('6', 'Ankara', '2012-12-12', '2012-12-12'); | |
INSERT INTO city VALUES ('7', 'Antalya', '2012-12-12', '2012-12-12'); | |
INSERT INTO city VALUES ('8', 'Artvin', '2012-12-12', '2012-12-12'); | |
INSERT INTO city VALUES ('9', 'Aydın', '2012-12-12', '2012-12-12'); | |
INSERT INTO city VALUES ('10', 'Balıkesir', '2012-12-12', '2012-12-12'); |
CREATE TABLE `coffees` | |
( | |
`id` INT(11) PRIMARY KEY AUTO_INCREMENT NOT NULL, | |
`title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci, | |
`slug` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci, | |
`description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci, | |
`status` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '', | |
`deleted_at` TIMESTAMP NULL DEFAULT NULL | |
) ENGINE = InnoDB; |
from aiohttp import web | |
import requests | |
routes = web.RouteTableDef() | |
@routes.get('/coffees') | |
async def get_coffees(request: web.Request) -> web.Response: | |
response = requests.get("https://api.sampleapis.com/coffee/hot") | |
if response.status_code in [200, 201]: |
import asyncio | |
async def hello(reader, writer): | |
data = await reader.read(100) | |
writer.write(b'hello world!') | |
await writer.drain() | |
writer.close() | |
async def main(): | |
server = await asyncio.start_server(hello, '127.0.0.1', 80) |
FROM maxmcd/gstreamer:1.14-buster | |
WORKDIR /usr/src | |
RUN apt-get update && apt-get install -y python3-pip \ | |
pkg-config \ | |
libcairo2-dev \ | |
gcc \ | |
python3-dev \ | |
libgirepository1.0-dev \ |
interface Book { | |
id: number; | |
title: string; | |
subject?: 'crime' | 'comedy'; | |
body: string; | |
} | |
type BookPreview = Omit<Book, "id" | "body">; | |
const book: BookPreview = { |
interface Book { | |
id: number; | |
title: string; | |
subject?: 'crime' | 'comedy'; | |
body: string; | |
} | |
type BookPreview = Pick<Book, "title" | "subject">; | |
const book: BookPreview = { |
interface Book { | |
id: number; | |
title: string; | |
subject?: 'crime' | 'comedy'; | |
body: string; | |
} | |
class BookRepository { | |
constructor(private model: Book | {} = {}) {} | |
create( model: Required<Book> ) { |
interface Book { | |
id: number; | |
title: string; | |
subject: 'crime' | 'comedy'; | |
body: string; | |
} | |
class BookRepository { | |
constructor(private model: Book) {} | |
update( model: Partial<Book> ) { |