INSERT INTO tbl_name (a,b,c)
VALUES
(1,2,3),
(4,5,6),
(7,8,9);
select user_id, time ftom myTable where time > now() - interval 2 second
select user_id ftom myTable
where time > now() - interval 2 second
group by user_id
having COUNT(*) > 1
INSERT INTO tbl3 (username, password, email, ip)
SELECT name, pass, email, null FROM tbl1
INSERT INTO tbl3 (username, password, email, ip)
SELECT user, password, email, ip FROM tbl2
select email from users where id in(
select distinct publisher_id from apartments where publisher_type=0
)
UNION
select email from organizations where id in(
select distinct publisher_id from apartments where publisher_type=1
)
select foo from apartments a
left join user_table u on u.id=a.user_id AND a.publisher_type=0
left join organization_table o on o.id=a.organization_id AND a.publisher_type=1
SELECT users.*, sum(payments.amount) as `summ`
FROM `users`
LEFT OUTER JOIN `payments` ON `users`.`id` = `payments`.`user_id`
WHERE payments.created_at BETWEEN '2017-05-19 14:23:46' and '2017-06-19 14:23:46'
AND `status` = 2
GROUP BY user.id
SELECT P.post FROM fields_post AS P, fields AS F
WHERE P.field = F.id
AND (
(P.value = 'Medium' AND F.name = 'Size')
OR -- это важно
(P.value = 'Purebred' AND F.name = 'Type')
)
SELECT t1.radacctid
, t1.username
, t1.acctstarttime
, t1.acctstoptime
, t1.framedipaddress
, COUNT(*) as cnt
FROM radpostauth t1
WHERE exists (
SELECT *
FROM radacct t2
WHERE
`nasipaddress` = '146.120.17.42'
AND t1.authdate between t2.acctstarttime AND t2.acctstoptime
)
AND `reply` = 'Access-Accept'
AND `authdate` BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW()
GROUP BY t1.`username` -- это важно
mysqldump --skip-opt --set-charset --skip-set-charset
(тут надо еще указать базу и логин-пароль)mysql --default-character-set=<your iso encoding>