source: branches/rel/html/install/batch/move_mailmaga_data.php @ 12157

Revision 12157, 433 bytes checked in by uehara, 17 years ago (diff)
Line 
1<?php
2/*
3 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
4 *
5 * http://www.lockon.co.jp/
6 *
7 */
8require_once("../../require.php");
9
10$objQuery = new SC_Query();
11
12$objQuery->begin();
13$arrCustomerMail = $objQuery->getAll("
14UPDATE dtb_customer
15SET mailmaga_flg = (
16SELECT mail_flag
17FROM dtb_customer_mail
18WHERE dtb_customer.email = dtb_customer_mail.email
19)");
20$objQuery->commit();
21
22echo "Àµ¾ï¤Ë°Ü¹Ô¤¬´°Î»Ãפ·¤Þ¤·¤¿¡£";
23
24?>
Note: See TracBrowser for help on using the repository browser.