Newbie Area Revolution

I just known, that Firebird have DDL (Data Definition Language) for DROP+CREATE store procedure in one go. so instead of "CREATE PROCEDURE test; ALTER PROCEDURE test;" or "DROP PROCEDURE test; CREATE PROCEDURE test;" you can just "RECREATE PROCEDURE test;" and boom! done 😎.

select * from information_schema.tables a where a.table_catalog = 'YOUR_DB_NAME' -- optional and a.table_schema != 'information_schema' and a.table_schema not like 'pg_%' and a.table_type = 'BASE TABLE' -- table and a.table_type = 'VIEW' -- view

solved: http://stackoverflow.com/questions/19204816/login-disallowed-for-security-reasons-postgresql-centos-server

http://sol.gfxile.net/galaxql.html  (interaktif) http://sql.learncodethehardway.org/book/  (contohnya banyak) http://sqlzoo.net/wiki/SQL_Tutorial  (bisa langsung coba) Sumber:  http://christopherpound.com/so-you-want-to-be-a-web-developer/

Unistall XAMPP delete XAMPP directory (C:\xampp) (Re)install XAMPP

Software/aplikasi yang digunakan: XAMPP Web Server (atau EasyPHP, MAMP, WampServer, etc) Text Editor (Notepad, Notepad++, Sublime Text, etc) sebuah Operation System (Sistem Operasi) Programming Language (PHP. Sudah satu paket bersama XAMPP) Database Client (MySQL. Sudah satu paket bersama XAMPP) Brainware (Otak anda). Apa itu RDBMS..., ?