Diff database structure with sqlyog

When requirement for information stored in database grow, old table structure need to adjust for flexibility. Common task to do in  normal cycle : 1. Build new application in other place 2. Synchronize database ( tables) 3. Upload application. Second step ( synchronize tables) often  painful when a lot of changes made at home and …

More

Some mysql sql basic command I must remember

I use phpmyadmin in daily environment, do I still know  sql command? My sql file too large, it’s hard to import using phpmyadmin, please help me Some question around mysql from my student, my false make them spoil using phpmyadmin all day long Here’s my answers : 1. Command to create database create database databasename …

More

Mysql 4.0 and Mysql 4.1 Compability

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 ...

More

Insert time in mysql using now()

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 …

More

Oracle XE for network access

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.