MySQL Kodları CREATE SCHEMA companydb DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;

CREATE TABLE companydb.customers ( customer_id INT NOT NULL AUTO_INCREMENT, first_name VARCHAR(50) NOT NULL, last_name VARCHAR(55) NULL, PRIMARY KEY (customer_id));

INSERT INTO companydb.customers (first_name, last_name) VALUES ('Selahattin', 'Dişli'); INSERT INTO companydb.customers (first_name, last_name) VALUES ('Adem', 'Kok'); INSERT INTO companydb.customers (first_name, last_name) VALUES ('Barış', 'Tatar'); INSERT INTO companydb.customers (first_name, last_name) VALUES ('Dilşat', 'Şentürk');

SELECT * FROM companydb.customers;

PostgeSQL Kodları CREATE SCHEMA companydb AUTHORIZATION postgres;

CREATE TABLE companydb.customers ( customer_id serial NOT NULL, first_name character varying(50), last_name character varying(55), PRIMARY KEY (customer_id) );

ALTER TABLE IF EXISTS companydb.customers OWNER to postgres;

INSERT INTO companydb.customers (first_name, last_name) VALUES ('Selahattin', 'Dişli'); INSERT INTO companydb.customers (first_name, last_name) VALUES ('Adem', 'Kok'); INSERT INTO companydb.customers (first_name, last_name) VALUES ('Barış', 'Tatar'); INSERT INTO companydb.customers (first_name, last_name) VALUES ('Dilşat', 'Şentürk'); INSERT INTO companydb.customers (first_name, last_name) VALUES ('İlyas', 'Bakır');

SELECT * FROM companydb.customers;