3.primary Key
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View 3.primary Key as PDF for free.
More details
- Words: 91
- Pages: 1
Untuk membuat table dengan primary key: CREATE TABLE jurusan( kodejurusan char(5) not null primary key, namajurusan varchar(50), jenjang char(2)) mysql> CREATE TABLE jurusan( -> kodejurusan char(5) not null primary key, -> namajurusan varchar(50), -> jenjang char(2)) -> ; Query OK, 0 rows affected (0.01 sec)
mysql> insert into jurusan values ("SI","SISTEM INFORMASI","S1"); Query OK, 1 row affected (0.00 sec) mysql> insert into jurusan values ("SK","SISTEM KOMPUTER","S1"); Query OK, 1 row affected (0.00 sec) mysql> mysql> insert into jurusan values ("SI","SISTEM INFORMASI","S1"); ERROR 1062 (23000): Duplicate entry 'SI' for key 1 mysql>
mysql> insert into jurusan values ("SI","SISTEM INFORMASI","S1"); Query OK, 1 row affected (0.00 sec) mysql> insert into jurusan values ("SK","SISTEM KOMPUTER","S1"); Query OK, 1 row affected (0.00 sec) mysql> mysql> insert into jurusan values ("SI","SISTEM INFORMASI","S1"); ERROR 1062 (23000): Duplicate entry 'SI' for key 1 mysql>
