salomo516.blogspot.com: November 2017

Thursday, November 23, 2017

Product Key Windows 10 for Activation via Phone

Windows 10 Phone Activation MAK-RETAIL Keys #Windows 10 MAK Keys capable to activate both Volume License & Retail Edition.# =========================================== Win 10 RTM Professional Volume:MAK slmgr.vbs -ipk N9M2T-MBJ4W-68KGB-Q2GCH-HXMQB ******************************************* Win 10 RTM Pro Retail slmgr.vbs -ipk GQT4N-87K8K-KGVP3-XXT8D-QRR9G slmgr.vbs -ipk J2JN2-MCTJ7-3RKVY-DCTR2-VFR9G slmgr.vbs -ipk JN87H-QT4CV-CBWBT-X7KCC-4RG6T slmgr.vbs -ipk JTFKT-RNVXX-4VY4G-RC4GQ-FM49G slmgr.vbs -ipk KY7NF-7QTPY-VMJQD-7TVHT-WXCKG slmgr.vbs -ipk M9XNB-MYQKK-2CCYH-C9WMQ-JTYP6 slmgr.vbs -ipk N2BF8-2KVXW-XYRHD-3PVPH-XD726 slmgr.vbs -ipk N2XYX-DMY3M-VB7PH-FXKX9-C7JXG slmgr.vbs -ipk N7TGG-G7BMJ-49Y88-PCKX3-2WF9G slmgr.vbs -ipk N84XF-6WK69-K3KXX-QC2W7-T3BP6 slmgr.vbs -ipk NFXVQ-2TJWJ-Q86HT-4VPT6-VCFC6 slmgr.vbs -ipk NH27R-YTMKJ-Q9TP4-GM4X3-63BP6 slmgr.vbs -ipk NK2PX-D47V4-3X3MX-2379V-6XXTT slmgr.vbs -ipk NMK43-JQVM3-7Q6KY-TX3MK-3RR9G slmgr.vbs -ipk NRHY2-34MRQ-PYCMT-B883W-J8F9G slmgr.vbs -ipk NXFX3-RH294-DGV3X-T7C8F-HQWXG slmgr.vbs -ipk P637D-VNBRD-WFR82-W2T99-WTYP6 slmgr.vbs -ipk QH74P-FNHYM-39MBG-42FQV-DRR9G slmgr.vbs -ipk QJNDC-6MKJB-QC3K2-XFKD6-MKMP6 slmgr.vbs -ipk QN3VX-H6T39-3W679-BVBGY-K766T slmgr.vbs -ipk RNJ7V-8M79J-YGW4Y-X8D2P-6JF9G ----------------------------- Win 10 RTM Pro N Volume:MAK slmgr.vbs -ipk RWR88-K7NYC-GK8FW-CC3XT-BP2KY ----------------------------- Win 10 RTM Pro N Retail slmgr.vbs -ipk P2TN-3TDW4-FQ8GV-WFK88-K2FDG ----------------------------- Win 10 RTM Enterprise Volume:MAK slmgr.vbs -ipk CY9JN-MJVG3-K2VFR-9CVWY-39MPF ------------------------------------------------------ Win 10 RTM EnterpriseS Volume:MAK ( Enterprise LTSB ) Product Key(s)---------------------------------Remaining Activation Counts Not available right now.! ------------------------------------------------------ Win 10 RTM EnterpriseSN Volume:MAK (Enterprise LTSB N) slmgr.vbs -ipk 84333-N23HF-CP6QV-DC9RT-P7JW9 ------------------------------------------------------ Win 10 RTM Education Volume:MAK Not available right now.! ******************************************* Win 10 RTM Education Retail Not available right now.! ------------------------------------------------------ Win 10 RTM Home Edition Retail Not available right now.! ------------------------------------------------------ [Tested working on VM3 14 March 2016] ================================================================================= More Info Windows 10 Phone-KMS Activation -- http://bit.ly/1mSpLRW Download Links Windows 10.0.10586 Version 1511 RTM MSDN -- http://bit.ly/1WQ1tV0 ================================================================================= Permanent Activation Windows 10 Via Phone ========================================= Step By Step Instruction: 1. Right click the start menu and choose "command prompt (admin)" 2. Type this script and hit Enter slmgr.vbs -ipk Product Key Example of Product Key: XXXXX-XXXXX-XXXXX-XXXXX-M98WY 3. You are still on "command prompt (admin)" ---- type: slui 4 4. Enter >> Select any country from the drop-down menu and click on Next. You will get Installation ID in this step 5. You will see some toll-free phone numbers which you can call. UK Free Call Skype Dial Number [+448000188354] l USA Free Call Skype Dial Number [+18007548300] l [url=https://www.microsoft.com/en-us/licensing/existing-customer/activation-centers.aspx]Worldwide telephone numbers[/url] l * Make sure have a microphone plugged into your PC in order for the dial pad to work ! * # If you don't have microphone plug in any JACK into your motherboard headphone port & use your soundbox to hear voice or Download & Install Skype for Mobile.# Full Skype conversation & respond the right answer to order to get successfully verification: Verification Numbers: For security reason please enter the following number using your touch-tone pad. == Dial the numbers using touch-tone pad robot speaker has given to you.=== --------------------------------------------------------------------- Press one as a home user and two if you are a business customer with a volume license agreement. ===DIAL 1 using touch-tone pad=== Press one if you have your Installation ID available if not press 2 ===DIAL 1 using touch-tone pad=== If you want to to activate Microsoft Product press one now if you activate office for Mac press two ===DIAL 2 using touch-tone pad=== --------------------------------------------------------------------- In this stage robot Speaker will ask your 9 group of Installation ID dial one by one using touch-tone pad Finally speaker will ask you last question: On how many computer is your product currently installed? *** DIAL 1 using your touch-tone pad.... *** In the end you will get Confirmation ID just type the ID in the activation wizard confirmation ID sectiction. Click ACTIVATE to finalize --- Done. : ) --------------------------------------------------------------------- Check your Windows Permanent Activation: cmd (admin) : slmgr.vbs -XPR ================================================================================= november_ra1n ================================================================================= Fake/Block key database: https://github.com/CNMan/balala =================================================================================

Thursday, November 16, 2017

PERINTAH FUNGSI SUM, COUNT, MAX, MIN, & AVG PADA MYSQL DENGAN CMD & Command Line Linux

Gak usah basa basi ya.... :D

Saya menggunakan command line di Linux, tapi jangan kuatir perintahnya gak berdeda dengan CMD di Windows. Hanya saja untuk mengaktifkan XAMPP Linux ya lewat command line.

Baca juga perintah dasar mysql cmd.

Ini dia.

Yah itu aja dah...

Semoga bermanfaat.

Salomo Silaban

salomo.tk

salomo@silaban-X455LAB:~$ sudo /opt/lampp/lampp start

[sudo] password for salomo:

Starting XAMPP for Linux 7.0.24-0...

XAMPP: Starting Apache...already running.

XAMPP: Starting MySQL...already running.

salomo@silaban-X455LAB:~$ /opt/lampp/bin/mysql -u root

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 7

Server version: 10.1.28-MariaDB Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> Create database Akademik;

Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> Use Akademik;

Database changed

MariaDB [Akademik]> Create table Tabel_MK (Kode_MK char(17),

-> Nama_MK char (30),

-> SKS int (1),

-> Semester int (1));

Query OK, 0 rows affected (0.38 sec)

MariaDB [Akademik]> Show databases;

+-----------------------+

| Database |

+-----------------------+

| Akademik |

| catatan |

| information_schema |

| latihan_android |

| mysql |

| pendaftaran_mahasiswa |

| performance_schema |

| phpmyadmin |

| test |

| wordpress |

+-----------------------+

10 rows in set (0.00 sec)

MariaDB [Akademik]> desc Tabel_MK;

+----------+----------+------+-----+---------+-------+

+----------+----------+------+-----+---------+-------+

| SKS | int(1) | YES | | NULL | |

| Semester | int(1) | YES | | NULL | |

+----------+----------+------+-----+---------+-------+

4 rows in set (0.10 sec)

MariaDB [Akademik]> Insert into Tabel_MK values ('14213201/15916313','Basis Data','2','3'),

-> ('14213202/15916413','Statistik Probabilitas','2','3'),

-> ('14213203/15916324','Matematika Diskrit','2','3'),

-> ('14213206/15916354','Teori Graph','2','3'),

-> ('14213404/15916343','Sistem Operasi','4','3'),

-> ('14213405/15916364','Rekayasa Perangkat Lunak','4','3'),

-> ('142AI2208/14784422','Arsitektur & Organisasi Komputer','2','2'),

-> ('142AP2210/14783053','Pendidikan Kewarganegaraan','2','2'),

-> ('142I2202/14784082','Logika Informatika','2','2'),

-> ('142I2403/14784082','Jaringan Komputer 1','4','2'),

-> ('142I2404/14783364','Struktur Data','4','2'),

-> ('142S2201/14838025','Praktikum Struktur Data','2','2'),

-> ('142AI12025/14498183','Pengantar Teknologi Informasi','2','1'),

-> ('142AP1204/14315645','Pendidikan Agama','2','1'),

-> ('142I1402/14530654','Konsep Bahasa Pemograman','2','1'),

-> ('142I1204/14266845','Algoritma & Pemograman','4','1'),

-> ('142I1403/14225363','Kalkulus','4','1'),

-> ('142I1405/14478324','Pengantar Basis Data','4','1'),

-> ('142S1202/14547914','Praktikum Pemograman','2','1'),

-> ('142S1201/14468603','Praktikum Internet','2','1');

Query OK, 20 rows affected, 5 warnings (0.18 sec)

Records: 20 Duplicates: 0 Warnings: 5

MariaDB [Akademik]> Select*from Tabel_MK;

+-------------------+--------------------------------+------+----------+

+-------------------+--------------------------------+------+----------+

| 14213201/15916313 | Basis Data | 2 | 3 |

| 14213202/15916413 | Statistik Probabilitas | 2 | 3 |

| 14213203/15916324 | Matematika Diskrit | 2 | 3 |

| 14213206/15916354 | Teori Graph | 2 | 3 |

| 14213404/15916343 | Sistem Operasi | 4 | 3 |

| 14213405/15916364 | Rekayasa Perangkat Lunak | 4 | 3 |

| 142AI2208/1478442 | Arsitektur & Organisasi Komput | 2 | 2 |

| 142AP2210/1478305 | Pendidikan Kewarganegaraan | 2 | 2 |

| 142I2202/14784082 | Logika Informatika | 2 | 2 |

| 142I2403/14784082 | Jaringan Komputer 1 | 4 | 2 |

| 142I2404/14783364 | Struktur Data | 4 | 2 |

| 142S2201/14838025 | Praktikum Struktur Data | 2 | 2 |

| 142AI12025/144981 | Pengantar Teknologi Informasi | 2 | 1 |

| 142AP1204/1431564 | Pendidikan Agama | 2 | 1 |

| 142I1402/14530654 | Konsep Bahasa Pemograman | 2 | 1 |

| 142I1204/14266845 | Algoritma & Pemograman | 4 | 1 |

| 142I1403/14225363 | Kalkulus | 4 | 1 |

| 142I1405/14478324 | Pengantar Basis Data | 4 | 1 |

| 142S1202/14547914 | Praktikum Pemograman | 2 | 1 |

| 142S1201/14468603 | Praktikum Internet | 2 | 1 |

+-------------------+--------------------------------+------+----------+

20 rows in set (0.00 sec)

MariaDB [Akademik]> Select SUM(SKS) as Total_SKS from Tabel_MK;

+-----------+

| Total_SKS |

+-----------+

| 54 |

+-----------+

1 row in set (0.05 sec)

MariaDB [Akademik]> Select SUM(SKS) as Total_SKS_Semester_1 from Tabel_MK where Semester='1';

+----------------------+

| Total_SKS_Semester_1 |

+----------------------+

| 22 |

+----------------------+

1 row in set (0.00 sec)

MariaDB [Akademik]> Select COUNT(Nama_MK) as Total_MK From Tabel_MK;

+----------+

| Total_MK |

+----------+

| 20 |

+----------+

1 row in set (0.00 sec)

MariaDB [Akademik]> Select COUNT(Nama_MK) as Total_MK_Semester_1 From Tabel_MK where Semester='1';

+---------------------+

| Total_MK_Semester_1 |

+---------------------+

| 8 |

+---------------------+

1 row in set (0.00 sec)

MariaDB [Akademik]> Select AVG(SKS) as Average_SKS From Tabel_MK;

+-------------+

| Average_SKS |

+-------------+

| 2.7000 |

+-------------+

1 row in set (0.00 sec)

MariaDB [Akademik]> Select AVG(SKS) as Average_SKS_Semester_1 From Tabel_MK where Semester='1';

+------------------------+

| Average_SKS_Semester_1 |

+------------------------+

| 2.7500 |

+------------------------+

1 row in set (0.00 sec)

MariaDB [Akademik]> Select MIN(SKS) as Min_SKS From Tabel_MK;

+---------+

| Min_SKS |

+---------+

| 2 |

+---------+

1 row in set (0.00 sec)

MariaDB [Akademik]> Select MAX(SKS) as Min_SKS From Tabel_MK;

+---------+

| Min_SKS |

+---------+

| 4 |

+---------+

1 row in set (0.00 sec)

MariaDB [Akademik]> Select MAX(Semester) as Max_Semester,COUNT(Nama_MK) as Total_MK,SUM(SKS) as Total_SKS from Tabel_MK;

+--------------+----------+-----------+

| Max_Semester | Total_MK | Total_SKS |

+--------------+----------+-----------+

| 3 | 20 | 54 |

+--------------+----------+-----------+

1 row in set (0.00 sec)

MariaDB [Akademik]> Select Semester, COUNT(*) as Total_MK, SUM(SKS) as Total_SKS

-> from Tabel_MK

-> group by Semester

-> order by Semester;

+----------+----------+-----------+

| Semester | Total_MK | Total_SKS |

+----------+----------+-----------+

| 1 | 8 | 22 |

| 2 | 6 | 16 |

| 3 | 6 | 16 |

+----------+----------+-----------+

3 rows in set (0.05 sec)

MariaDB [Akademik]> Ctrl-C -- exit!

Aborted

salomo@silaban-X455LAB:~$

http://www.salomo.tk/2017/11/perintah-fungsi-sum-count-max-min-avg.html

salomo516.blogspot.com

Thursday, November 23, 2017

Product Key Windows 10 for Activation via Phone

Thursday, November 16, 2017

PERINTAH FUNGSI SUM, COUNT, MAX, MIN, & AVG PADA MYSQL DENGAN CMD & Command Line Linux

KELAS XII MULTIMEDIA

Blogroll