Specifies a default value for a column. With one exception, the default value must be a constant; it cannot be a function or an expression. This means, for example, that you cannot set the default for a date column to be the value of a function such as NOW() or CURRENT_DATE. The exception is that you can specify CURRENT_TIMESTAMP as the default for a TIMESTAMP or DATETIME column.https://dev.mysql.com/doc/refman/5.7/en/create-tab...
$records = R::dispense('table', 100);
for($i = 0; $i < 100; $i++) {
$records[$i]->data = $someData;
}
R::storeAll($records);Зачем в MySQL была разрешена возможность создавать объекты в верхнем и нижнем регистреесли кратко: она ведет себя как файловая система на которой установлена.
возможно ли это отключить?https://dev.mysql.com/doc/refman/5.7/en/server-sys...
Too few arguments to function Modules\User1::__construct(), 0 passed and exactly 1 expectedв конструкторе User1 ожидается 1 параметр, передано 0 параметров.
return $this->_db->run($sql, [$id])->fetchObject(__CLASS__);return $this->_db->run($sql, [$id])->fetchObject(__CLASS__, [$this->_db]);CREATE TABLE `users` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT NULL,
`amount` float DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
INSERT INTO `users` (`id`, `name`, `amount`)
VALUES
(1,'user1',11.589),
(2,'user2',478.541),
(3,'user3',0.258);$db = new mysqli('localhost', 'root', '', 'mytests');
$db->options(MYSQLI_OPT_INT_AND_FLOAT_NATIVE, 1);
$query = 'SELECT * FROM users';
$result = $db->query($query);
while($row = $result->fetch_assoc()) {
var_dump($row);
};
array(3) {
'id' =>
int(1)
'name' =>
string(5) "user1"
'amount' =>
double(11.589)
}
array(3) {
'id' =>
int(2)
'name' =>
string(5) "user2"
'amount' =>
double(478.541)
}
array(3) {
'id' =>
int(3)
'name' =>
string(5) "user3"
'amount' =>
double(0.258)
}SELECT
*
FROM
`dle_post`
JOIN
`dle_post_extras` ON `dle_post_extras`.id = `dle_post`.id