O'Reilly Answers

Topics: SQL   

• How to Use HTML 5 Storage in Palm webOS

  

  By steve@oreilly.com

  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...

  19 November 2009 - 04:21 PM | 0 Comments
  Tags:

  • webOS
  • Palm
  • database
  • SQL

  0Votes

  0Alternates

  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

  3Interested

  0Comments

  ---

• HTML 5 Storage for Palm webOS

  

  By steve@oreilly.com

  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...

  02 November 2009 - 04:29 PM | 0 Comments
  Tags:

  • html 5
  • palm pre
  • storage
  • database
  • mobile
  • web
  • webos
  • sql

  0Votes

  0Alternates

  0Comments

  ---

• 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

  1Vote

  0Alternates

  0Comments

  ---

• 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

  1Vote

  0Alternates

  0Comments

  ---

• 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

  1Vote

  0Alternates

  0Comments

  ---

• 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

  1Vote

  0Alternates

  0Comments

  ---

• 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

  0Votes

  1Alternate

  0Comments

  ---

• 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

  0Votes

  0Alternates

  0Comments

  ---

• 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

  0Votes

  0Alternates

  0Comments

  ---