SQL Query

SQL Query

Update Date - Minus 6 hours
update payments set created_at=DATE_SUB(created_at, INTERVAL 3600 MINUTE) where created_at between "2018-01-06 17:59:00" and "2018-01-07 07...
Sun, 7 Jan, 2018 at 6:10 AM
Update location/CMTS/DHCP
UPDATE clients SET services = REPLACE(services, 'dhcp\":\"2\"', 'dhcp\":\"5\"') WHERE location_id=14; UP...
Thu, 8 Feb, 2018 at 9:40 AM
export customers
SELECT c.id, c.name, c.middle_name, c.surname, c.information, c.service_id, c.subscription_status, c.expire_date, l.name, s.name FROM clients c INNER JOIN...
Sat, 24 Feb, 2018 at 10:44 AM