Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Microsoft Windows [Version 6.1.7600]
- Copyright (c) 2009 Microsoft Corporation. ALL rights reserved.
- C:\Users\Aa>cd\xampp/mysql/bin & mysql -u root -p
- Enter password:
- Welcome TO the MySQL monitor. Commands END WITH ; OR \g.
- Your MySQL connection id IS 2
- Server version: 5.0.67-community-nt MySQL Community Edition (GPL)
- TYPE 'help;' OR '\h' FOR help. TYPE '\c' TO clear the buffer.
- mysql> CREATE DATABASE tanggal;
- Query OK, 1 ROW affected (0.00 sec)
- mysql> USE tanggal;
- DATABASE changed
- mysql> CREATE TABLE profil(
- -> id INT(3) AUTO_INCREMENT PRIMARY KEY,
- -> nama VARCHAR(30) NOT NULL,
- -> tanggal VARCHAR(20) NOT NULL
- -> );
- Query OK, 0 ROWS affected (0.03 sec)
- mysql> DESC profil;
- +---------+-------------+------+-----+---------+----------------+
- | FIELD | TYPE | NULL | KEY | DEFAULT | Extra |
- +---------+-------------+------+-----+---------+----------------+
- | id | INT(3) | NO | PRI | NULL | AUTO_INCREMENT |
- | nama | VARCHAR(30) | NO | | NULL | |
- | tanggal | VARCHAR(20) | NO | | NULL | |
- +---------+-------------+------+-----+---------+----------------+
- 3 ROWS IN SET (0.01 sec)
- mysql> INSERT INTO profil VALUES('','AaEzha','16-Agustus-1989');
- Query OK, 1 ROW affected, 1 warning (0.00 sec)
- mysql> SELECT * FROM profil;
- +----+--------+-----------------+
- | id | nama | tanggal |
- +----+--------+-----------------+
- | 1 | AaEzha | 16-Agustus-1989 |
- +----+--------+-----------------+
- 1 ROW IN SET (0.00 sec)
- mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement