Tips Cara Memasukkan Data Ke Dalam Table Di Mysql

mysql> DESCRIBE employee; +---------------+---------------+------+-----+---------+-------+ | Field         | Type          | Null | Key | Default | Extra | +---------------+---------------+------+-----+---------+-------+ | employee_id   | varchar(5)    | NO   | PRI | NULL    |       | | employee_name | varchar(20)   | NO   |     | NULL    |       | | gender        | char(1)       | NO   |     | NULL    |       | | address       | varchar(20)   | YES  |     | NULL    |       | | salary        | decimal(10,0) | YES  |     | NULL    |       | | departemen    | varchar(5)    | NO   |     | NULL    |       | +---------------+---------------+------+-----+---------+-------+ 6 rows in set (0.00 sec) 

Mari coba kita masukkan 5 data ke dalam table "employee" diatas,

INSERT INTO employee(employee_id, employee_name, gender, address, salary, departemen) VALUES('001','Nursalim','L','Jakarta',3000000,'IT');  INSERT INTO employee(employee_id, employee_name, gender, address, salary, departemen) VALUES('002','Naura','P','Bandung',2000000,'HRD');  INSERT INTO employee(employee_id, employee_name, gender, address, salary, departemen) VALUES('003','Ahmad','L','Semarang',5000000,'ACC');  INSERT INTO employee(employee_id, employee_name, gender, address, salary, departemen) VALUES('004','Nani','P','Surabaya',2500000,'FIN');  INSERT INTO employee(employee_id, employee_name, gender, address, salary, departemen) VALUES('005','Nurul','P','Tegal',4500000,'FIN'); 

Apabila Anda telah final memasukkan datanya, Anda sanggup menampilkannya memakai perintah SELECT menyerupai berikut ini:

mysql> SELECT * FROM employee; +-------------+---------------+--------+----------+---------+------------+ | employee_id | employee_name | gender | address  | salary  | departemen | +-------------+---------------+--------+----------+---------+------------+ | 001         | Nursalim      | L      | Jakarta  | 3000000 | IT         | | 002         | Naura         | P      | Bandung  | 2000000 | HRD        | | 003         | Ahmad         | L      | Semarang | 5000000 | ACC        | | 004         | Nani          | P      | Surabaya | 2500000 | FIN        | | 005         | Nurul         | P      | Tegal    | 4500000 | FIN        | +-------------+---------------+--------+----------+---------+------------+ 5 rows in set (0.02 sec)