MSSQL
Volkan ŞENGÜL
Yazılımcı'nın Seyir Defteri
@volkansengul
SQL Nedir?
Structured Query Language
Verilerin / veri kümlerinin Modellenmesi, yönetilmesi için kullanılan dildir.
RDBMS?
Relational Database Management System
MySQL?
Relational Database Management System
Schema
CREATE SCHEMA `aytungaDb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
Table
create table aytungadb.customersz (
id INT NOT NULL AUTO_INCREMENT,
first_name VARCHAR(45),
surname VARCHAR(45),
email VARCHAR(60),
PRIMARY KEY(id)
)
ENGINE = innoDB
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;SELECT
SELECT * FROM customers;Tüm veriyi çekmek
SELECT id, first_name, surname FROM customers;Belirli kolonları çekmek
INSERT
create table aytungadb.customersz (
id INT NOT NULL AUTO_INCREMENT,
first_name VARCHAR(45),
surname VARCHAR(45),
email VARCHAR(60),
PRIMARY KEY(id)
)
ENGINE = innoDB
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;UPDATE
create table aytungadb.customersz (
id INT NOT NULL AUTO_INCREMENT,
first_name VARCHAR(45),
surname VARCHAR(45),
email VARCHAR(60),
PRIMARY KEY(id)
)
ENGINE = innoDB
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;DELETE
create table aytungadb.customersz (
id INT NOT NULL AUTO_INCREMENT,
first_name VARCHAR(45),
surname VARCHAR(45),
email VARCHAR(60),
PRIMARY KEY(id)
)
ENGINE = innoDB
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;UPSERT
create table aytungadb.customersz (
id INT NOT NULL AUTO_INCREMENT,
first_name VARCHAR(45),
surname VARCHAR(45),
email VARCHAR(60),
PRIMARY KEY(id)
)
ENGINE = innoDB
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;DEMO !
Teşekkürler
MsSQL Temel Eğitim
By Volkan Şengül
