/** * @return string */ public function build() { $ret = 'REPLACE ' . $this->options . ' INTO ' . $this->into; if ($this->values != NULL && count($this->values) > 0) { $ret .= ' VALUES ' . Array2d::build($this->values); } elseif ($this->set != NULL && count($this->set) > 0) { $ret .= ' SET ' . SetOperation::build($this->set); } elseif ($this->select != NULL && strlen($this->select) > 0) { $ret .= ' ' . $this->select->build(); } return $ret; }
/** * @return string */ public function build() { $ret = 'INSERT ' . $this->options . ' INTO ' . $this->into; if ($this->values != NULL && count($this->values) > 0) { $ret .= ' VALUES ' . Array2d::build($this->values); } elseif ($this->set != NULL && count($this->set) > 0) { $ret .= ' SET ' . SetOperation::build($this->set); } elseif ($this->select != NULL && count($this->select) > 0) { $ret .= ' ' . $this->select->build(); } if ($this->onDuplicateSet != NULL && count($this->onDuplicateSet) > 0) { $ret .= ' ON DUPLICATE KEY UPDATE ' . SetOperation::build($this->onDuplicateSet); } return $ret; }
/** * @return string */ public function build() { return 'SET ' . OptionsArray::build($this->options) . ' ' . SetOperation::build($this->set); }