SELECT `t`.`id_thing`, `t`.`data`, JSON_ARRAYAGG(`n`.`note`) AS `all_notes`
FROM `things` AS `t`
LEFT JOIN `notes` AS `n` ON `n`.`id_thing` = `t`.`id_thing`
GROUP BY `t`.`id_thing`, `t`.`data`$items = DB::table('table')
->whereYear('created_at', 2021)
->selectRaw('month(created_at) month, count(*) count')
->groupBy('month')
->get();
db.execute("PRAGMA journal_mode=WAL")
CREATE TABLE [dbo].[StartFinish](
[DateStart] [datetime] NULL,
[DateFinish] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[StartFinish] WITH CHECK
ADD CONSTRAINT [CK_StartFinish] CHECK ((datediff(day,[DateStart],[DateFinish])>(0)))
GO
ALTER TABLE [dbo].[StartFinish] CHECK CONSTRAINT [CK_StartFinish]
GO
DECLARE @TextProduct NVARCHAR(MAX);
SELECT @TextProduct = CONCAT_WS( ', ', @TextProduct, [OrganizationCustomerId])
FROM [AZone2Adapter].[dbo].[_data_OrganizationCustomerSpecialties]
WHERE [OrganizationCustomerId]='1002775640209670'
SELECT @TextProduct AS TextProductMicrosoft SQL Server 2008
DECLARE @TextProduct NVARCHAR(MAX);
SELECT @TextProduct = STUFF(COALESCE(', ' + @TextProduct, '')
+ COALESCE(', ' + [OrganizationCustomerId], ''), 1, 2, '')
FROM [AZone2Adapter].[dbo].[_data_OrganizationCustomerSpecialties]
WHERE [OrganizationCustomerId]='1002775640209670'
SELECT @TextProduct AS TextProductПеред настройкой почтового клиента в меню «Настройки» почтового ящика на вкладке «Почтовые программы» необходимо отметить флажок в пункте «Я хочу получить доступ к почтовому ящику с помощью почтового клиента».
https://help.rambler.ru/mail/mail-pochtovye-klient...
Что такое instance
как это настроить?
public function addProduct(){
$query = 'INSERT INTO products (title, price, description, category, image, active) VALUES (?,?,?,?,?,?)';
$stmt = $this->db->prepare($query);
$stmt->bind_param("ssssss", $this->title, $this->price, $this->description, $this->category, $this->image, $this->$active);
$stmt->execute();
}
Options -Indexesautoindex off;FROM adverts as a,
category as c,
( category_advert as ca
LEFT JOIN advert_imgs as ai ON ai.main = 1 and ai.id_adv = a.id )$stmt = $link->prepare("SELECT * FROM users WHERE id=?");
$stmt->bind_param('i', $value);
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();