sigridjineth / mysql_tablecsv.md

Last active March 13, 2021 02:54

How to load csv files into MySQL tables (for Docker users)

요구사항

MySQL 테이블 스키마에 맞는 대량의 데이터를 보유하고 있는 CSV 파일을 MySQL에 집어넣고자 한다.
Mac 환경에서 Docker를 기반으로 MySQL 8 이미지를 실행하고 있다.

파일 옮기기

로컬에서 작업하고 있는 CSV 파일을 도커 컨테이너로 옮긴다.
docker ps -a 명령어를 통해 현재 도커 컨테이너의 아이디를 검색한다.
다음의 cp 명령어를 실행하여 도커 컨테이너로 csv 파일을 복사한다.

bradtraversy / mysql_cheat_sheet.md

Last active March 9, 2025 15:31

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

MySQL Locations

Mac /usr/local/mysql/bin
Windows /Program Files/MySQL/MySQL version/bin
Xampp /xampp/mysql/bin

Add mysql to your PATH

appkr / yark-shaving.md

Last active November 9, 2020 04:45

러시아 페인트공, 마세라티, 야크 털깍기

러시아 페인트공 알고리즘

페인트공이 첫날은 차선 페인트 작업을 300야드 칠함 둘째 날은 150야드 칠함 셋째 날은 30야드 칠함 첫 날은 어떻게 10배를 칠했는지 관리자가 묻자 저도 어쩔 수 없었습니다. 매일 페인트 통에서 점점 멀어지니까요

"조엘 온 소프트웨어" by 조엘스폴스키(스택오버플로, 트렐로 창업자)

ToddKerpelman / 0_BigQuery_Recipes.md

Last active October 24, 2022 15:08

A handful of BigQuery SQL queries that you can use to analyze your own Google Analytics for Firebase data. To find out more about how they work, check out our presentation from Cloud Next 2018 (Video link to be added soon)

Please note that these scripts have been updated to make sure of the new Firebase schema, which was rolled out to Analytics products in July of 2018.

Note that none of these scripts will work out of the box -- you'll need to update the values in brackets with the names of your actual datasets, and you'll most likely also need to replace the names of events and event properties with ones that are appropriate for your app.

The contents of this gist are licensed under the Apache License, version 2.0

pierrejoubert73 / markdown-details-collapsible.md

Last active March 10, 2025 06:52

How to add a collapsible section in markdown.

How to add a collapsible section in markdown

1. Example

Click me

Heading

Foo
Bar
- Baz

Qux

iamstoick / import.md

Created June 14, 2017 05:03

How to import database in MySQL in Docker?

This is a simple way of importing MySQL database in Docker.

In you Dockerfile you must have a shared folder. Shared folder is a directory in your host machine that is mounted to Docker instance.
Put the exported sql file in the shared folder.
Login to your Docker instance via docker exec -it DOCKER_CONTAINER_ID bin/bash.
Login to MySQL via mysql -u USERNAME -p.

akashnimare / README.md

Last active October 16, 2024 18:49

A Beginners Guide to writing a Kickass README ✍

Project title

A little info about your project and/ or overview that explains what the project is about.

Motivation

A short description of the motivation behind the creation and maintenance of the project. This should explain why the project exists.

Build status

Build status of continus integration i.e. travis, appveyor etc. Ex. -

fredbenenson / kickstarter_sql_style_guide.md

Last active February 3, 2025 22:47

Kickstarter SQL Style Guide

layout

title

description

Purpose

squarism / iterm2.md

Last active March 10, 2025 06:54

An iTerm2 Cheatsheet

Tabs and Windows

Function	Shortcut
New Tab	`⌘` + `T`
Close Tab or Window	`⌘` + `W` (same as many mac apps)
Go to Tab	`⌘` + `Number Key` (ie: `⌘2` is 2nd tab)
Go to Split Pane by Direction	`⌘` + `Option` + `Arrow Key`
Cycle iTerm Windows	`⌘` + `backtick` (true of all mac apps and works with desktops/mission control)

ihoneymon / how-to-write-by-markdown.md

Last active March 6, 2025 23:04

마크다운(Markdown) 사용법

[공통] 마크다운 markdown 작성법

영어지만, 조금 더 상세하게 마크다운 사용법을 안내하고 있는
"Markdown Guide (https://www.markdownguide.org/)" 를 보시는 것을 추천합니다. ^^

아, 그리고 마크다운만으로 표현이 부족하다고 느끼신다면, HTML 태그를 활용하시는 것도 좋습니다.

WonTaek Hwang timetobye