January 01, 2002
PostgreSQL vs. MySQL (Web Techniques, Sep 2001)
To many people, PostgreSQL and MySQL seem like similar, alternative databases. Both are quickly gaining popularity. Based on the track records of older versions, there's a lot of debate over the speed of PostgreSQL and the durability of MySQL. But times have changed and each database has progressed. On both counts, the two packages are the closest they've ever been, so when deciding which to use in a Web application, a developer doesn't always have a clear winner.
// Find the highest salary:
rs = stmt.executeQuery("SELECT MAX(salary.salary) " +
"FROM salary");
rs.next();
int max_salary = rs.getInt(1);
// Downgrade all employees with that salary:
stmt.execute("UPDATE salary " +
"SET salary = salary * .75" +
"WHERE salary = " + max_salary);
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
Next Page
