Я правильно понимаю, что могу задать столбцу размер decimal(63,2)?
то есть нужно ли отнимать от максимального размера размер после запятой или пишем decimal(65,2)?
SELECT u.login,
u.password,
u.email,
u.aut,
s.setting_1,
s.setting_2,
s.setting_3,
s.setting_4,
s.setting_5,
s.setting_6,
s.setting_7,
s.setting_8,
s.setting_9
FROM Regs_Stats s
INNER JOIN Regs_User3 u on u.login = s.login
select * from <TABLE> where <field> regexp '^5,|,5,|,5$'
select l.prod, l.id list_id, l.list_val from list l left join main m on <Дальше сам>
SELECT * FROM `objects`
WHERE `bid_type`='$bid_type'
AND `object_type`='$object_type'
AND (`address` LIKE '%$address%'
OR `okrug` LIKE '%$address%')
select d.value,
count(*) users_count
from user u
left join (select user_id, data1.text value from data1
union all
select user_id, data2.name value from data2
) d on d.user_id = u.id
group by d.value
begin
insert into ..... returning id into :id;
-- ...
commit;
end;
SELECT a.name
sum(a.zarp)
FROM (SELECT name,
IFNULL(zarp, 0) zarp
FROM PRIC
union all
SELECT name,
IFNULL(amount, 0) zarp
FROM AMO
) A
GROUP BY a.name
SELECT * FROM number_1 WHERE branch LIKE '%текст%'
[
{ "command": "delete_to_mark", "caption": "Удалить!!", "mnemonic": "Windows" },
]