SQL Hacks: Tips & Tools for Digging Into Your Data"O'Reilly Media, Inc.", 21 lis 2006 - 412 Whether you're running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book will help you push the limits of traditional SQL to squeeze data effectively from your database. The book offers 100 hacks -- unique tips and tools -- that bring you the knowledge of experts who apply what they know in the real world to help you take full advantage of the expressive power of SQL. You'll find practical techniques to address complex data manipulation problems. Learn how to:
Let SQL Hacks serve as your toolbox for digging up and manipulating data. If you love to tinker and optimize, SQL is the perfect technology and SQL Hacks is the must-have book for you. |
Spis treści
| 1 | |
Joins Unions and Views | 27 |
Text Handling | 47 |
Date Handling | 62 |
Number Crunching | 83 |
Online Applications | 131 |
Organizing Data | 179 |
Storing Small Amounts of Data | 203 |
Locking and Performance | 223 |
Reporting | 265 |
Users and Administration | 315 |
Wider Access | 349 |
| 367 | |
Inne wydania - Wyświetl wszystko
Kluczowe wyrazy i wyrażenia
Access access_log affected 0.00 sec aglet Alan Alda application batch bigtable calculate clause column command command-line Company Store CREATE TABLE CREATE VIEW CROSS JOIN CURRENT_DATE CURRENT_USER cursor database system dbname default DELETE DESC die(mysql_error DROP TABLE error example Figure filename FOREIGN KEY GROUP H A C K Hack Hacking the Hack hash function Here’s includes INNER JOIN integers invoice isolation level Java Kevin Bacon LEFT OUTER JOIN Microsoft mysql NULL Oracle ORDER OUTER JOIN output parameters password performance Perl phpMyAdmin pivot table PostgreSQL PRIMARY KEY problem Query OK result set rows affected 0.00 rows in set Rows matched scott script SELECT name shown in Table SQL injection SQL injection attack SQL Server SQL statement string subquery transaction UNION SELECT UPDATE username variable weekBeginning XSLT
Popularne fragmenty
Strona 5 - Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 3.23.36 Type 'help;' or '\h
Strona 7 - jdbc:postgresql:propdb"; To create the property system tables, the psql interactive database program is used: kcl«pc109 "Ypgdata $ psql propdb Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands...