Monday, November 29, 2010

jQuery Mobile | jQuery Mobile

jQuery Mobile | jQuery Mobile

Friday, November 19, 2010

Reset Mysql Root Password, windows

start at command prompt

net stop mysql

mysqladmin --skip-grant-tables

mysql -u root


mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD ('isi_password_baru') WHERE User='root';
mysql> FLUSH PRIVILEGES; 
mysql> quit;

net start mysql

Saturday, November 13, 2010

ORACLE FASTER NOT IN QUERY

Alternate to not in query
select table1.field1 from table1 where table1.field1 not in
(select table2.field1 from table2);
1st Rank using outer join:
SELECT table1.field1
FROM table1, table2
WHERE table1.field1 = table2.field1(+) and
table1.field1 is null;
2nd Rank using not exists:
SELECT table1.field1
FROM table1
WHERE NOT EXISTS (SELECT table2.field1 FROM table2 WHERE table1.field1 = table2.field1)
Enhanced by Zemanta

Friday, August 27, 2010

Oracle Makes Commitments to Customers, Developers and Users of MySQL

Oracle Makes Commitments to Customers, Developers and Users of MySQL

Thursday, August 12, 2010

Change database mode to archive mode

SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;