Carview!

CARVIEW

MOTORHOMES

Select Language

HTTP/2 302 server: nginx date: Wed, 30 Jul 2025 22:51:42 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20091101024319 location: https://web.archive.org/web/20091101024319/https://answers.oreilly.com/tag/sql server-timing: captures_list;dur=0.524560, exclusion.robots;dur=0.019407, exclusion.robots.policy;dur=0.008980, esindex;dur=0.011396, cdx.remote;dur=5.777257, LoadShardBlock;dur=116.387418, PetaboxLoader3.datanode;dur=53.047979, PetaboxLoader3.resolve;dur=51.463401 x-app-server: wwwb-app224 x-ts: 302 x-tr: 149 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 set-cookie: SERVER=wwwb-app224; 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, 30 Jul 2025 22:51:42 GMT content-type: text/html;charset=UTF-8 x-archive-orig-date: Sun, 01 Nov 2009 02:43:23 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=Sat, 01-Nov-2008 02:43:22 GMT; path=/; domain=.oreilly.com; httponly x-archive-orig-set-cookie: answers_session_id=deleted; expires=Sat, 01-Nov-2008 02:43:22 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: Sun, 01 Nov 2009 02:43:19 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="memento"; datetime="Sun, 01 Nov 2009 02:43:19 GMT", ; rel="next memento"; datetime="Tue, 24 Nov 2009 06:43:53 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_12_20091101011754_crawl101_IndexOnly-c/52_12_20091101024251_crawl100.arc.gz server-timing: captures_list;dur=0.745680, exclusion.robots;dur=0.026558, exclusion.robots.policy;dur=0.012210, esindex;dur=0.014409, cdx.remote;dur=20.020561, LoadShardBlock;dur=269.793425, PetaboxLoader3.datanode;dur=249.245744, PetaboxLoader3.resolve;dur=176.937819, load_resource;dur=224.170987 x-app-server: wwwb-app224 x-ts: 200 x-tr: 648 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

Share your knowledge

Top Contributors

carlaschroder

86 Answers
adfm

56 Answers
tmo9d

26 Answers
dannyg1

23 Answers
pauldubois

20 Answers

Topics: sql

1
VOTES

0
ALTERNATES
How to Use SQL to Search for Keywords Without the LIKE Operator
By andr3w
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 ...
27 October 2009 - 10:06 PM | 0 Comments
Tags:
sql server
postgresql
mysql
LIKE
sql
oracle
databases
data
1
VOTES

0
ALTERNATES
How to compute distances based on zip codes
By mike-loukides
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...
26 October 2009 - 12:20 PM | 0 Comments
Tags:
ruby
rails
jruby
enterprise
zip code
latitude
longitude
geocoding
map
database
sql
1
VOTES

0
ALTERNATES
How to Convert Subqueries to JOINs
By drgrussell
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, ...
24 October 2009 - 09:19 PM | 0 Comments
Tags:
sql
join
convert
subqueries
1
VOTES

0
ALTERNATES
Don’t Perform the Same Calculation Over and Over in SQL
By andr3w
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 ...
24 October 2009 - 06:46 PM | 0 Comments
Tags:
sql
select
view
subquery
0
VOTES

1
ALTERNATES
How to get a random sample in SQL
By odewahn1
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...
15 October 2009 - 06:36 AM | -1 Comments
Tags:
mysql
sql
databases
hacks
0
VOTES

0
ALTERNATES
How to use sequence generators as counters in MySQL
By pauldubois
If you’re interested only in counting events, use a sequence-generation mechanism that uses just one row per counter.AUTO_INCREMENTcolumns are useful for generating sequences across a ...
11 September 2009 - 06:04 PM | 0 Comments
Tags:
ruby
python
counter
sequence generator
sql
mysql
java
0
VOTES

0
ALTERNATES
How to use the SQL mode to control bad input data handling in MySQL
By pauldubois
By default, MySQL is forgiving about accepting data values that are invalid, out of range, or otherwise unsuitable for the data types of the columns into which you insert them. (...
11 September 2009 - 05:45 PM | 0 Comments
Tags:
bad data
sql
mysql
0
VOTES

0
ALTERNATES
How to add date or time values in MySQL
By pauldubois
To add date or time values, you have several options:Use one of the temporal-addition functions.Use the + INTERVAL or - INTERVAL operator.Convert the valu...
11 September 2009 - 10:03 AM | 0 Comments
Tags:
interval
mysql
time
temporal
date
sql
0
VOTES

0
ALTERNATES
How to choose a string data type in MySQL
By pauldubois
Choose the data type according to the characteristics of the information to be stored and how you need to use it. Consider questions such as these:Are the strings binary or nonbinary...
10 September 2009 - 03:04 PM | 0 Comments
Tags:
char
binary
types
strings
mysql
sql
0
VOTES

0
ALTERNATES
How to handle special characters in identifiers in MySQL
By pauldubois
If you need to construct SQL statements that refer to identifiers containing special characters, quote the identifiers so that they can be inserted safely into statement strings. The topic ca...
10 September 2009 - 01:14 PM | 0 Comments
Tags:
mysql
identifiers
special
characters
SQL
quote
strings

Pages:

Original Source | Taken Source