Cara Membuat Database MySQL
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\Miss_Niliswana>cd c:\xampp\mysql\bin
c:\xampp\mysql\bin>mysql -hlocalhost -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.45-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database diansafitri;
ERROR 1007 (HY000): Can't create database 'diansafitri'; database exists
mysql> create database diansafitri2;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cdcol |
| diansafitri |
| diansafitri2 |
| mysql |
| phpmyadmin |
| test |
| webauth |
+--------------------+
8 rows in set (0.05 sec)
mysql> use diansafitri2;
Database changed
mysql> create table pegawai(nip int(12),nama varchar(50),jabatan varchar(30));
Query OK, 0 rows affected (0.36 sec)
mysql> desc pegawai;
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| nip | int(12) | YES | | NULL | |
| nama | varchar(50) | YES | | NULL | |
| jabatan | varchar(30) | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
3 rows in set (0.30 sec)
mysql> alter pegawai add gaji int(12);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'pegaw
ai add gaji int(12)' at line 1
mysql> alter table pegawai add gaji int(12);
Query OK, 0 rows affected (0.09 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc pegawai;
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| nip | int(12) | YES | | NULL | |
| nama | varchar(50) | YES | | NULL | |
| jabatan | varchar(30) | YES | | NULL | |
| gaji | int(12) | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> alter table add jenis_kelamin varchar(15) after nip;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'add j
enis_kelamin varchar(15) after nip' at line 1
mysql> alter table pegawai add jenis_kelamin varchar(15) after nip;
Query OK, 0 rows affected (0.09 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc pegawai;
+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| nip | int(12) | YES | | NULL | |
| jenis_kelamin | varchar(15) | YES | | NULL | |
| nama | varchar(50) | YES | | NULL | |
| jabatan | varchar(30) | YES | | NULL | |
| gaji | int(12) | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql> alter table pegawai modify nama varchar(30);
Query OK, 0 rows affected (0.09 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc pegawai;
+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| nip | int(12) | YES | | NULL | |
| jenis_kelamin | varchar(15) | YES | | NULL | |
| nama | varchar(30) | YES | | NULL | |
| jabatan
