-=-
.
.....
  
| messages |
 
RSS
Direkomendasikan menggunakan brower Opera/Chrome/Firefox. Resolusi minimal 1024x768 | Powered by ____ |
 
KiOSS.Com
  
| Switch to Default View |
  
Nikmati Delphi-ID dalam berbagai versi tampilan :
Basic View (LOW Bandwidth)
Default View (Full)
Mobile Edition
Main Menu
..:: onWebTools ::..
..:: onLastPosts ::..
goto Postjumlah komponen maksimal dalam sebuah project(6)
 by d4mnf1y32
 on 21.May at 12:16
goto Posttanya grayscale to biner dengan scanline(1)
 by luckynvic
 on 20.May at 20:44
goto Posttanya looping biner to matriks(1)
 by luckynvic
 on 20.May at 20:10
goto Postsql error:acces denied for user....(2)
 by nasbms
 on 19.May at 16:54
goto Postpemanggilan frame(4)
 by nasbms
 on 19.May at 16:14
goto Posttanya AvLock(0)
 by azuriza
 on 19.May at 11:24
goto PostGet TDBEdit Value Menggunakan LookUp Grid(10)
 by henry_sys
 on 18.May at 11:27
goto Postmenghitung record dalam perulangan(4)
 by idhiel
 on 16.May at 13:53
goto Posttanya ascii(4)
 by mas_kofa
 on 16.May at 12:11
goto PostRawPrint Untuk Delphi XE2(0)
 by adewijaya
 on 15.May at 22:34
goto Postdatabase error..(4)
 by idhiel
 on 15.May at 15:57
goto Postbekasi, pt arila putra mahkota(3)
 by mas_kofa
 on 15.May at 15:37
goto Postbagaimana cara membaca file *.doc dg delphi?(0)
 by ficky
 on 15.May at 06:14
goto Posttanya biner to matriks(13)
 by diandewi
 on 14.May at 20:30

..:: onLast Articles ::..
..:: New Download ::..
Pascal-id.Org
Feeds -  Popular -  Latest
RE: The Longue
8 months, 3 weeks ago
RE: belajar pascal
8 months, 3 weeks ago
RE: The Longue
8 months, 3 weeks ago
RE: belajar pascal
8 months, 3 weeks ago
RE: Perkenalan dan Absen
8 months, 3 weeks ago
RE: Alhamdulillah Buka Puasa Bersama
8 months, 3 weeks ago
RE: تَقَبَّلَ اللهُ مِنَّا وَمِنْكَ - Selamat Hari Raya Idul Fitri
8 months, 3 weeks ago
Lintas Situs
«
free web site stats and visitor tracking
•   Forum FAQ  •  Search  • 

Reindex di MySQL
Delphi Indonesia Forum Index » Database » MySQL
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Author Message
StarboardOffline
Location: Semarang
19 Post subject: Reindex di MySQL  PostPosted: 05/Apr/2005 17:08
onSkilled


Joined: 28-Mar-2005
Posts: 94
Location: Semarang
Status: Offline
syntak reindex di mysql gimana yach
 
 View user's profile Send private message Yahoo Messenger  
Reply with quote Back to top
delphyOffline
Location:
Post subject: RE: baru belajar beneran  PostPosted: 06/Apr/2005 01:04
onIntermediate


Joined: 27-Mar-2005
Posts: 59

Status: Offline
gunakan perintah REPAIR
jika index korup, perintah ini akan me-reindex tabel.

      Code:

  REPAIR TABLE namatabel1, namatabel2, namatabel3

_________________
KIOSS Project, http://www.kioss.com
http://Delphi-Id.Com | http://postnuke-id.com
http://opensource-indonesia.com | http://mambo-id.com
 
 View user's profile Send private message Visit poster's website  
Reply with quote Back to top
StarboardOffline
Location: Semarang
Post subject: RE: baru belajar beneran  PostPosted: 06/Apr/2005 10:08
onSkilled


Joined: 28-Mar-2005
Posts: 94
Location: Semarang
Status: Offline
yup thq
 
 View user's profile Send private message Yahoo Messenger  
Reply with quote Back to top
putukacaOffline
Location:
Post subject:   PostPosted: 05/Mar/2007 17:35
onSkilled


Joined: 21-Sep-2005
Posts: 100

Status: Offline
jalaninnya peke Tquery ya atau yang lain? tolong contohnya dunk
 
 View user's profile Send private message  
Reply with quote Back to top
kaka-delphi
Location: Taziex
Post subject:   PostPosted: 05/Mar/2007 20:53
onElite


Joined: 12-Oct-2005
Posts: 1050
Location: Taziex
Tinggal di masukkin aja ke property 'SQL' nya, lalu Execute 

code : pascal
  1. with TQuery do
  2. begin
  3.   Close;
  4.   SQL.Clear;
  5.   SQL.Text:= 'REPAIR TABLE namatabel1, namatabel2, namatabel3 ';
  6.   ExecSQL;
  7. end;
Parsed in 0.002 seconds, using GeSHi
 
 View user's profile Send private message Visit poster's website Yahoo Messenger  
Reply with quote Back to top
putukacaOffline
Location:
Post subject:   PostPosted: 08/Mar/2007 21:53
onSkilled


Joined: 21-Sep-2005
Posts: 100

Status: Offline
nah cara nampilin kalo suatu tabel berhasil di repair gimana caranya. misalnya kta tampilkan di memo atau list box. contoh tampilannya:
Tabel a repair.......OK
Tabel b repair.......OK
dst
 
 View user's profile Send private message  
Reply with quote Back to top
onsirOffline
Location:
Post subject:   PostPosted: 02/Jun/2007 13:18
onKnowledgeable


Joined: 25-Jan-2007
Posts: 184

Status: Offline
apa bedanya SQL.Text dengan SQL.Add ( 'REPAIR TABLE namatabel1, namatabel2, namatabel3 ');
 
 View user's profile Send private message  
Reply with quote Back to top
nrkhlsmjdOffline
Location:
Post subject:   PostPosted: 02/Jun/2007 18:52
onNovice


Joined: 30-Apr-2007
Posts: 15

Status: Offline
sama aja......
CMIIW

_________________
http://nrkhlsmjd.wordpress.com
 
 View user's profile Send private message  
Reply with quote Back to top
adewijayaOffline
Location:
Post subject:   PostPosted: 07/May/2012 21:47
onBeginner


Joined: 08-Mar-2008
Posts: 7

Status: Offline
      putukaca wrote:
nah cara nampilin kalo suatu tabel berhasil di repair gimana caranya. misalnya kta tampilkan di memo atau list box. contoh tampilannya:
Tabel a repair.......OK
Tabel b repair.......OK
dst


Kalau mau nampilin satu persatu seperti itu kayaknya perintahnya juga harus satu persatu, kurang lebihnya kayak gini

with TQuery do
begin
Active:=false;
SQL.Clear;
SQL.Text:= 'REPAIR TABLE namatabel1';
ExecSQL;

Label1.Caption:='Tabel a repair...OK';

Active:=false;
SQL.Clear;
SQL.Text:= 'REPAIR TABLE namatabel2';
ExecSQL;

Label2.Caption:='Tabel b repair...OK';
end;

Kurang lebih seperti itu...
 
 View user's profile Send private message  
Reply with quote Back to top
henry_sysOffline
Location:
Post subject:   PostPosted: 11/May/2012 09:45
onIntermediate


Joined: 24-Sep-2011
Posts: 34

Status: Offline
      onsir wrote:
apa bedanya SQL.Text dengan SQL.Add ( 'REPAIR TABLE namatabel1, namatabel2, namatabel3 ');

SQL.Text maksudnya query yang lama yg ada di TQuery akan di timpa dengan query yang baru
makanya kalau menggunakan SQL.Text kita tidak perlu Menuliskan sintax SQL.Clear pada baris sebelum SQL.Text
Sedangkan SQL.Add maksudya Query yang lama akan ditambah dengan Query yang baru makanya kalau mengganti query secara utuh harus menambahkan syntax SQL.Clear sebelum Sql.Add.
 
 View user's profile Send private message  
Reply with quote Back to top
Display posts from previous:     
Jump to:  
All times are GMT - 12 Hours
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
 Delphi Indonesia Forum Index » Database »  MySQL





Powered by PNphpBB2 © 2003-2009 The Zafenio Team
Credits


| Register | Lost Password ? |