Fungsi String My SQL

CREATE DATABASE UTAMA;
USE UTAMA;

CREATE TABLE PEGAWAI
(
no_pegawai varchar (5) not null,
nm_dpn_pegawai varchar (30) not null,
nm_blkng_pegawai varchar (30) not null,
jenis_kelamin text,
tempat_lahir text,
tgl_lahir date,
jabatan text,
PRIMARY KEY(no_pegawai)
);

show tables;
desc PEGAWAI;
SELECT*FROM PEGAWAI;

insert into PEGAWAI values('1','Wawan','Setiawan','L','Jakarta','1970-06-14','Manajer Marketing');
insert into PEGAWAI values('2','Uus','Djayusman','L','Bandung','1958-12-27','Wakil Man. Marketing');
insert into PEGAWAI values('3','Bucek','Haryadi','L','Jakarta','1972-09-24','Staf Marketing');
insert into PEGAWAI values('4','satya','Gunawan','L','Jakarta','1977-12-12','Staf Marketing');
insert into PEGAWAI values('5','Adi','Prawiro','L','Surabaya','1979-05-23','Staf Marketing');
insert into PEGAWAI values('6','Bondan','Triadi','L','Jakarta','1970-01-27','Konsultan Lepas');
insert into PEGAWAI values('7','Budi','Prakoso','L','Bogor','1971-08-06','Manajer IT');
insert into PEGAWAI values('8','Dede','Rahmawati','L','Cirebon','1973-12-17','Staf IT');
insert into PEGAWAI values('9','Hasan','Utoyo','L','Semarang','1976-11-13','Staf IT');
insert into PEGAWAI values('10','Didi','Junaedi','L','Jember','1978-09-14','Tenaga Lepas');
insert into PEGAWAI values('11','Bobby','Lukito','L','Jakarta','1969-08-11','Staf Ssales');
insert into PEGAWAI values('12','Ferry','Affandi','L','Solo','1971-08-16','Staf Sales');
insert into PEGAWAI values('13','Wahyu','Ningsih','L','Jakarta','1965-09-04','Kepala Bengkel');
insert into PEGAWAI values('14','Eep','Saifuddin','L','Medan','1964-09-10','Kepala HRD');
insert into PEGAWAI values('15','Fifi','Romansa','P','Bogor','1976-04-16','Staf HRD');

SELECT*FROM PEGAWAI;

desc PEGAWAI;
SELECT*FROM PEGAWAI;
select tempat_lahir from PEGAWAI order by tempat_lahir;
select nm_dpn_pegawai,nm_blkng_pegawai, length(nm_dpn_pegawai) from PEGAWAI order by length(nm_dpn_pegawai) desc;
select  left(nm_blkng_pegawai,4) from PEGAWAI order by nm_blkng_pegawai;
select concat(upper(nm_dpn_pegawai),nm_blkng_pegawai)  from PEGAWAI;
select jabatan, length(jabatan) from PEGAWAI order by length(jabatan) desc;

by Get This Widget

Artikel Terkait