Skip to content

Instantly share code, notes, and snippets.

View kremilly's full-sized avatar
👋
Hello, World!

Kremilly kremilly

👋
Hello, World!
View GitHub Profile
[
{
"country": "Afghanistan",
"tld": "af"
},
{
"country": "Albania",
"tld": "al"
},
{
*{margin:0;padding:0;font-family:"Helvetica Neue", Helvetica, Helvetica, Arial, sans-serif}.logo{width:10em}img{max-width:100%}.center{text-align:center}.italic{font-style:italic}.border{border:0.05em solid rgba(192,192,192,0.5)}.border-bottom{border-bottom:0.05em solid rgba(192,192,192,0.5)}.bg{background:linear-gradient(to top left, #fff 0, #f7f7f7 100%)}.collapse{margin:0;padding:0}.padding{padding-top:.75em;padding-bottom:.75em}body{-webkit-font-smoothing:antialiased;-webkit-text-size-adjust:none;width:100% !important;height:100%;background:#f7f7f7}a{color:#2ba6cb}.btn{text-decoration:none;color:#fff;background-color:#666;padding:10px 16px;font-weight:700;margin-right:10px;text-align:center;cursor:pointer;display:inline-block}p.callout{padding:10px;font-size:1em;font-weight:600;color:#0076aa;background-color:#fff;margin-bottom:15px}.callout a{font-weight:700;color:#2ba6cb}table.social{background-color:#ebebeb}.social .soc-btn{padding:3px 7px;font-size:12px;margin-bottom:10px;text-decoration:none;color:#ff
[
{
"Code": "AF",
"Name": "Afghanistan"
},
{
"Code": "AX",
"Name": "Åland Islands"
},
{
@kremilly
kremilly / collations.json
Created April 17, 2021 07:44
Collations supported in phpmyadmin
[
"big5_chinese_ci",
"big5_bin",
"big5_chinese_nopad_ci",
"big5_nopad_bin",
"dec8_swedish_ci",
"dec8_bin",
"dec8_swedish_nopad_ci",
"dec8_nopad_bin",
"cp850_general_ci",
{
"server_queries": {
"processes": "SHOW FULL PROCESSLIST",
"variables": "SHOW VARIABLES",
"engines": "SHOW ENGINES",
"charsets": "SHOW CHARACTER SET",
"collations": "SHOW COLLATION",
"logs": "SELECT * FROM mysql.general_log ORDER BY event_time DESC LIMIT __param_offset__, __param_limit__"
},
"users_queries": {
{
"version": "1.1.27",
"copyright": "Colisoft",
"license": "Colisoft License",
"docs_page": "https://dbackpro.github.io/intellisense/#/",
"keywords": {
"using": "USING is useful when both the tables share a column of the exact same name on which they join.",
"btree": "A B-tree is a balanced tree not a binary tree. Once created, the database maintains the index automatically. It applies every insert, delete and update to the index and keeps the tree in balance, thus causing maintenance overhead for write operations.",
"engine": "Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default and most general-purpose storage engine, and Oracle recommends using it for tables except for specialized use cases.",
"aria": "Aria is a storage engines for the MariaDB and MySQL relational database management systems. Its goal is to make a crash-safe alternative to MyISAM.",
@kremilly
kremilly / activate-w11.bat
Created November 8, 2022 19:51
Script for activate Windows 11 Pro
slmgr /ipk W269N-WFGWX-YVC9B-4J6C9-T83GX
slmgr /skms kms8.msguides.com
slmgr /ato
@kremilly
kremilly / http-status-code.json
Created March 25, 2023 21:23
HTTP Status Code
{
"100": {
"code": "100",
"message": "Continue",
"description": "indicates that the initial part of a request has been received and has not yet been rejected by the server.",
"spec_title": "RFC7231#6.2.1",
"spec_href": "https://tools.ietf.org/html/rfc7231#section-6.2.1"
},
"101": {
"code": "101",
@kremilly
kremilly / countries.json
Last active April 1, 2023 11:24
ISO code of countries in world
[{"id":4,"alpha2":"af","alpha3":"afg","name":"Afghanistan"},
{"id":8,"alpha2":"al","alpha3":"alb","name":"Albania"},
{"id":12,"alpha2":"dz","alpha3":"dza","name":"Algeria"},
{"id":20,"alpha2":"ad","alpha3":"and","name":"Andorra"},
{"id":24,"alpha2":"ao","alpha3":"ago","name":"Angola"},
{"id":28,"alpha2":"ag","alpha3":"atg","name":"Antigua and Barbuda"},
{"id":32,"alpha2":"ar","alpha3":"arg","name":"Argentina"},
{"id":51,"alpha2":"am","alpha3":"arm","name":"Armenia"},
{"id":36,"alpha2":"au","alpha3":"aus","name":"Australia"},
{"id":40,"alpha2":"at","alpha3":"aut","name":"Austria"},