ecshop数据库

ALTER TABLE `hunuo_admin` ADD `mobile` VARCHAR( 30 ) NOT NULL DEFAULT '' COMMENT '手机' AFTER `email`

"select GROUP_CONCAT(distinct goods_id SEPARATOR '&') from ".$ecs->table('huanzhuang')."
where concat(',',responsible_user,',') like '%,1,%'
truncate table xxx;
del =CONCAT(del,',$user_id');
$db->insert_id();
$GLOBALS['db'],$GLOBALS['ecs']
$sql = "SELECT g.*, a.attr_type FROM " . $ecs->table('goods_attr') . " AS g LEFT JOIN " . $ecs->table('attribute') . " AS a ON a.attr_id = g.attr_id WHERE g.goods_id = '$goods_id'";
$sql="SELECT msg_id FROM ".$ecs->table('message')." where msg_id='$msg_id'";
$sql="UPDATE " . $ecs->table('goods_gallery') . " SET img_original='' WHERE goods_id='$goods_id'";
$sql="UPDATE " . $ecs->table('goods_gallery') . " SET img_original='' WHERE goods_id='$goods_id'";
$sql="INSERT INTO " . $ecs->table('goods_gallery') . " (goods_id, img_url) VALUES ('$goods_id', '$img_url')";
$db->getOne($sql);
$db->getCol($sql);
$db->getRow($sql);
$db->getAll($sql);
$db->query($sql);
$db->autoExecute($ecs->table('goods'), $arr, 'INSERT');
$db->autoExecute($ecs->table('goods'), $arr, 'UPDATE', "goods_id = '".$goods_id."'");
$GLOBALS['db']->selectLimit($sql, $size, ($page - 1) * $size)