with AAA(A) as (
select 1 union
select 2 union
select 3 union
select 4 union
select 5
)
select 'А01' as "id",
1 as "sensor",
generate_series('2021-07-01 00:00:00', '2021-07-31 23:59:59', '10 sec'::interval) as "time",
t.status[floor(random()* 4 + 1)::int]
from (select array_agg(distinct AAA.A) as "status" from AAA ) as t ,
round((random()* 400 - 200)::numeric, 2) as "value"
$array = [
0 => [
'name' => 'Алексей',
'surname' => 'Петреченко',
'photo' => 'путь'
],
1 => [
'name' => 'Саша',
'surname' => 'Васильченко',
'photo' => 'путь'
]
];
foreach($array as $item) {
echo $item['name'];
echo $item['photo'];
}
If you adopt FSB1333-CPU and DDR3 1333 memory module on this motherboard, you need to adjust the jumper. Please short pin2, pin3 for FSB1 jumper. Otherwise, the CPU and memory module may not work properly on this motherboard. Please refer tobelow jumper setting.
SELECT event,
CONVERT_TZ(time, '+00:00', '-04:00') AS time1
FROM events
WHERE CONVERT_TZ(time, '+00:00', '-04:00') between '2021-06-24 00:00:00' AND '2021-06-24 23:59:59'
AND lang = 'ru'
SELECT event,
CONVERT_TZ(time, '+00:00', '-04:00') AS time1
FROM events
WHERE lang = 'ru'
HAVING time1 between '2021-06-24 00:00:00' AND '2021-06-24 23:59:59'
UPDATE users u1
CROSS JOIN users u2
SET u1.amount = u1.amount - $summa,
u2.amount = u2.amount + $summa
WHERE u1.id = $client
AND u2.id = $shop;
insert_query = """ INSERT INTO postgreetest_db (t1, t2, t3, t4, t5, t6, t7) VALUES (%s, %s, %s, %s, %s, %s, %s)"""
cursor.execute(insert_query, resultat)