SQL Language

<?php $hostname = "localhost"; $username = "892823"; $password = "xxxxxx"; $db = "registrasi" ; $connect = mysql_connect($hostname, $username, $password); $database = mysql_select_db($db, $connect); $query="insert into registrasi(userid,nama,password,email) values ('$userid','$nama','$password','$email')"; $hasil=mysql_query($query); mysql_close($connect); ?> <<<<<<<<<<<< PERINTAH SQL ***** Membuat Table baru *********** CREATE TABEL [nama table] ( fields1 jenis(ukuran),fields1 jenis(ukuran)... ); contoh : CREATE TABLE siswa(NIS text(5),Nama text(10),kelas text(3)); ***** menambah rekord baru ********** INSERT INTO [nama table] (fields1,fields2,fields3) VALUES (nilai1,nilai2,nilai3); contoh : INSERT INTO siswa (NIS,nama,kelas) VALUES ("7872","Binar Mutia","X"); ***** mengubah rekord ********** UPDATE [nama table] SET [fields]=[nilai pengganti] WHERE fields_syrat=nilai_syrat; ****** menghapus rekord ********* DELETE FROM [nama table] WHERE fields_syrat=nilai_syrat;