perl5maven.com: Calculating bank balance, take two: DBD::CSV
Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts
Friday, September 7, 2012
Monday, July 30, 2012
O'Reilly Media book: PostgreSQL: Up and Running
PostgreSQL: Up and Running: 
If you’re thinking about migrating to the PostgreSQL open source database system, this guide provides a concise overview to help you quickly understand and use PostgreSQL’s unique features. Not only will you learn about the enterprise class features in the 9.2 release, you’ll also discover that PostgeSQL is more than just a database system—it’s also an impressive application platform. With numerous examples throughout this book, you’ll learn how to achieve tasks that are difficult or impossible in other databases.
If you’re thinking about migrating to the PostgreSQL open source database system, this guide provides a concise overview to help you quickly understand and use PostgreSQL’s unique features. Not only will you learn about the enterprise class features in the 9.2 release, you’ll also discover that PostgeSQL is more than just a database system—it’s also an impressive application platform. With numerous examples throughout this book, you’ll learn how to achieve tasks that are difficult or impossible in other databases.
Sunday, April 29, 2012
Tuesday, January 24, 2012
O'Reilly Media book: MySQL Troubleshooting
MySQL Troubleshooting: 
Sometimes applications can go mad: tables contain wrong data, users get random replies, server stop working, and so on. Several easy methods allow users to often find the problems quickly. This book, based on successful conference presentations by the author, cover SQL problems, memory and other server problems, replication, and problems related to particular storage engines.
Sometimes applications can go mad: tables contain wrong data, users get random replies, server stop working, and so on. Several easy methods allow users to often find the problems quickly. This book, based on successful conference presentations by the author, cover SQL problems, memory and other server problems, replication, and problems related to particular storage engines.
Thursday, January 5, 2012
book: SQL and Relational Theory - O'Reilly Media
SQL and Relational Theory: 
SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put the theory into practice. In this insightful book, author C.J. Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it directly to your use of SQL.
SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put the theory into practice. In this insightful book, author C.J. Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it directly to your use of SQL.
Saturday, July 23, 2011
Tuesday, July 19, 2011
SQL: Limiting the Number of Rows Returned
SQL Cookbook - O'Reilly Media
Problem
You want to limit the number of rows returned in your query. You are not concerned with the order; any n rows will do.
Solution
Use the built-in function provided by your database to control the number of rows returned.
DB2
…
MySQL and PostgreSQL
Do the same thing in MySQL and PostgreSQL using LIMIT:
…
SQL Server
…
Discussion
…
Chapter 1 Retrieving Records: Limiting the Number of Rows Returned.
Problem
You want to limit the number of rows returned in your query. You are not concerned with the order; any n rows will do.
Solution
Use the built-in function provided by your database to control the number of rows returned.
DB2
…
MySQL and PostgreSQL
Do the same thing in MySQL and PostgreSQL using LIMIT:
select * from emp limit 5
Oracle
…
SQL Server
…
Discussion
…
Monday, July 18, 2011
PostgreSQL: Documentation: Manuals: PostgreSQL 9.0: LIMIT and OFFSET
PostgreSQL: Documentation: Manuals: PostgreSQL 9.0: LIMIT and OFFSET:
"LIMIT and OFFSET allow you to retrieve just a portion of the rows that are generated by the rest of the query"
Friday, July 1, 2011
PostgreSQL: Manuals
PostgreSQL: Manuals
Maybe you appreciate the variants with user comments, or maybe you want to submit a comment yourself.
Maybe you appreciate the variants with user comments, or maybe you want to submit a comment yourself.
Thursday, June 30, 2011
Monday, June 27, 2011
Sunday, June 26, 2011
O'Reilly Media book: SQL in a Nutshell, Third Edition
SQL in a Nutshell, Third Edition - O'Reilly Media
Update 2011-07-01:
Ordered a used copy at Amazon.de for about € 10 (with Amazon Prime service, i.e. delivery tomorrow). Could have had that idea earlier. Better late than never. (I assume, I had ordered the e-book for USD 5 (for o'Reilly (community) "members"), when it got released.) But it's always nice to have a hard copy, isn't it? Esp. for € 10.
Update 2011-07-01:
Ordered a used copy at Amazon.de for about € 10 (with Amazon Prime service, i.e. delivery tomorrow). Could have had that idea earlier. Better late than never. (I assume, I had ordered the e-book for USD 5 (for o'Reilly (community) "members"), when it got released.) But it's always nice to have a hard copy, isn't it? Esp. for € 10.
Friday, June 24, 2011
SQuirreL SQL Client – an SQL GUI implemented in Java
SQuirreL SQL Client Home Page
Q: How to uninstall the app on Mac OS X?
A: /Applications/SQuirreLSQL.app/uninstall
Q: How to uninstall the app on Mac OS X?
A: /Applications/SQuirreLSQL.app/uninstall
Thursday, June 23, 2011
Subscribe to:
Posts (Atom)
