HTTP/2 302 server: nginx date: Sat, 19 Jul 2025 19:43:46 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20091226051927 location: https://web.archive.org/web/20091226051927/https://answers.oreilly.com/rss/tags/mysql server-timing: captures_list;dur=0.686568, exclusion.robots;dur=0.027987, exclusion.robots.policy;dur=0.012559, esindex;dur=0.014088, cdx.remote;dur=46.573220, LoadShardBlock;dur=140.958155, PetaboxLoader3.datanode;dur=60.141305, PetaboxLoader3.resolve;dur=57.458499 x-app-server: wwwb-app204 x-ts: 302 x-tr: 225 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 set-cookie: SERVER=wwwb-app204; 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: Sat, 19 Jul 2025 19:43:48 GMT content-type: text/xml; charset=UTF-8 content-length: 6077 x-archive-orig-date: Sat, 26 Dec 2009 05:19:25 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=Fri, 26-Dec-2008 05:19:24 GMT; path=/; domain=.oreilly.com; httponly x-archive-orig-set-cookie: answers_session_id=deleted; expires=Fri, 26-Dec-2008 05:19:24 GMT; path=/; domain=.oreilly.com; httponly x-archive-orig-expires: Sat 26 Dec 2009 05:19:27 AM GMT GMT x-archive-orig-cache-control: must-revalidate, post-check=0, pre-check=0 x-archive-orig-pragma: public x-archive-orig-content-length: 6077 x-archive-orig-connection: close cache-control: max-age=1800 x-archive-guessed-content-type: text/xml x-archive-guessed-charset: windows-1250 memento-datetime: Sat, 26 Dec 2009 05:19:27 GMT link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate", ; rel="first memento"; datetime="Sat, 26 Dec 2009 05:19:27 GMT", ; rel="memento"; datetime="Sat, 26 Dec 2009 05:19:27 GMT", ; rel="next memento"; datetime="Mon, 29 Oct 2012 18:06:15 GMT", ; rel="last memento"; datetime="Thu, 23 Nov 2023 03:17:27 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: 51_13_20091226013528_crawl102_IndexOnly-c/51_13_20091226051846_crawl100.arc.gz server-timing: captures_list;dur=0.548052, exclusion.robots;dur=0.023713, exclusion.robots.policy;dur=0.010899, esindex;dur=0.014277, cdx.remote;dur=41.637991, LoadShardBlock;dur=520.793005, PetaboxLoader3.datanode;dur=232.872224, PetaboxLoader3.resolve;dur=492.435442, load_resource;dur=270.005270 x-app-server: wwwb-app204 x-ts: 200 x-tr: 870 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=1 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=() accept-ranges: bytes https://answers.oreilly.com/tag/mysql Fri, 18 Dec 2009 20:30:57 +0000 60 https://answers.oreilly.com/topic/905-updating-mysql-database-from-sql-server/ Thu, 01 Jan 1970 00:00:00 +0000 https://answers.oreilly.com/topic/905-updating-mysql-database-from-sql-server/ https://answers.oreilly.com/topic/622-how-to-find-duplicate-records-in-mysql-across-multiple-columns/ We have a MySQL 4 table of authors with separate first name and last name columns. I wanted to get a list of all possible duplicates (authors in the table with the exact same first name and last name... Tue, 10 Nov 2009 00:57:59 +0000 https://answers.oreilly.com/topic/622-how-to-find-duplicate-records-in-mysql-across-multiple-columns/ https://answers.oreilly.com/topic/448-how-to-use-sql-to-search-for-keywords-without-the-like-operator/ 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 ... Wed, 28 Oct 2009 06:06:07 +0000 https://answers.oreilly.com/topic/448-how-to-use-sql-to-search-for-keywords-without-the-like-operator/ https://answers.oreilly.com/topic/404-how-to-get-a-random-sample-in-sql/ Thu, 15 Oct 2009 14:36:02 +0000 https://answers.oreilly.com/topic/404-how-to-get-a-random-sample-in-sql/ https://answers.oreilly.com/topic/369-how-to-add-and-delete-users-to-a-web-database-using-php-and-mysql/ Fri, 02 Oct 2009 19:50:34 +0000 https://answers.oreilly.com/topic/369-how-to-add-and-delete-users-to-a-web-database-using-php-and-mysql/ https://answers.oreilly.com/topic/177-how-to-use-events-to-schedule-database-actions-in-mysql/ If you want to set up a database operation that runs periodically without user intervention, create an event that executes according to a schedule.As of MySQL 5.1, one of the capabilities... Mon, 14 Sep 2009 18:49:39 +0000 https://answers.oreilly.com/topic/177-how-to-use-events-to-schedule-database-actions-in-mysql/ https://answers.oreilly.com/topic/176-how-to-use-a-trigger-to-log-changes-to-a-table-in-mysql/ If you have a table that maintains current values of items that you track (such as auctions being bid on), but you’d also like to maintain a journal (or history) of changes to... Mon, 14 Sep 2009 18:10:10 +0000 https://answers.oreilly.com/topic/176-how-to-use-a-trigger-to-log-changes-to-a-table-in-mysql/ https://answers.oreilly.com/topic/175-how-to-simulate-timestamp-properties-for-other-date-and-time-types-in-mysql/ The TIMESTAMP data type provides auto-initialization and auto-update properties. If you would like to use these properties for other temporal data types, but the other ... Mon, 14 Sep 2009 18:02:17 +0000 https://answers.oreilly.com/topic/175-how-to-simulate-timestamp-properties-for-other-date-and-time-types-in-mysql/ https://answers.oreilly.com/topic/174-how-to-use-a-trigger-to-define-dynamic-default-column-values-in-mysql/ If a column in a table needs to be initialized to a nonconstant value, but MySQL allows only constant default values, use a BEFORE INSERT trigger. This e... Mon, 14 Sep 2009 17:46:00 +0000 https://answers.oreilly.com/topic/174-how-to-use-a-trigger-to-define-dynamic-default-column-values-in-mysql/ https://answers.oreilly.com/topic/173-how-to-create-compound-statement-objects-in-mysql/ If you want to define a stored routine, a trigger, or an event, but its body contains instances of the ; statement terminator, redefine the mysql statement terminator w... Mon, 14 Sep 2009 17:10:28 +0000 https://answers.oreilly.com/topic/173-how-to-create-compound-statement-objects-in-mysql/