Advertisement
Guest User

sql database

a guest
Sep 29th, 2017
471
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.91 KB | None | 0 0
  1. INSERT INTO Paket(ID_Paket, Harga_Paket)
  2. VALUES ('P0001',3000000),
  3.        ('P0002',2500000),
  4.        ('P0003',2000000);
  5.  
  6. INSERT INTO Employee(ID_Employee,Nama_Depan,Nama_Belakang,Nama_Belakang,Email,Nomor_Telepon,Gaji)
  7. VALUES ('E0001','Anthony',NULL,'Manager','70 Cool Guy','anthony@umn.ac.id','123-456-4565', 5000000),
  8.        ('E0002','Akino','Archilles','Chef','21 Kino Kino', 'akino@student.com', '354-124-5786', 3500000),
  9.        ('E0003','Kevin','Alexander','Cashier','34 Nishinoya', 'alex@yahoo.com','098-123-7832', 3000000),
  10.        ('E0004','Ivy','Marcia','Chef','06 Wall Street','ivy@yahoo.com','846-732-8427',3500000),
  11.        ('E0005','Martha','Saphia','Customer Service','78 Ruby Fort','martha@umn.ac.id','718-298-2873',3200000),
  12.        ('E0005','Nofiandy',NULL,'Cashier','03 Smooth Hair','nofiandy@gmail.com','516-927-9266',3250000),
  13.        ('E0006', 'Octavany',NULL,'Cashier','23 Relaxing Cafe','octa@iseng.com','653-876-1928',3150000);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement