jQuery Mobile | jQuery Mobile

jQuery Mobile | jQuery Mobile

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

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)

Oracle Makes Commitments to Customers, Developers and Users of MySQL

Oracle Makes Commitments to Customers, Developers and Users of MySQL

Change database mode to archive mode

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