Kumpulan Sintak MYSQL

1. C:\Users\ZOMBIES>cd c:\

2. c:\>"xampp/mysql/bin/mysql.exe" -u root -p  //mengaktifkan XAMPP/mysql

3. mysql>create database NAMA_DATABESE;        //Membuat database baru

4. mysql>create table NAMA_TABLE(atribut typedata(jml_typedata),.......,......,dst )

5. mysql> show databases;                      //liat databases yg tersimpan

6. mysql> use db_penjualan_harefa;             //CARA MENGAKTIFKAN DATABASE YG KITA INGINKAN

7. mysql> show tables;                         //UTK LIAT TABEL

8. mysql> desc tb_barang;                      //LIAT FIELD YG DIINPUT

9. mysql> select*from tb_barang;             //nampilkan isi table

10. mysql>insert into tb_barang values("BRG03","Buku","20000");    //insert record dari field

11. mysql>delete from tb_barang where kd_brg="Brg05" ;  //hapus record

12. Mysql >alter table add Primary Key (kd_brg);  //menentukan Primary Key

13. Drop database Penjualan;               // mnghapus database

14. Mysql>update tb_barang set nm_brg=”Penggaris”, harga=1500 where kd_brg=”BRG01”;  //update isi table

15. Mysql>alter table tb_barang drop Primary Key;  //hapus primary key

16. Mysql >alter table tb_barang add Primary Key (kd_brg);  //add primary key

17. Mysql>alter table tb_barang add ket varchar(30) after nm_brg;  //nambah field

18. Mysql>alter table tb_barang change nm_brg nabar varchar(20);   //ubah nama field

19. Mysql>alter table tb_barang drop ket;   // Hapus field

20. Mysql> alter table namatabel drop column ket;  // kurangi column

21. Mysql>drop table tb_barang;   //hapus tble

22. Mysql>rename table tb_barang to tb_barang_baru;  //rename table

23. Mysql>update tb_barang set nm_brg=”Penggaris”, harga=1500 where kd_brg=”BRG01”;  //updatte

<!--- Currency Converter in your web site  www.forumforyou.it code ---->
<iframe allowtransparency="true" src="https://www.forumforyou.it/widget_utenti/cambio_valuta/cambio_valuta_eng1.htm" name="Flashgame" SCROLLING="no" marginwidth="0" margineight="0" hspace="0" vspace="0" frameborder="0" width="260" height="355"></iframe>
 <!--- Currency Converter in your web site www.forumforyou.it end code ---->

Read More