CARVIEW

MOTORHOMES

Select Language

HTTP/2 302 server: nginx date: Wed, 16 Jul 2025 13:05:42 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20100302190842 location: https://web.archive.org/web/20100302190842/https://answers.oreilly.com/tag/sql server-timing: captures_list;dur=0.864409, exclusion.robots;dur=0.035198, exclusion.robots.policy;dur=0.015225, esindex;dur=0.021312, cdx.remote;dur=42.270763, LoadShardBlock;dur=521.137642, PetaboxLoader3.datanode;dur=178.173862, PetaboxLoader3.resolve;dur=103.744606 x-app-server: wwwb-app216 x-ts: 302 x-tr: 613 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 set-cookie: SERVER=wwwb-app216; path=/ x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() HTTP/2 200 server: nginx date: Wed, 16 Jul 2025 13:05:43 GMT content-type: text/html;charset=UTF-8 x-archive-orig-date: Tue, 02 Mar 2010 19:08:45 GMT x-archive-orig-server: Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 PHP/5.2.8 x-archive-orig-x-powered-by: PHP/5.2.8 x-archive-orig-set-cookie: answers_session_id=deleted; expires=Mon, 02-Mar-2009 19:08:44 GMT; path=/; domain=.oreilly.com; httponly x-archive-orig-set-cookie: answers_session_id=deleted; expires=Mon, 02-Mar-2009 19:08:44 GMT; path=/; domain=.oreilly.com; httponly x-archive-orig-cache-control: ,no-cachemust-revalidate, max-age=0 x-archive-orig-expires: 0 x-archive-orig-pragma: no-cache x-archive-orig-connection: close x-archive-guessed-content-type: text/html x-archive-guessed-charset: utf-8 memento-datetime: Tue, 02 Mar 2010 19:08:42 GMT link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate", ; rel="first memento"; datetime="Sun, 01 Nov 2009 02:43:19 GMT", ; rel="prev memento"; datetime="Thu, 04 Feb 2010 23:08:45 GMT", ; rel="memento"; datetime="Tue, 02 Mar 2010 19:08:42 GMT", ; rel="next memento"; datetime="Tue, 30 Mar 2010 12:20:35 GMT", ; rel="last memento"; datetime="Wed, 23 Jul 2014 13:08:52 GMT" content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org x-archive-src: 52_14_20100302143718_crawl102-c/52_14_20100302190333_crawl100.arc.gz server-timing: captures_list;dur=0.784844, exclusion.robots;dur=0.031555, exclusion.robots.policy;dur=0.014646, esindex;dur=0.016328, cdx.remote;dur=68.610335, LoadShardBlock;dur=371.635836, PetaboxLoader3.resolve;dur=346.057683, PetaboxLoader3.datanode;dur=299.600059, load_resource;dur=298.472615 x-app-server: wwwb-app216 x-ts: 200 x-tr: 899 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() content-encoding: gzip sql Questions and Answers - O'Reilly Answers

Jump to content

O'Reilly Answers

Clever Hacks. Creative Ideas. Innovative Solutions.

Share your knowledge

Welcome

Help

O'Reilly Answers is a community site for sharing knowledge, asking questions, and providing answers that brings together our customers, authors, editors, conference speakers, and Foo (Friends of O'Reilly). More »

Send us feedback
Feed icon

O'Reilly Answers Feed
Twitter icon

@oreillyanswers

Topics: sql

Feed Subscription Email Subscription

Ten Tips for Android Application Development

By zigurd : 09 December 2009 - 02:53 PM
Beginner tips Learn SQL and put your data models in a database Android has an excellent persistence system; use it to make your applications more robust in case of failure or shutdown, and to make s...
Tags:
4Votes

1Comment
jdbc sql question?

By xiaofanku : 06 December 2009 - 04:54 PM
i has sql statement:SELECT COUNT(*) FROM angle_dispatchemployee d INNER JOIN angle_comtract c ON d.deid=c.dispatchemployee_deid WHERE c.rstate=? AND d.state=? AND c.company_acid IN(?) c.rstate=0(or 1)...
Tags:
- java
- jdbc
- sql
0Votes

1Comment
How to Use HTML 5 Storage in Palm webOS

By steve@oreilly.com : 19 November 2009 - 04:21 PM
Palm webOS supports the HTML 5 Database object. The following excerpt from Palm webOS shows you how to create and query an SQL database using the HTML 5 Database object. By default, Palm webOS st...
Tags:
0Votes

0Comments
Is there an easy way to get the results of a SQL query into a new table?

Asked by MikeH : 19 November 2009 - 09:04 AM

Answered by KBenson : Nov 19 2009 01:04 PM
In MySQL you can use the result of a select for the values of an insert. mysql> create table t1 ( one int, two int, three char(10)); Query OK, 0 rows affected (0.09 sec) mysql> create table t... full answer >
Tags:
- sql
- data
- tables
- help
2Answers

0Comments
HTML 5 Storage for Palm webOS

By steve@oreilly.com : 02 November 2009 - 04:29 PM
Palm webOS includes support for the HTML 5 Database object to create, update, and query an SQL database. The HTML 5 database interfaces are asynchronous, requiring you to use callbacks for much of you...
Tags:
0Votes

0Comments
How to Use SQL to Search for Keywords Without the LIKE Operator

By andr3w : 27 October 2009 - 10:06 PM
You can do a simple keyword search using the LIKE operator. Unfortunately, this can be slow. Fortunately, an efficient keyword search is available in many systems.Often you must store ...
Tags:
1Vote

0Comments
How to compute distances based on zip codes

By mike-loukides : 26 October 2009 - 12:20 PM
If you're writing a web application, and you want to find places (restaurants, theaters) within a certain distance from your user, you'll probably need to work with zip codes. Here's a go...
Tags:
2Votes

0Comments
How to Convert Subqueries to JOINs

By drgrussell : 24 October 2009 - 09:19 PM
Sometimes you want to query one table, use that result to query another table, and then use that result to query yet another table. It’s tempting to do this as three separate queries, ...
Tags:
1Vote

0Comments
Don’t Perform the Same Calculation Over and Over in SQL

By andr3w : 24 October 2009 - 06:46 PM
The FROM clause of a SELECT statement may include other SELECT statements. This feature can simplify a complex statement. Sometimes using a derived table statement is the only way to get the results...
Tags:
2Votes

1Comment
How to get a random sample in SQL

By odewahn1 : 15 October 2009 - 06:36 AM
It can be a real pain to develop and test queries against really big tables. So, rather than query the entire table, you can use a simple trick to select a random sample (a smaller subset). Here...
Tags:
0Votes

0Comments

Pages:

Original Source | Taken Source