In SQL, View performs the notable role by storing complicated SQL query into a virtual table. In other words, SQL View is stored/saved SQL query. Many users scrabbled while updating/editing the view. Reason is simple, there is no single click option available on screen to do so.
Tuning MYSQL query performance tambahkan di my.cnf : 1. set query_cache_type = 1. (ada beberapa nilai yang mungkin : 0 (disable / off), 1 (enable / on) and 2 (on demand). query-cache-type = 1 2 set query_cache_size = sesuai kemampuan RAM, yang direkomendasikan 20MB. query-cache-size = 20M MySQL Tunner : 1. wget http://mysqltuner.com/mysqltuner.pl 2. #chmod …
Ga bs akses phppgadmin dari luar? coba ini ganti passwordALTER USER postgres ENCRYPTED password ‘postgres’; edit pg_hba.conf ksh comment baris ini#local all all ident sameuser tambahain baris ini local all postgres ident sameuser local all all password
login as postgre(in windows right click cmd.exe, run as postgre)pindah ke folder To dump a database: To dump a database: $ pg_dump mydb > db.out To reload this database: $ psql -d database -f db.out To dump a database called mydb that contains large objects to a tar file: $ pg_dump -Ft -b mydb > …
Damn, selalu aj lupa yg satu ini. Mending gw tulis aj deh.. Backup mysqldump -u [username] -p [password] [databasename] > [backupfile.sql] sample : mysqldump -u sadmin -p pass21 Customers > custback.sql Restoremysql -u USER -p DBNAME < dump.sql
CREATE TABLE xusd_2 SELECT NAMA, ALAMAT1, ALAMAT2, ALAMAT3, NOPOLIS, NO_REK, NAMA_TTG, KD_PROD, TGL_MASUK, CARABYR FROM xusd WHERE 1;
This is a another ways to do it, without install somthing in’r machine This information applies to a single table.1) Export data from Access 2000 to a delimited text file.2) Create an appropriate table on the MySQL server.3) Import the delimited text file into the MySQL table.1. Open Access 20002. Export the table to a …
Mungkin pernah punya masalah sama dengan saya, kantor ada database lama dbf, yg dulunya ex dari aplikasi foxpro sedangkan datanya perlu di convert ke mysql. No Problemo.. Tinggal browsing ke google. Satu menit, 2 menit, bukannya dapet solusi malah tambah bingung. Yang ada cuman program2 shareware/trialware doank. Harga-nya gila2an lagi. Hehee. Ga ush khawatir bro, …
Konversi dari DBF, Excel, CSV ke mySQL, SQL Server, postgreSQL Read More »
Meski udh bbrp kali install postgresql di linux masih aj kdg2 ad yg kelupaan. uugh..Mending gw buat tutorialnya aj. Biar lain kali kalau lupa tinggal nyontek blog gw. hehee install Fedora dari packet DVD/CD (ini sih udh pasteee) 1. #service postgresql initdb2. #service postgresql start3. #su postgres4. $psql5. #create user bob createuser createdb password ‘sa’;#create …
