Sample DB Importer Queries - Revision history

Admin: /* For example, if your database table is named "store_locations": */

2010-02-03T13:52:31Z

‎For example, if your database table is named "store_locations":

Admin: Protected "Sample DB Importer Queries": Excessive vandalism ([edit=autoconfirmed] (indefinite))

2009-11-02T21:07:36Z

Protected "Sample DB Importer Queries": Excessive vandalism ([edit=autoconfirmed] (indefinite))

Admin: Undo revision 29 by 65.111.184.207 (Talk)

2009-09-02T21:44:04Z

Undo revision 29 by 65.111.184.207 (Talk)

New page

===For example, if your database table is named "store_locations":===

SELECT * FROM store_locations

(It will pull all information from your 'store_locations' table into the Store Locator admin interface in order to be matched to the "wp_store_locator")

===If you would like to import 200 locations at a time, so you don't overwhelm your database:===

SELECT * FROM store_locations LIMIT 200

===If for instance your "phone" field has numbers in the format ##########, but you want it to look like (###) ###-####:===

UPDATE wp_store_locator SET sl_phone = CONCAT( "(", SUBSTRING( sl_phone, 1, 3 ) , ") ", SUBSTRING( sl_phone, 4, 3 ) , "-", SUBSTRING( sl_phone, 7, 4 ) )

(Note: If your WordPress prefix isn't "wp_", then update "wp_store_locator" in the below query to "{your WordPress prefix}store_locator")

@@ Line 1: / Line 1: @@
-===For example, if your database table is named "store_locations":===
+===For example, if the original database table that you want to import locations from is named "store_locations", you can do the following:===
 SELECT * FROM store_locations
 (It will pull all information from your 'store_locations' table into the Store Locator admin interface in order to be matched to the "wp_store_locator")
 ===If you would like to import 200 locations at a time, so you don't overwhelm your database:===

← Older revision	Revision as of 21:07, 2 November 2009
(No difference)