MySQL Instruction

Download this material
Steps following in do MySQL instruction at Command Prompt

Activating Command Prompt   Start> Run> Type “ cmd ” or “ command prompt ”> OK

Activating Mysql C:>”Files's program>xampp>mysql>bin>mysql. exe ” –u root –p then enter

Making Database mysql> create is database nama_database ;

For example make rumah_sakit database:  mysql> create is rumah_sakit database;

Cheque Database mysql> show database;

Erasing Database mysql> drop database nama_database ;

For example erase rumah_sakit database:  mysql> drop rumah_sakit database;

Activating Database mysql> use database_name;

For example activate rumah_sakit database:  mysql> use rumah_sakit;

Making table

For example wants to make data_saya table with field: 

no., data type is integer,long 2

name,varchar's data type,long 10

address,varchar's data type,long 15

mysql> create table data_saya

-> (

-> no. int (2 ),

-> name varchar(10),

-> address varchar(15)

-> );

Seeing table in active database mysql> show tables;

Seeing table in database that don't active mysql> show tables from database_name;

For example sees from rumah_sakit database:  mysql> show tables from rumah_sakit;

Seeing table structure in active database mysql> desc nama_tabel;

For example see data_saya table structure:  mysql> desc rumah_sakit;

Seeing table structure in database that don't active  mysql> show fields from table_nama from database_name ;

For example see data_saya table of rumah_sakit database:  mysql> show fields from data_saya from rumah_sakit;

Changing table structure

For example wants to rename no. to number, making it as primary and not null:

mysql> alter table data_saya

-> change no. number

-> int (2 )

-> primary

-> not null;

Changing table name

For example wants to rename data_saya as data_ku

mysql> alter table data_saya

-> rename data_ku

Filling Record in Active Database mysql> insert into table_name values(‘ field1 ’ ,’ field field ’,dst);

Example fills data_saya with 1,ryan,jogja

mysql> insert into data_saya values (1,’ryan’,’jogja’);

Featuring Record mysql> select *from table_name;

For example features record data_saya:  mysql> select * from data_saya;
Download this material