With so many function provided in mysql plus lazy, It seem like finding gem for replace my old approach 🙂 duplicate data isn’t good, I must search for exisiting data, in general : insert data to table when no data with that value exist and update table if data exist For example : I have […]

My friend install serendipity (blog engine) in his laptop with mysql version 4.1.21 and dumping sql of his blog. When I try to restore sql file in his PC I got error message : Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\Administrator>cd c:\appserv\mysql\bin C:\AppServ\mysql\bin>mysql -uroot -p alam < blog.sql Enter […]

Simple way to insert time information in mysql is using now() now() will automatically insert appropriate depends on type, let say we have field in mysql database in these format : 1. birth (date), now() will insert current date, ex: 2007-05-02 2. birth (datetime), now() will insert current date + current time, ex : 2007-05-2 […]

Default install of Oracle XE only allow connection from localhost. For network access you need sysdba access. Login as “system” with propriate password Click the arrow near administration tab Change access into “available from local server and remote connection” and followed by click “Apply Changes” See confirmation message Logout and try login from network.