[tanya] delete isi tabel

Forum diskusi membahas database lain

Moderator: trail

[tanya] delete isi tabel

Postby ochels » 16 Mar 2011, 14:51

om smuanya yg master, bantuin donk gmn syntax mysql untuk menghapus isi smua tabel..?? :(
ochels
Prajurit Satu
Prajurit Satu
 
Posts: 81
Joined: 27 Jan 2011, 10:40
Memberi kopi: 0 cangkir
Mendapat kopi: 0 cangkir

Re: [tanya] delete isi tabel

Postby ekaperintis » 16 Mar 2011, 20:54

ochels wrote:om smuanya yg master, bantuin donk gmn syntax mysql untuk menghapus isi smua tabel..?? :(


kalau yang oom maksud menghapus record syntax SQL nya seperti ini oom :

Code: Select all
DELETE FROM <NamaTabel>;


Contoh :
Code: Select all
DELETE FROM DataMember;

Kalau berdasarkan kriteria tertentu seperti ini :

Code: Select all
DELETE FROM <NamaTabel> WHERE <Field>=isiRecord;


Contoh :

Code: Select all
DELETE FROM DataMember WHERE ID='ekaperintis;


Semoga membantu
Image
User avatar
ekaperintis
Sersan Satu
Sersan Satu
 
Posts: 2088
Joined: 17 Mar 2010, 14:27
Location: Parungpanjang-Bogor
Memberi kopi: 82 cangkir
Mendapat kopi: 154 cangkir

Re: [tanya] delete isi tabel

Postby pujanggabageur » 17 Mar 2011, 08:19

Wajib hukumnya mematuhi Peraturan Memposting!
Diajar babarengan
User avatar
pujanggabageur
Global Moderator
Global Moderator
 
Posts: 2817
Joined: 13 Mar 2010, 14:15
Location: di depan LCD ViewSonic
Memberi kopi: 159 cangkir
Mendapat kopi: 293 cangkir

Re: [tanya] delete isi tabel

Postby ochels » 24 Mar 2011, 10:04

ok udah bisa om.. mkshi ya oom smua..
ochels
Prajurit Satu
Prajurit Satu
 
Posts: 81
Joined: 27 Jan 2011, 10:40
Memberi kopi: 0 cangkir
Mendapat kopi: 0 cangkir


Return to Other Database Development

Who is online

Users browsing this forum: Google [Bot] and 2 guests