mysql -u dbUser -p dbName < foobar.sql
LOAD DATA INFILE 'data.txt' INTO TABLE my_table;
"$data['phone']"."$data['dateadd']"."$data['name']"."$data['place']"
CREATE TABLE post (
-- ...
`creation_time` DATETIME DEFAULT CURRENT_TIMESTAMP, -- автоматически проставляется дата при создании
`modification_time` DATETIME ON UPDATE CURRENT_TIMESTAMP -- автоматически одновляется при редактировании
-- ...
)
DELETE FROM `posts` WHERE `active` = 0
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')
)