Sandstorm750

C:\Program Files (x86)\Nmap>ncat httpbin.org 80 -C
GET /anything HTTP/1.1
Host: httpbin.org

HTTP/1.1 200 OK
Access-Control-Allow-Credentials: true
Access-Control-Allow-Origin: *
Content-Type: application/json
Date: Fri, 15 Mar 2019 18:48:53 GMT
Server: nginx

ziminator

GET запрос без параметров:

alex@ubuntu:~$ ncat -C httpbin.org 80
GET / HTTP/1.1
Host: httpbin.org

HTTP/1.1 200 OK
Access-Control-Allow-Credentials: true
Access-Control-Allow-Origin: *
Content-Type: text/html; charset=utf-8

KhIgorLe

ghfhfhfhf

infectedfate

mordecai=# CREATE TABLE categories (
id serial PRIMARY KEY,
title varchar(50));
CREATE TABLE

mordecai=# CREATE TABLE tests ( id serial PRIMARY KEY,
mordecai(# title varchar(25),
mordecai(# level int,
mordecai(# category_id int);
CREATE TABLE

akutarba

1.SQL (DDL):

-- Создайте базу данных test_guru
CREATE DATABASE test_guru;

-- Таблицу categories с атрибутом title 
CREATE TABLE categories (
   id serial PRIMARY KEY,
   title varchar(50) NOT null
);

IFilonov

# frozen_string_literal: true

namespace :routes do
  desc 'Поиск неприкрытых авторизацией роутов'
  task list_all_routes: :environment do
    controllers_actions = []
    controllers_actions << { controller: 'Контроллер',
                             action: 'Метод',
                             verb: 'Глагол',
                             path: 'Путь',

Pekhov

sqlite3 test_guru.db
sqlite> CREATE TABLE categories(
   ...> id INTEGER PRIMARY KEY AUTOINCREMENT,
   ...> title TEXT
   ...> );
sqlite> CREATE TABLE tests(
   ...> id INTEGER PRIMARY KEY AUTOINCREMENT,
   ...> title TEXT,
   ...> level INTEGER,
   ...> category_id INTEGER,

hookbil

PRAGMA foreign_keys=on;

create table categories (
id integer primary key autoincrement not null,
title text
);

create table tests (
id integer primary key autoincrement not null,
title text, 

Pekhov

C:\Users\Pekav>ncat -C httpbin.org 80
GET /anything HTTP/1.1
Host: httpbin.org

HTTP/1.1 200 OK
Connection: keep-alive
Server: gunicorn/19.9.0
Date: Mon, 22 Oct 2018 11:03:19 GMT
Content-Type: application/json
Content-Length: 245

DADUSHKA

postgres=# CREATE DATABASE test_guru;
CREATE DATABASE

postgres-# \c test_guru

test_guru=# CREATE TABLE categories(id serial PRIMARY KEY,title varchar(25));
CREATE TABLE
test_guru=# \dt
           List of relations
 Schema |    Name    | Type  |  Owner