INSERT INTO table (a,b,c) VALUES (1,2,3),(4,5,6)
ON DUPLICATE KEY UPDATE c=VALUES(a)+VALUES(b);string money = myCommand.ExecuteScalar().ToString();string money = myCommand.ExecuteScalar()?.ToString();string money = myCommand.ExecuteScalar()?.ToString() ?? "";$query = Database::instance('ssd2')->query(Database::SELECT, "SELECT * FROM `mp3s` USE INDEX (artist_2) WHERE `artist` = 'test' AND `id` > 453509 ORDER BY `id` LIMIT 10");
foreach($query as $row)
{
print_r($row);
}public function query($type, $sql, $as_object = FALSE, array $params = NULL);$data = array(
array('year','month','amount'),
array('2003','1','220'),
array('2003','2','153.5'),
);
$writer = new XLSXWriter();
$writer->writeSheet($data);
$writer->writeToFile('output.xlsx');Database -> Synchronize Model..., в конце, у вас есть скрипт. Вы просто берете его и применяете через миграцию.
CREATE FUNCTION digits( str CHAR(32) ) RETURNS CHAR(32)
BEGIN
DECLARE i, len SMALLINT DEFAULT 1;
DECLARE ret CHAR(32) DEFAULT '';
DECLARE c CHAR(1);
IF str IS NULL
THEN
RETURN "";
END IF;
SET len = CHAR_LENGTH( str );
REPEAT
BEGIN
SET c = MID( str, i, 1 );
IF c BETWEEN '0' AND '9' THEN
SET ret=CONCAT(ret,c);
END IF;
SET i = i + 1;
END;
UNTIL i > len END REPEAT;
RETURN ret;
ENDSELECT digits(t.somecol) FROM tablename
<?php
function connectDB() {
try {
$pdo = new PDO('mysql:host=localhost;dbname=#', 'root', '');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return $pdo;
} catch (PDOException $e) {
exit($e->getMessage());
}
}
function getA() {
$pdo = connectDB();
$select = $pdo->query("SELECT * FROM # ORDER BY id DESC", PDO::FETCH_ASSOC);
$result = $select->fetchAll();
var_dump($result);
}
getA();
?>