on Sabtu, 21 November 2009
-Cara melihat database di Mysql:
mysql> show databases;

-Cara bikin database:
mysql> create database [nama database];

-Di dalam database ada:
+ Tabel
- Field

- Record

-Cara masuk database:
mysql> use [nama database];


-Cara bikin tabel:
mysql> create table;

-Type data:
- String
- Char
- Varchar
- Integer
- Longint
- Double

-Cara bikin tabel:
mysql> create table [nama tabel] (nama varchar(20),kelas varchar(3),alamat varchar(50));

0 komentar: