handuy

GitLab SSH Config

This tutorial will help you to configure your GitLab SSH keys. Once configured, you should be able to clone repositories, push your changes and submit your pull requests to GitLab repositories via SSH.

Unless otherwise noted, all instructions are for the Window environment. If you are looking for instructions for Linux or MAC OS, please consult the official documentation instead.

Generating a New SSH Key

If not already installed, install Git for Windows.

handuy

-- Cập nhật cột SomayHVN_mapping ở bảng registration
update top (100) registration_2018 set SomayHVN_mapping = 'JF86E0036270'

update top (100) registration_2019 set SomayHVN_mapping = 'JF86E0036270'

-- Tạo bảng trung gian
create table report_1de (
    DEALER_CODE varchar(50), 
    deliver_tinh varchar(50), 
    Arrival_month int, 

handuy

-- Tạo bảng
CREATE TABLE [dbo].[deliver_2018](
	[DELIVERY_NO] [varchar](50) NULL,
	[DEALER_CODE] [int] NULL,
	[MODEL_CODE] [varchar](50) NULL,
	[TYPE_CODE] [varchar](50) NULL,
	[COLOR_CODE] [varchar](50) NULL,
	[F_HEADER] [varchar](50) NULL,
	[F_NO] [int] NULL,
	[E_HEADER] [varchar](50) NULL,

handuy

USE corona;
GO
BULK INSERT covid FROM '/COVID-19-geographic-disbtribution-worldwide (1).csv'
   WITH (
      FIRSTROW = 2,
      FIELDTERMINATOR = ',',
      ROWTERMINATOR = '\n'
);
GO

handuy

WEBVTT

1
00:00:00.000 --> 00:00:02.325
[MUSIC PLAYING]

2
00:00:05.427 --> 00:00:06.260
KAYCE BASQUES: Hola!

handuy

DROP TABLE IF EXISTS users CASCADE;

DROP TABLE IF EXISTS posts CASCADE;

DROP SCHEMA IF EXISTS course CASCADE;

CREATE TABLE users (id int PRIMARY KEY, name text, age int);

CREATE TABLE posts (id int PRIMARY KEY, title text, author_id int REFERENCES users(id));

handuy

DROP TABLE IF EXISTS users;

DROP TABLE IF EXISTS posts;

DROP SCHEMA IF EXISTS course CASCADE;

CREATE TABLE users (id int PRIMARY KEY, name text, age int);

CREATE TABLE posts (id int PRIMARY KEY, title text, author_id int REFERENCES users(id));

handuy

DROP TABLE IF EXISTS series;

CREATE TABLE series (id int, description text);

SELECT create_reference_table('series');

handuy

DROP TABLE IF EXISTS users;

DROP TABLE IF EXISTS posts;

DROP SCHEMA IF EXISTS course CASCADE;

CREATE SCHEMA course;

CREATE TABLE users (id int, name text, age int);

handuy

DROP TABLE IF EXISTS users;

DROP TABLE IF EXISTS posts;

CREATE TABLE users (id int, name text, age int);

CREATE TABLE posts (id int, title text);

SELECT create_reference_table('users');