Skip to content

Instantly share code, notes, and snippets.

@un-ro

un-ro/elecomp.sql

Last active August 19, 2021 13:45
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save un-ro/6a7ee1e505796b62e5f8d0dbb55ff623 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save un-ro/6a7ee1e505796b62e5f8d0dbb55ff623 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
elecomp.sql
-- CHECK DATE
SELECT CURDATE();
-- SITEMAP AUTO 100%
INSERT INTO tbl_counter
VALUES
(0, 65, "ACEH", 1, CURDATE()),
(0, 65, "BALI", 1, CURDATE()),
(0, 65, "BANTEN", 1, CURDATE()),
(0, 65, "BENGKULU", 1, CURDATE()),
(0, 65, "GORONTALO", 1, CURDATE()),
(0, 65, "JAKARTA", 1, CURDATE()),
(0, 65, "JAMBI", 1, CURDATE()),
(0, 65, "JAWA BARAT", 1, CURDATE()),
(0, 65, "JAWA TENGAH", 1, CURDATE()),
(0, 65, "JAWA TIMUR", 1, CURDATE()),
(0, 65, "KALIMANTAN BARAT", 1, CURDATE()),
(0, 65, "KALIMANTAN SELATAN", 1, CURDATE()),
(0, 65, "KALIMANTAN TENGAH", 1, CURDATE()),
(0, 65, "KALIMANTAN TIMUR", 1, CURDATE()),
(0, 65, "KALIMANTAN UTARA", 1, CURDATE()),
(0, 65, "KEPULAUAN BANGKA BELITUNG", 1, CURDATE()),
(0, 65, "KEPULAUAN RIAU", 1, CURDATE()),
(0, 65, "LAMPUNG", 1, CURDATE()),
(0, 65, "MALUKU", 1, CURDATE()),
(0, 65, "MALUKU UTARA", 1, CURDATE()),
(0, 65, "NUSA TENGGARA BARAT", 1, CURDATE()),
(0, 65, "NUSA TENGGARA TIMUR", 1, CURDATE()),
(0, 65, "PAPUA", 1, CURDATE()),
(0, 65, "PAPUA BARAT", 1, CURDATE()),
(0, 65, "RIAU", 1, CURDATE()),
(0, 65, "SULAWESI BARAT", 1, CURDATE()),
(0, 65, "SULAWESI SELATAN", 1, CURDATE()),
(0, 65, "SULAWESI TENGAH", 1, CURDATE()),
(0, 65, "SULAWESI TENGGARA", 1, CURDATE()),
(0, 65, "SULAWESI UTARA", 1, CURDATE()),
(0, 65, "SUMATERA BARAT", 1, CURDATE()),
(0, 65, "SUMATERA SELATAN", 1, CURDATE()),
(0, 65, "SUMATERA UTARA", 1, CURDATE()),
(0, 65, "YOGYAKARTA", 1, CURDATE())
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment