아래 SQL 쿼리문은 주어진 단어들을 deny_tld 테이블의 deny_tld 열에 순차적으로 넣는 것을 담고 있습니다.
중복을 덮어씌우기 위해서는 INSERT INTO … ON DUPLICATE KEY UPDATE 문법을 사용할 수 있으며 이렇게 하면 deny_tld 테이블에 중복된 값이 있을 경우에는 해당 값을 덮어 씌우고, 없을 경우에는 새로운 값을 추가할 수 있습니다. 오늘도 제가 사용한 mysql 쿼리문을 기록형으로 남깁니다.
INSERT INTO deny_tld (deny_tld, created_at)
VALUES
('io', NOW()),
('shop', NOW()),
('site', NOW()),
('buzz', NOW()),
('best', NOW()),
('ru.com', NOW()),
('pro', NOW()),
('xyz', NOW()),
('life', NOW()),
('sa.com', NOW()),
('za.com', NOW()),
('live', NOW()),
('sh', NOW()),
('world', NOW()),
('me', NOW()),
('cloud', NOW()),
('us', NOW()),
('co', NOW()),
('online', NOW()),
('store', NOW()),
('group', NOW()),
('mba', NOW()),
('ac', NOW()),
('today', NOW()),
('vip', NOW()),
('digital', NOW()),
('club', NOW()),
('agency', NOW()),
('media', NOW()),
('city', NOW()),
('email', NOW()),
('team', NOW()),
('network', NOW()),
('company', NOW()),
('business', NOW()),
('fun', NOW()),
('wtf', NOW()),
('guru', NOW()),
('mobi', NOW()),
('ink', NOW()),
('work', NOW()),
('run', NOW()),
('gold', NOW()),
('news', NOW()),
('studio', NOW()),
('golf', NOW()),
('finance', NOW()),
('plus', NOW()),
('marketing', NOW()),
('house', NOW()),
('tech', NOW()),
('works', NOW()),
('show', NOW()),
('wiki', NOW()),
('design', NOW()),
('ltd', NOW()),
('events', NOW()),
('watch', NOW()),
('center', NOW()),
('casino', NOW()),
('solutions', NOW()),
('fitness', NOW()),
('tours', NOW()),
('boutique', NOW()),
('art', NOW()),
('bar', NOW()),
('systems', NOW()),
('directory', NOW()),
('support', NOW()),
('tv', NOW()),
('fund', NOW()),
('space', NOW()),
('land', NOW()),
('camp', NOW()),
('express', NOW()),
('tools', NOW()),
('international', NOW()),
('expert', NOW()),
('money', NOW()),
('gay', NOW()),
('school', NOW()),
('social', NOW()),
('deals', NOW()),
('capital', NOW()),
('dog', NOW()),
('app', NOW()),
('lol', NOW()),
('management', NOW()),
('consulting', NOW()),
('credit', NOW()),
('clinic', NOW()),
('engineering', NOW()),
('health', NOW()),
('bio', NOW()),
('blog', NOW()),
('rip', NOW()),
('services', NOW()),
('cool', NOW()),
('sale', NOW()),
('football', NOW()),
('training', NOW()),
('exchange', NOW()),
('care', NOW()),
('vision', NOW()),
('zone', NOW()),
('enterprises', NOW()),
('fyi', NOW()),
('video', NOW()),
('construction', NOW()),
('website', NOW()),
('haus', NOW()),
('education', NOW()),
('ventures', NOW()),
('red', NOW()),
('games', NOW()),
('mortgage', NOW()),
('cafe', NOW()),
('holiday', NOW()),
('broker', NOW()),
('mom', NOW()),
('monster', NOW()),
('pics', NOW()),
('toys', NOW()),
('rocks', NOW()),
('homes', NOW()),
('restaurant', NOW()),
('photography', NOW()),
('delivery', NOW()),
('foundation', NOW()),
('tax', NOW()),
('partners', NOW()),
('coach', NOW()),
('salon', NOW()),
('trade', NOW()),
('software', NOW()),
('solar', NOW()),
('dating', NOW()),
('auction', NOW()),
('yachts', NOW()),
('pet', NOW()),
('shopping', NOW()),
('host', NOW()),
('jewelry', NOW()),
('limited', NOW()),
('bet', NOW()),
('green', NOW()),
('kim', NOW()),
('pizza', NOW()),
('blue', NOW()),
('gmbh', NOW()),
('insure', NOW()),
('pw', NOW()),
('place', NOW()),
('id', NOW()),
('in.net', NOW()),
('singles', NOW()),
('desi', NOW()),
('how', NOW()),
('hockey', NOW()),
('parts', NOW()),
('doctor', NOW()),
('properties', NOW()),
('markets', NOW()),
('builders', NOW()),
('productions', NOW()),
('hospital', NOW()),
('cleaning', NOW()),
('reviews', NOW()),
('creditcard', NOW()),
('sbs', NOW()),
('bingo', NOW()),
('coffee', NOW()),
('immobilien', NOW()),
('guide', NOW()),
('clothing', NOW()),
('supplies', NOW()),
('style', NOW()),
('kaufen', NOW()),
('market', NOW()),
('estate', NOW()),
('luxury', NOW()),
('poker', NOW()),
('hair', NOW()),
('autos', NOW()),
('tips', NOW()),
('quest', NOW()),
('fan', NOW()),
('dev', NOW()),
('photos', NOW()),
('recipes', NOW()),
('cyou', NOW()),
('icu', NOW()),
('cam', NOW()),
('beauty', NOW()),
('financial', NOW()),
('charity', NOW()),
('taxi', NOW()),
('accountants', NOW()),
('cheap', NOW()),
('industries', NOW()),
('villas', NOW()),
('sex', NOW()),
('codes', NOW()),
('republican', NOW()),
('associates', NOW()),
('vin', NOW()),
('bike', NOW()),
('ninja', NOW()),
('organic', NOW()),
('moda', NOW()),
('gifts', NOW()),
('fish', NOW()),
('engineer', NOW()),
('community', NOW()),
('technology', NOW()),
('camera', NOW()),
('vacations', NOW()),
('coupons', NOW()),
('black', NOW()),
('pub', NOW()),
('investments', NOW()),
('cash', NOW()),
('direct', NOW()),
('fit', NOW())
ON DUPLICATE KEY UPDATE created_at = NOW();
리눅스 명령어만 따로 모아 글을 작성 하고 있습니다. 필요하신 분들은 참고 하세요.
