修改订单开始序号

来源:互联网 发布:实数绝对值用c语言 编辑:程序博客网 时间:2024/05/17 01:44

How do I change the starting value of my order numbers ?

Assuming your database prefix is isc_, then you would run the following sql using phpmyadmin
ALTER TABLE tbl AUTO_INCREMENT = 100;
which would start any future order numbers at 100;

changeStart.php 内容:

 

<?php
$start = 2000;
require(dirname(__FILE__)."/init.php");
$GLOBALS['ISC_CLASS_DB']->Query("ALTER TABLE [|PREFIX|]orders AUTO_INCREMENT = ".$start);
echo "Done";
?>

原创粉丝点击