Skip to content

Instantly share code, notes, and snippets.

View sxfmol's full-sized avatar

sxf sxfmol

15 followers · 88 following
View GitHub Profile
@sxfmol
sxfmol / mysql_cheat_sheet.md
Created October 12, 2022 09:18 — forked from bradtraversy/mysql_cheat_sheet.md
MySQL Cheat Sheet

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

@sxfmol
sxfmol / proxy.py
Last active October 11, 2022 04:34 — forked from ngshiheng/pipelines.py
批量插入An example pipeline that uses bulk insert while saving scrapped item into database using SQLAlchemy.
import logging
from urllib.parse import urlencode
from scrapy.utils.project import get_project_settings
logger = logging.getLogger(__name__)
settings = get_project_settings()
@sxfmol
sxfmol / list.md
Created September 26, 2022 06:04 — forked from ih2502mk/list.md
Quantopian Lectures Saved
@sxfmol
sxfmol / 0_beautifulsoup.py
Created August 16, 2022 15:38 — forked from yoki/0_beautifulsoup.py
Beautiful soup cheat sheet: https://www.crummy.com/software/BeautifulSoup/bs4/doc/
# 10_basic.py
# 15_make_soup.py
# 20_search.py
# 25_navigation.py
# 30_edit.py
# 40_encoding.py
# 50_parse_only_part.py
@sxfmol
sxfmol / 0_reuse_code.js
Created March 25, 2017 14:59
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console